cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Advocate I
Advocate I

From multiple Excel sources to a Sharepoint list

Hi,

 

My Flow is triggered when a file is created or modified on sharepoint. I am currently checking the filename of the upload so it only stores the data from files that contain the word 'Workbook'.

If yes then Get Row (Excel for Business) then add to sharepoint list, I have to manually select a excel file for it to work.

However, I want this to work for all Excel Files with 'Workbook' in the title. I've tried entering the dynamic file/location name here but it fails each time, I'm not sure if there needs to be a specific format for this to work? 

(The table names in each Excel file will be the same)

 

Please Help 🙂 

5 REPLIES 5
Highlighted
Community Support
Community Support

Re: From multiple Excel sources to a Sharepoint list

Hi @ lcrossling,

 

Could you please share a screenshot of the configuration of your flow?

 

Could you please share more details about the error that you meet when the flow runs?

 

If you use the trigger when a file is created or modified on sharepoint,even though the file is a excel file, you couldn't use the "Get Rows" to get the row of the excel file,the action wouldn't support you to enter the dynamic file/location name to get the excel file,all action of excel would process a existing excel file currently.

 

So if you would like to get the row of the excel file, you could save the excel file in your onedrive or sharepoint library firstly,and then you could get row of the excel file and have some process on it.

 

Please let me know if your problem could be solved.

 

 

 

Regards,
Alice Zhang

Highlighted
Advocate I
Advocate I

Re: From multiple Excel sources to a Sharepoint list

Flow Screenshot :This is how I built my flow for when it only read in one Excel file (This works fine)

 

Flow Screenshot 2 : This is how I want my flow to work to read in multiple Excel files. However this method produces the following error: 

{
  "error": {
    "code"502,
    "source""europe-001.azure-apim.net",
    "clientRequestId""280efee1-b0cd-4a71-93c3-a65358f1741e",
    "message""BadGateway",
    "innerError": {
      "status"502,
      "message""The request is malformed or incorrect.\r\nclientRequestId: 280efee1-b0cd-4a71-93c3-a65358f1741e",
      "source""excelonline-we.azconn-we.p.azurewebsites.net"
    }
  }
}

 

 Let me know if anyone knows a way around this issue

Highlighted
Community Support
Community Support

Re: From multiple Excel sources to a Sharepoint list

Hi @ lcrossling,

 

Your flow run failed because you have enter the dynamic content of file name in the "File" field of "Get a row" action.

 

The required value in the "File" field of "Get a row" action is the file path,you could only choose a file in the "File" field of "Get a row" action to get a file.you couldn't write a file path in the "File" field of "Get a row" action.

 

If you would like to write a file path in the "File" field of "Get a row" action in Microsoft Flow, please submit an idea to Flow Ideas Forum:

https://powerusers.microsoft.com/t5/Flow-Ideas/idb-p/FlowIdeas

 

 

Please let me know if your question could be solved.

 

Regards,
Alice Zhang

Highlighted
Frequent Visitor

Re: From multiple Excel sources to a Sharepoint list

Hello,

Do you know if this question has a solution? If so, can you please share?
Highlighted
Advocate I
Advocate I

Re: From multiple Excel sources to a Sharepoint list

I never managed to find a solution that worked

Helpful resources

Announcements
secondImage

August 2020 CYST Winners!

Check out the winners of the recent 'Can You Solve These?' community challenge!

thirdImage

Experience what's new for Power Automate

Join us for an in-depth look at the new Power Automate features and capabilities at the free Microsoft Business Applications Launch Event.

firstImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

thirdimage

Power Automate Community User Group Member Badge

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

Top Solution Authors
Top Kudoed Authors
Users online (3,813)