Pulling Data from Excel

[AMcmasterSage]

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.

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

[v-xiaochen-msft]

Hi @AMcmasterSage ,

I assume the uploaded excel file has only one table.

I did a sample for you.

outputs('Get_tables')?['body/value'][0]?['id']

Best Regards,

Wearsky

[AMcmasterSage]

Hi Wearsky,

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?

[v-xiaochen-msft]

Hi @AMcmasterSage ,

No idea. 

It works for me.

Best Regards,

Wearsky

[AMcmasterSage]

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?

[AMcmasterSage]

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

[AMcmasterSage]

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