cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
New Member

how to handle dynamic filenames in 'update a row'

 

Hello.

 

Another person who is (relatively) new to flows with a need for guidance.

I have a flow that is triggered by a form submission. The flow takes the form responses and adds them to a sharepoint list.  It also creates a new subdirectory in my sharepoint site, and creates a copy of an excel file in that new subdirectory. Both the subdirectory and excel file are named with a field value from the MS Form, so they are dynamic. This all works fine. 

 

What's not working is the "update a row" action that comes next - it doesn't like variable based file names and paths.  I've read some other threads about using SPLIT expression and I've tried it, but I still get save error:

 

Flow save failed with code 'WorkflowOperationParametersExtraParameter' and message 'The API operation does not contain a definition for parameter 'undefined'.'.

 

Any help/guidance would be appreciated. Thanks.

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Community Support
Community Support

Re: how to handle dynamic filenames in 'update a row'

Hi @mgermony,

 

What are you input in the split() function?

If you not similar with split function, you could refer to this doc, it will help you something:

https://docs.microsoft.com/en-us/azure/logic-apps/workflow-definition-language-functions-reference#s...

If you could share some screenshots of your Flow, it will help us to assist you better, thanks.

 

Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

2 REPLIES 2
Highlighted
Community Support
Community Support

Re: how to handle dynamic filenames in 'update a row'

Hi @mgermony,

 

What are you input in the split() function?

If you not similar with split function, you could refer to this doc, it will help you something:

https://docs.microsoft.com/en-us/azure/logic-apps/workflow-definition-language-functions-reference#s...

If you could share some screenshots of your Flow, it will help us to assist you better, thanks.

 

Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Highlighted
Dual Super User III
Dual Super User III

Re: how to handle dynamic filenames in 'update a row'

Hi @mgermony 

 

The excel connector for actions like Create a New Row, Update a Row does not support dynamic file names and table names. This can be done using the Graph API though. https://docs.microsoft.com/en-us/graph/api/table-post-rows?view=graph-rest-1.0&tabs=http 

 

You can either create a custom connector or use the HTTP action for this one. 

 

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!

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Power Platform ISV Studio

Power Platform ISV Studio

ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.

Tech Marathon

Maratón de Soluciones de Negocio Microsoft

Una semana de contenido con +100 sesiones educativas, consultorios, +10 workshops Premium, Hackaton, EXPO, Networking Hall y mucho más!

Top Solution Authors
Top Kudoed Authors
Users online (5,983)