cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

OneDrive - Excel Get Rows - Create Sharepoint Item

Hi guys,

 

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:

 

Screen Shot 2017-08-25 at 10.01.01 am.png

If anyone can help that would be great!

Thanks in advance

4 REPLIES 4
Community Support Team
Community Support Team

Re: OneDrive - Excel Get Rows - Create Sharepoint Item

Hi @Anonymous,

 

 

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,

38.PNG

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:

39.PNG

Regards,

Michael

Community Support Team _ Michael Shao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Anonymous
Not applicable

Re: OneDrive - Excel Get Rows - Create Sharepoint Item

@v-micsh-msft

 

 

 

 

Highlighted
iMisa
Level: Powered On

Re: OneDrive - Excel Get Rows - Create Sharepoint Item

hi,

 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?

bilaldev1
Level: Power Up

Re: OneDrive - Excel Get Rows - Create Sharepoint Item

@v-micsh-msft

hi,

 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

Bilal

Helpful resources

Announcements
firstImage

Power Platform Online Conference

Join us for the first ever Power Platform Online Conference!

firstImage

Incoming: New and improved badges!

Look out for new contribution recognition badges coming SOON!

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

seventhimage

Webinars & Video Gallery

Watch & learn from the Power Automate Community Video Gallery!

Top Solution Authors
Top Kudoed Authors
Users online (4,794)