Trying to copy an excel file and give the copy a different (dynamic) file name - every time a form is submitted. The new file name is a comprised of a combination of fields from the submitted form. That is, for every form submitted an excel file is created with a filename specific to that submission.
A first tried to create the desired file name as a string in flow, but found it easier to instead create a field in the excel table containing the form data (Column=ProposalName; fx=TEXT([@ID],"00000")&"_"&[@[Sales Person]]&"_"&[@[Client''s Name]]&".xlsx")
The flow succeeds, that is it doesn't fail. However, most times it creates a file name missing all the variables. As a result, instead of a file that should be called "00006_John_ABCCo.xlsx" it creates "00000__.xlsx".
If I re-test the flow using a recently used trigger, the flow not only succeeds but it gets the name correct this time. I thought the flow might need a few seconds so I've added delays at different locations with same results. Seems like the flow can't find the right ID record to locate the field. I'm using Forms for Excel so the form data (and calculate name field) is being automatically saved to the excel file when form is submitted.
Any help is appreciated either fixing this issue... or a finding a way to create the filename using flow (e.g. intialize and create a variable?).
