In the “Choose an Operation” panel, select “Control”.
Select the control labeled “Apply to Each”.
We need to use an output from the previous step. Scrolling down the list of Dynamic Content, we select “Value” from the list.
Next, click “Add an Action” to add another “Control”. This time we will use a “Condition”.
This allows checking to see if something occurs based on some form of logic and then act in one of two fashions. This is like writing an IF statement in Excel except it will be created using all point-and-click actions.
Our objective is to cross-check the name of the PDF file against the current row’s defined filename.
We need to point to the column in the Excel file labeled “File Name”.
Scrolling down the list of Dynamic Content, we come across an entry for the “File Name” field from the Excel file’s table.
Next, we set the logical operator to “is equal to” and set the comparator to the “Display Name” option.
Adding the “Yes” Action
To define what happens if one of the PDF file’s display names matches the listed filename in the Excel cell, click the “Add an Action” located in the “If Yes” panel.
Like we did previously, in the “Choose an Operation” panel, search for “OneDrive” and select “OneDrive for Business”.
Scroll down the list of Actions to locate the “Get File Content” action.
In the “Get File Content” panel, scroll down the list of Dynamic Content and select “Id”.
Click “Add an Action” to begin setting up the email operation.