How to get table data from excel file upload to onedrive then input to send mail

(0) Share

Report

Posted on by Onvateenow

Hello Sir

Excel file will be uploaded to onedrive every month then my automate flow get data in table excel file to send mail.

Could you advise us how to create automate ?

Note: The uploaded file name excel file is difference but table name in excel is the same.

Thanks a lot.

Categories:

Building flows

I have the same question (0)

All responses (5)

Answers (1)

Sort by

v-zhoqian-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Onvateenow ,

If table name in excel is the same, you could enter the table manually, as shown in the following picture:

Best Regards,
Habsburg Qian
If this post helps, then please consider Accept it as the solution to help the other members find it.

Was this reply helpful? Yes No
Onvateenow 15 on at

Like
a
(0)

Report
Copy link

Link copied!

Hello @v-zhoqian-msft
Thank you for your advise. We tried as your advise but we don't have dynamic content to get data from table excel to send mail look like as below picture. Please advise us.

Was this reply helpful? Yes No
v-zhoqian-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Onvateenow ,

In this way, the flow can get the data in the table, but fields will not be displayed in the dynamic content in advance. You need to use expression to get the field value, as follows:

Best Regards,
Habsburg Qian
If this post helps, then please consider Accept it as the solution to help the other members find it.

Was this reply helpful? Yes No
Onvateenow 15 on at

Like
a
(0)

Report
Copy link

Link copied!

Hello @v-zhoqian-msft
Thank you for your excellenct support.
We tried and tested flow then we found error as below picture. I think you had created same as my flow but do you found the same my error?

Was this reply helpful? Yes No
Verified answer

Onvateenow 15 on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @v-zhoqian-msft
We have solution for my error by change to use id as blue box in below picture.
Thank you for helping.

Was this reply helpful? Yes No