I am new to the community and to Flow but it looks a powerful tool if you know what you are doing with it!
I am having some challenges trying to pull data from an Excel sheet and was hoping someone could point me in the right direction:
The goal is:
1. Client supplies an Excel file via email
2. Flow picks it up and places in OneDrive.
3. Flow then uses the get rows to loop through each line.
4. Flow then creates a new item in a list already setup from the data from the sheet.
So far I have managed to get the Flow working fully if I pick the Excel file already on OneDrive.
What I cant get working is for Flow to use the file supplied via email dynamically.
Ive seen some posts online about playing around with the sheet name to use filepath and file identifier with no luck on both (both give me different errors)
Error with using File path: Failed to read metadata from file source: Response from the end service is: Bad Request
Error with using File Identifier: Failed to read metadata from file source: Response from the end service is: Not Found
Please see SS of the Flow below:
If anyone can help that would be great!
Thanks in advance
I'm afraid that this cannot be achieved so far. As you could see, the File Name field in get rows need to be specified and cannot be a dynamic content. The table field also need to be picked from the dropdown list when you create the flow.
If you need this, please post this idea in the Flow Ideas forum, so it might be considered for future releases.
I found a solution but via a different method.
I wasnt able to generate a list from and email attachment as you need to select the workbook and table number within the flow.
I got it working by having a fixed document on my OneDrive rather than having it from an Email.
But, In theory you might be able to get the email attachment to update the 'fixed' document first and then fire that to the Sharepoint list?
Hope this helps?
Yes I also came to the same solution as a workaround. It fell apart for me though as my Excel contains formulas which are not currently supported.
you could just remove them before uploading/emailing.
Select all the rows/columns, copy and paste special as values.
Not ideal but would work
I'm setting up a flow for users to enter info into an excel template with a hidden sheet that will perform calculations based on the user input. I then need those results to be added to a sharepoint list when the excel is emailed to me.
This is a form sent multiple times a day and I don't want to have to edit each one every time. There's another discussion regarding this issue here
In the long run I'm working on a better plan using powerapp sharepoint list forms but they are still missing alot of the capabilities I require.
Three Super User rank tiers have been launched!
Features releasing from October 2020 through March 2021
We've updated and improved the layout and uploading format of the Power Automate Cookbook!
Fill out a quick form to claim your user group badge now!