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.....
Thanks in advance for your help!
Jellinad
Hey @Jellinad ,
Add the “Get file content” action to the Flow canvas and add the item “id” output of the ‘Parse JSON’ action.
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!
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)
Thanks Paul,
I followed the steps in your blog but unfortunately get an error on the "Get file content" step,
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.
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.
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:
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
So the form seems to work fine to me, but don't know what causes the error
Rgds
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.
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
Here it goes wrong at the 'attachments'. It recognizes there were 2 attachments but apparently can't find them?
If i remove the Arrau from the attachment field the flow work fine.
So looks like something in the Array is not correct
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!
@Pstork1 You've made my day with your tutorial!
This was the simplest, most straight forward and informative tutorial I've found for this function, and you've really helped out this newcomer. Thanks so much!