Working on flow where email excel attachment saved to SharePoint and then select one row (with emails) from document and able to send an custom email to all email users.

[Wesleym]

Working on flow where email excel attachment saved to SharePoint and then select one row (with emails) from document and able to send an custom email to all email users.

I have been working on one flow:

• Where I can Save an email Excel attachment to SharePoint site (I found a template and it works)
• Then capture one row information (emails) from Excel sheet attachment from an email; and send email to that list of members in one row

I tried two approaches - one is saving excel sheets in SharePoint then opening directly Excel sheet and use the Flow Add-In, choose the “select row” option through excel sheet. This approach puts me in two step process.

I searched for templates but couldn't find any that meets my criteria. Then I tried to create a flow where I can combine both process, but I realized "select row option is not working as a part of flow and only working in single/individual document.

ASK: If anyone knows any templates or existing flows that combine both steps into one flow please suggest.

Thanks, 

Wes

[Powerplatform01]

Hi @Wesleym 

Could you please refer this video. Also request you to please subscribe it.

https://youtu.be/Kb-Fsvhk-YQ