Power Platform Community Forum Thread Details

Get file content if file name match from excel

Hi Experts,

Pls assist me on this scenario, not able to filter the list of files from one drive with condition if file name and FileName column match in excel.

Not use apply to each because two files to be attached in a single email based on user column of the excel. Apply to each file name for a user triggering two emails.

it's really frustrating to figure out the solution from past 5 days. Either the condition to match file name with excel not matching or not able to compose multiple files outside of apply to each.

1st image initialising variable and appending variable for get file content from one drive

2nd image filtering unique subject from excel table to send email

3rd trying filter the variable which is list of files which match with file name in the excel associated with the unique subject line(more than one rows may have unique subject line because the user is same)

Issue is with filtering the variable the 3rd image