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
Using the file path will not work.
Here we need switch it to the File Identifier.
But something that you should take a note:
1. For the trigger, it will fire with any file type, and only file type is the Excel file format, the Get Rows will work.
2. In addition to the File Name, there is also a Table name there would be needed to input, and the table name is depending on the inputted File Name. We need to know the Table Name when designing the flow,
So the situation here is, to have all the files uploaded into this OneDrive folder restricted to only Excel file, and make the table name a unified standard.
For example, all excel files uploaded should contain only one table with the corresponding table name set to Table2, then the flow would work:
Thanks for the reply.
I had already tried that previously with no sucess.
However, I did seem to fix the issue by remaking the document template - It seemed that the file kept corrupting.
I dont suppose whilst I have you here you could help with another question please?
In the same flow id like it to lookup a 2 column list ive made on sharepoint.
Using the 'Brand' value from the Excel sheet lookup in the list in Column 1 and Return the value from Column 2 of the list
Is this possible in the lists to do this? If not could it be done with a constant Excel doc (I tried this method but I cannot do an 'Apply to Each' inside an 'Apply to Each' - My thinking was to loop through the supplied document then loop through the 'Brand Contact' document until it finds the Brand and return the Brand Contact.
what if there is not table on the attached excel file? how to extract the datas and put it in another excel file that has table?
Thanks in advance
Join us for the first ever Power Platform Online Conference!
Look out for new contribution recognition badges coming SOON!
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!
Find out where you can attend!
Watch & learn from the Power Automate Community Video Gallery!