Unanswered

Trying to take attachment from Forms and inserting into Approvals

(0) Share

Report

Posted on by Community Power Pla...

I have a form that takes an attachment as one of the questions. It is always just 1 excel file (xlsx). Then I need to take the attachment and insert it into an Approval. No changes need to be made to the file in the process. I've tried several things, but I always end up with a message from Excel saying that the file is corrupted. If I specify the MimeType (which I've verified several times is the correct MimeType), then the Approval message doesn't include the attachment.

All responses (10)

Answers (0)

Community Power Pla... on at

Like (0)

Report

Re: Trying to take attachment from Forms and inserting into Approvals

ouput from previous steps:
json(outputs('Get_response_details')?['body/r5e6b44f5381945f8b67044280e9ef4a4'])

Get file metadata:
items('Apply_to_each')?['id']
Ellis Karim 10,912 Super User 2025 Season 1 on at

Like (0)

Report

Re: Trying to take attachment from Forms and inserting into Approvals

Hi @Anonymous ,

Please show your Apply to Each 7 action and please show the expressions in used (1) and (2) below:

Ellis
____________________________________
If I have answered your question, please mark the post as ☑️ Solved.
If you like my response, please give it a Thumbs Up.
My Blog Site
Community Power Pla... on at

Like (0)

Report

Re: Trying to take attachment from Forms and inserting into Approvals

That's what I have. As previously stated, this error occurs
Ellis Karim 10,912 Super User 2025 Season 1 on at

Like (0)

Report

Re: Trying to take attachment from Forms and inserting into Approvals

Hi @Anonymous ,

Your flow should be similar to the following:

Note the expression in the Apply to each loop. Please try this in place of the values from Parse JSON:

See: How to send Microsoft Forms file uploads to an Approval workflow using Power Automate

Ellis
Community Power Pla... on at

Like (0)

Report

Re: Trying to take attachment from Forms and inserting into Approvals

The rest is as seen in prior replies
Ellis Karim 10,912 Super User 2025 Season 1 on at

Like (0)

Report

Re: Trying to take attachment from Forms and inserting into Approvals

Please share the entire flow, starting from the When a new response is submitted trigger.

Ellis
Community Power Pla... on at

Like (0)

Report

Re: Trying to take attachment from Forms and inserting into Approvals

I've used both the above and the JSON block as seen in my screenshots. Both options lead to the same error.
Ellis Karim 10,912 Super User 2025 Season 1 on at

Like (0)

Report

Re: Trying to take attachment from Forms and inserting into Approvals

Hi @Anonymous,

In the Apply to each 7 loop, make sure that the you have used the json function. The expression “wraps” the dynamic content for the Upload your file question inside a json function as shown in the tutorial:

And the Get fie metadata should use the following expression (we aren't using the Parse JSON action so we can select the properties we need):

items('Apply_to_each_7')?['id']

Ellis
____________________________________
If I have answered your question, please mark the post as Solved.
If you like my response, please give it a Thumbs Up.
Community Power Pla... on at

Like (0)

Report

Re: Trying to take attachment from Forms and inserting into Approvals

When trying that solution, I receive an error stating that the file cannot be found.
Ellis Karim 10,912 Super User 2025 Season 1 on at

Like (0)

Report

Re: Trying to take attachment from Forms and inserting into Approvals

Please see the following:

How to send Microsoft Forms file uploads to an Approval workflow using Power Automate

Ellis
____________________________________
If I have answered your question, please mark the post as Solved.
If you like my response, please give it a Thumbs Up.