cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Jellinad
Frequent Visitor

Form attachment uploaded in approval flow gets corrupted

Hi,

I'm quite new to Power Automate, generating flows etc. so maybe the solution i search for isn't as difficult as it looks

I generated a form, which enables the user to upload a file.

The forms starts a flow in which i need to send this uploaded file as an attachment with the 'start and wait for an approval'

Everything works fine except from the fact that the attachment is corrupted/unreadable.

I've searched for alternatives/solutions but can't find one that solves my problem, so i hope some of you can help me.

Below is the flow i created.....

Jellinad_1-1622545163029.png

 

Jellinad_2-1622545204733.png

Thanks in advance for your help!

Jellinad

9 REPLIES 9
CFernandes
Super User III
Super User III

Hey @Jellinad ,

 

Add the “Get file content” action to the Flow canvas and add the item “id” output of the ‘Parse JSON’ action.

 

CFernandes_0-1622549857366.png

 

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!

 

Jellinad
Frequent Visitor

Thanks for your answer but where should i add this? And does this come in place for 'Get file content using path'?

Does this pevent getting the attachement corrupted?
Thanks 
Pstork1
Dual Super User III
Dual Super User III

I've got a full walkthrough of just that scenario on my blog.  You can find it here:

Emailing File Attachments from Forms with Power Automate – What Me Pa..Panic? (dontpapanic.com)

 



-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.
Jellinad
Frequent Visitor

Thanks Paul,

I followed the steps in your blog but unfortunately get an error on the "Get file content" step,

{
  "status"404,
  "message""The resource could not be found.",
  "source""api.connectorp.svc.ms"
}
Any idea what causes this?
Thanks again!
Pstork1
Dual Super User III
Dual Super User III

Are you sure there was an attachment uploaded to the MS Form?  And are you the one who made the form?  The upload goes into the OneDrive or OneDrive for Business account of the person who made the form.



-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.
Jellinad
Frequent Visitor

Hi

Thanks again for your reply. The form was created by me.

When i fill in the form the files are being uploaded to my Onedrive location

When another user fills in the form, is see the files running into my onedrive location too.

Jellinad_1-1622627281317.png

 

So that part seems to work fine.

The flow is shared by 3 people. Me, the account that filled in the form for the second time and someone else (not working on it).

Looking at the flow:

Both users get the same error message: 

{
  "status"404,
  "message""The resource could not be found.",
  "source""api.connectorp.svc.ms"
}

Also had a look at the form-responses. See list below

Last 2 ID's are the ones i mentioned in my previous reply.

These files can be opened and are not corrupt

Jellinad_2-1622628169667.png

 

So the form seems to work fine to me, but don't know what causes the error

Rgds

 

Pstork1
Dual Super User III
Dual Super User III

Is this an automated cloud flow or an instant trigger?  If its an instant trigger then the other users need access to your OneDrive location where the files are being uploaded. 



-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.
Jellinad
Frequent Visitor

Paul

Looks like i'm getting closer...

I re-created he form with the EN-AUTO account. This is one of the accounts that can edit the flow.

The flow runs fine until the approval flow starts.

based on a location a certain route is followed.

When the condition is "true" the "start and wait for an approval" is starting

Jellinad_0-1622728273220.png

 

Here it goes wrong at the 'attachments'. It recognizes there were 2 attachments but apparently can't find them?

Jellinad_2-1622728684076.png

Jellinad_3-1622728704459.png

If i remove the Arrau from the attachment field the flow work fine.

So looks like something in the Array is not correct

Jellinad_1-1622802203867.png

 

I filled the form with the account that created the form. Files were uploaded to his one-drive.

When using another account, files were uploaded too but flow got stuck at same point

 

I truly hope you can help, as the Business starts pushing for the flow :-).

Thanks again!

 

 

 

 

 

Helpful resources

Announcements
MPA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

V3_PVA CAmpaign Carousel.png

Community Challenge - Giveaways!

Participate in the Power Virtual Agents Community Challenge

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

PowerPlatform 768x460.png

Microsoft Learn

Check out our new Discover Your Career Path blog post series and get all the details.

Top Solution Authors
Users online (2,126)