cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
AMcmasterSage
Helper I
Helper I

Pulling Data from Excel

Hi All!

Recently I posted a question on how I would build a certain flow:

 

https://powerusers.microsoft.com/t5/Building-Flows/Flow-Concept-Would-it-work-and-how/m-p/1437183

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.

2022-02-07_11h48_43.png

 

2022-02-07_11h50_21.png

 The 'Submitted to' column is the name of the approver the email would need to be sent to.

6 REPLIES 6
v-xiaochen-msft
Community Support
Community Support

Hi @AMcmasterSage ,

 

I assume the uploaded excel file has only one table.

I did a sample for you.

vxiaochenmsft_0-1644374361054.png

outputs('Get_tables')?['body/value'][0]?['id']
vxiaochenmsft_1-1644374385366.png

 

vxiaochenmsft_2-1644374434033.png

 

Best Regards,

Wearsky

 

Hi Wearsky,

Thanks for this, I've set it up as you've laid out but it doesn't seem to be working;

2022-02-09_14h32_36.png

 

This is the error being returned; Any ideas?

v-xiaochen-msft
Community Support
Community Support

Hi @AMcmasterSage ,

 

No idea. 

It works for me.

 

Best Regards,

Wearsky

2022-04-06_13h40_52.png

 

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?

Hi Guys, bumping, because I haven't had a response on this and really need help

AMcmasterSage
Helper I
Helper I

Bumping... Again. I really need a solution for this.

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Community Calls Conversations

Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Users online (1,332)