Hi everyone,
is it possible to add a new worksheet to an excel file which is created in a previous "action" in MS Flow?
I can't acces the new file in the "action" "create new worksheet".
How can I access the folderpath from the created excel file?
Do I have to insert a "action" between these two "actions"
.
.
.
I will get the follwing error:
I hope someone can help me 🙂
Thanks and kind regards
Solved! Go to Solution.
Hi @kbrose
What you can do is, now when you have the updated file in sharepoint (with the new spreadsheet), You can add an action to get the content of this file and then create a new file in the updated (dynamic folder) with a dynamic name with the .xlsx extension.
HI @kbrose
Currently the excel connectors in flow do not support referencing a file dynamically/ through a variable or from dynamic selector etc. which means that you have to select the file by clicking the folder icon and the file should already exist on the library. So in your case, you cannot reference the file like shown in the action in your flow.
Hope this Helps!
If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!
Hi @kbrose
Yes. You can definitely create a worksheet on an already existing excel file in the SP documnet library. You need to point that excel file by clicking the folder icon in the action and point to the excel sheet.
Hope this Helps!
If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!
Hi @kbrose
What you can do is, now when you have the updated file in sharepoint (with the new spreadsheet), You can add an action to get the content of this file and then create a new file in the updated (dynamic folder) with a dynamic name with the .xlsx extension.
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
Learn to digitize and optimize business processes and connect all your applications to share data in real time.
User | Count |
---|---|
29 | |
28 | |
28 | |
20 | |
11 |