You’re offline. This is a read only version of the page.
hi , i am trying to get file contents of desired excel worksheet from excel file and i want to create a new excel file using collected file content in another location ( sharepoint library).
i am able to get the desired excel worksheet id and name. from there i would like to retrieve the file contents but i am not able to find any option to retrieve.
P.S : i cannot use excel get rows function since my data is not in table format and i could not run scrip to make a table since it will destroy design requirements and formulas.
hi @AlexEncodian thanks for the solution but unfortunately i do no think my company would like to spend on subscription for one flow only.
hi @SudeepGhatakNZ thanks for the suggestion and i only need to copy one worksheet of the whole file, is it doable with copy file sorry i am pretty new to power automate.
@thihan27 Can you not use the Copy action in SharePoint to copy the file itself instead of copying the contents?
If you want to copy a subset of the data, convert your excel to a CSV. You can build the formulas in power automate if needed.
#1
Tomac
986
Moderator
#2
stampcoin
699
Super User 2025 Season 2
#3
Riyaz_riz11
577
Super User 2025 Season 2
Share
Report
All responses (
Answers (
