You’re offline. This is a read only version of the page.
75
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?
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!
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!
#1
WarrenBelz
146,596
Most Valuable Professional
#2
RandyHayes
76,287
Super User 2024 Season 1
#3
Pstork1
65,928
Most Valuable Professional
Share
Report
All responses (
Answers (
