How I can create a new spreadsheet to a new excel file

[kbrose]

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: 

The parameter 'file' has an invalid value '/Freigegebene Dokumente/Timesheets/UserXY/UserXY_2019_06.xlsx'."

I hope someone can help me 🙂

Thanks and kind regards

[yashag2255]

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!

[kbrose]

@yashag2255 Hi,

thanks for your answer.
So is it than maybe possible to load Data from a SP List in an existing Excel file and save this file with a new Name (with dynamic variables)?

Kind regards.

[yashag2255]

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!

[kbrose]

Okay thanks, and than I can Copy this file to my dynamic Folder with a dynamic Name in a following action?

Kind regards

[yashag2255 · Accepted 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. 

[kbrose]

okay I will try it. I'll let you know If it's works