Read data from excel online and place them into another excel online

(0) Share

Report

Posted on by MiguelG_97

Hi Folks, I hope this topic finds you all well

1). I'm looking to read data from this excel file contained in this sharepoint folder:

how can I set the sharepoint location to the list rows present in a table action?

It only allows me to set the location for OneDrive cloud

Do you guys have any workaround for this matter or any other action I can use to read excel data?

2). Afterwards, I want to write the data on excel onlines which are contained within this nested folder:

How can I get inside a sharepoint folder till I find my excels files? My knowledge regarding power automate is really shallow, pardon me. This is what I was trying out but I'm not sure how to get inside next folder and also the ODATA filter for folder name is not working at all. Is there any documentation you can direct me on how can I get the properly ODATA syntax for sharepoint items?

All the best,

Miguel G.

Categories:

General topics

All responses (5)

Answers (0)

Sort by

Sundeep_Malik 6,501 on at

Like
a
(1)

Report
Copy link

Link copied!

Hey @MiguelG_97

Sometimes you will need to refresh or make a new connection to SharePoint.

Or copy the SharePoint site address and copy it in the custom value of Excel online.

Heres a link of your problem, from a previous post:
https://powerusers.microsoft.com/t5/General-Power-Automate/Have-sharepoint-sites-that-do-not-show-up-in-power-automate/td-p/601305
MiguelG_97 5 on at

Like
a
(0)

Report
Copy link

Link copied!

thank you @Sundeep_Malik for replying me! Somehow, today all the sites appeared in the Location field
, but thank you for the insights. Next time, I will set the site name straightforward

Regarding task #2, any ideas on how to access folder contents till find the excel file to place my data from previous excel?
Sundeep_Malik 6,501 on at

Like
a
(0)

Report
Copy link

Link copied!

@MiguelG_97
Didn't get your second part. Can you elaborate it more??
MiguelG_97 5 on at

Like
a
(0)

Report
Copy link

Link copied!

Basically, I wish to read data from excel and place it into another excel online. The problem I'm facing is this:
i). in order to use the "Update row" action, I need to do insert tables. However, I cant do it in excel files with xlsm extension

neither it appears as a file, I had to type manually the name

I've post the same similar topic in another forum: https://forums.autodesk.com/t5/revit-api-forum/read-data-from-excel-online-sharepoint-and-place-it-to-another/td-p/11473353
Sundeep_Malik 6,501 on at

Like
a
(0)

Report
Copy link

Link copied!

@MiguelG_97
No idea about the 2nd one....