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.
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 openingdirectly 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.
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.