I am trying to create a flow that will read excel files and based on a column (SellerCode) it will send an email to the account that corresponds to this Code with data from the excel row. The accounts and codes are stored in a SharePoint List since i dont have the email stored in the excel file.
if i use a recurrent flow is there a way i can get all files instead of selecting the file and table in the List row action?
The variable i use works if there is only 1 row in the excel file. What if there are more and i have to send emails to more than 1 accounts?
In the get items i use a filter query
Any help would be appreciated
