Recently I posted a question on how I would build a certain flow:
I received no reply, so I've started just attempting to build it myself and I've already hit a roadblock. I don't know how to, when the file is submitted, to grab the data from the excel sheet and send off emails based on it. Can provide more screenshots if needs be.
The 'Submitted to' column is the name of the approver the email would need to be sent to.
Hi @AMcmasterSage ,
I assume the uploaded excel file has only one table.
I did a sample for you.
Thanks for this, I've set it up as you've laid out but it doesn't seem to be working;
This is the error being returned; Any ideas?
See above; Current state of the flow. On retrying your setup, I found the expression was registering as invalid. This setup works, but doesn't actually gather any data (The 'Get Tables' simply returns  as the value) and the last step is just skipped. Any thoughts?
Keep up to date with current events and community announcements in the Power Automate community.
A great place where you can stay up to date with community calls and interact with the speakers.
Check out the latest Community Blog from the community!