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
WarrenBelz
146,731
Most Valuable Professional
#2
RandyHayes
76,287
Super User 2024 Season 1
#3
Pstork1
66,077
Most Valuable Professional
Share
Report
All responses (
Answers (
