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

I have the same question (0)

All responses (5)

Answers (0)

Sundeep_Malik 6,484 on at

Like (1)

Report

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

Was this reply helpful? Yes No
MiguelG_97 5 on at

Like (0)

Report

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?

Was this reply helpful? Yes No
Sundeep_Malik 6,484 on at

Like (0)

Report

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

Was this reply helpful? Yes No
MiguelG_97 5 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Sundeep_Malik 6,484 on at

Like (0)

Report

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

Was this reply helpful? Yes No