how to handle dynamic filenames in 'update a row'

(0) Share

Report

Posted on by mgermony

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.

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Verified answer

v-litu-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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#split

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.

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

Like (0)

Report
Copy link

Link copied!

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!

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

This is an old post but I will leave this here anyway incase someone else runs into a similar issue. If you add your column names and cell values in JSON object format it works. So it would be entered in like this { "Column1": "Value1", "Column2": "Value2" } and so on. Replace the "Column1" and "Value1" with the name of your column name and cell value. This worked for me, hopefully it works for you. I'll include a screenshot as well for reference.

Was this reply helpful? Yes No