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
FirstImage

Microsoft Ignite 2020

Check out the announcement of Power Platform content at Microsoft Ignite!

thirdImage

Experience what's new for Power Automate

Join us for an in-depth look at the new Power Automate features and capabilities at the free Microsoft Business Applications Launch Event.

firstImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors
Users online (3,343)