ms forms - How do I account for multiple file upload questions in Power Automate? - Stack Overflow

admin管理员组

文章数量:1395238

Hello and thank you for checking out my issue. I created a Microsoft form to handle file review and approvals. In the form, I have 3 questions that allow file uploads. If the user selects "Individual" site in one of the other questions on the form, they will be presented with a question that will allow up to 2 files be uploaded for that question. If the user selects "bulk" from the previous question, the user will be presented with 2 questions that will allow uploads. The first question will allow 10 files to be uploaded, and the second is for overflow if there are more than 10 sites to approve in the request.

In my Power Automate flow, I have it set up as follows: Action - When a new response is submitted - Form ID for form is selected Action - Get response details - Response ID for selected form Condition 1 - If question is equal to "individual" If True Action - Parse JSON for Individual upload question. If False Action - Parse JSON 1 for first bulk upload question Condition 2 - If Form question "How many Sites?" is equal to greaterOrEquals( int(coalesce( outputs('Get_response_details')?['body/rb831dd7ae5414e028d092e4890fb783a'], '0' )), 10 )

If True - Parse JSON 2 for overflow bulk upload question.

Exit Condition 1

Action - Post a message to Teams chat or channel

My current flow setup seems to work up to this point

I added another action called "Start and wait for an approval" Approval Type - Approve/Reject - First to respond

In details, I have the dynamic content for the body link for each of the parsed jsons. 1 per line. This created For Each 1-3 with my Start and Wait for Approval action inside. Here is where my flow breaks, and I'm assuming it's because it doesn't know how to handle the multiple parsed json files.

Here is the error I'm getting:

Action 'For_each_1' failed: Unable to process template language expressions for action 'For_each_1' at line '0' and column '0': 'The template language expression 'outputs('Parse_JSON')['body']' cannot be evaluated because property 'body' cannot be selected. Please see aka.ms/logicexpressions for usage details.'

I have been working on this for several hours now and feel like I have taken steps back instead of forward. Any help would be greatly appreciated.

The Parse JSONs are to parse the upload link from the 3 questions in the form. The For Each loops were created automatically when I added the parsed link from the parsed jsons in the details section of the action. I'm not clear on how I should handle the 3 different upload buckets.

本文标签： ms formsHow do I account for multiple file upload questions in Power AutomateStack Overflow