Unanswered

Fill Excel file with dynamic name

(0) Share

Report

Posted on by Maexchen

I'm trying to dump List data into Excel regularly. I have a template .xlsx file that is preformatted and has an empty table.

what I'm trying to do is to copy that empty file into a new location with a new name and then fill it with the list items. the problem is that the "add row into table" action in flow has a validation at the point of creation but when I create my flow the file I'm trying to create does not exist and the name has a dynamic "month" appended to the name.

I wouldn't mind creating the file with a different (i.e. static) name first but

a) I don't want to work in the template, it needs to stay clean

b) there is no option to rename a file in a Sharepoint folder, so that doesn't work either.

any ideas?

Categories:

Using flows

I have the same question (0)

All responses (3)

Answers (0)

yashag2255 24,769 Super User 2024 Season 1 on at

Like (0)

Report

Hi @Maexchen

There is a known issue with the excel connector that the file value cannot be provided using a variable of dynamically. It needs to be chosen by clicking the folder icon and pointing to the file. (That is particularly why you are facing the error as ou must be pointing the file name to a variable/ dynamic value from the file action/trigger )

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!

Was this reply helpful? Yes No
Maexchen 75 on at

Like (0)

Report

My problem is that the file does not exist when I create the flow, so I can’t select it.
I guess I could get around it by creating a file with a temporary Filene’s men and then rename it at the end. But changing the name of a file on a SharePoint with glow is beyond my capabilities (I found a solution with using the http request but couldn’t get it to work)
But good to know that this is a known issue and not just my stupidity

Was this reply helpful? Yes No
yashag2255 24,769 Super User 2024 Season 1 on at

Like (0)

Report

Hi @Maexchen

What you can do is, have a temporary file on SP and then in this file add the rows and then finally add an action to get file content and map this temp excel file and then add an action to create a file, in this put the desired file name with .xlsx extension and in the file content put the file content option from the dynamic selector.

Lastly, if you want to keep the temporary file you can keep it else delete that.

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!

Was this reply helpful? Yes No