Answered

Sample JSON for Files attached to MS Forms

(0) Share

Report

Posted on by dchow18

Hi All,

Am trying to use Parse JSON control for files attached to MS Form to attach them to an email. Am not able to supply a sample payload to generate the JSON.

My MS Forms will have 3 files attached to the same question and file type could be one of doc, xlsx, ppt, pdf or image.

When I run below sample flow

I get this in run history but no sample load

I did look at this question https://powerusers.microsoft.com/t5/General-Power-Automate/Flow-Parse-JSON-use-a-sample-payload-to-generate-schema/td-p/329266 but couldn't understand what the data attribute should be for my files and if its possible to do this when am not sure what the incoming file type will be for sure. It could be any of 4/5 formats.

If someone can help, would be great.

Thanks,

Categories:

General topics

I have the same question (0)

All responses (8)

Answers (1)

eric-cheng 5,171 on at

Like (0)

Report
Copy link

Link copied!

Hi @dchow18 ,

With MS Forms, the attachments are stored in OneDrive.

Here is a blog to show you how you can email the files.

--------------------------------------------------------------------------
If I have answered your question, please mark my post as a solution
If you have found my response helpful, please give it a thumbs up

Connect on LinkedIn

Was this reply helpful? Yes No
Verified answer

CFernandes 8,482 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

Hey Mate @dchow18,

The blog provided by @eric-cheng is a great starting point.

If you are someone who like to follow video tutorial you can have a look at https://www.youtube.com/watch?v=kNC8q6NzBEc

I myself did a video tutorial on - Convert Microsoft Forms responses with attachments to PDF - https://www.youtube.com/watch?v=YDWpGW1BaBU

Blog post - https://clavinfernandes.wordpress.com/2020/01/01/convertmerge-microsoft-form-attachments-to-pdf/

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
dchow18 10 on at

Like (0)

Report
Copy link

Link copied!

Thanks @eric-cheng , @CFernandes for the solutions, I tried this but am getting below error:

When I run it, I face the below error:

Can you help with this?

Regards,

Was this reply helpful? Yes No
eric-cheng 5,171 on at

Like (1)

Report
Copy link

Link copied!

Hi @dchow18 ,

In the Append to Array action, can you please review the value with the below. It needs to include Name and ContentBytes. You can simply change source_file_name to Name and source_file_content to ContentBytes

--------------------------------------------------------------------------
If I have answered your question, please mark my post as a solution
If you have found my response helpful, please give it a thumbs up

Connect on LinkedIn

Was this reply helpful? Yes No
CFernandes 8,482 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
Hey @dchow18

@eric-cheng has formatted the JSON Correctly -

{ "Name": "<Name>, "ContentBytes": "<File Content>" }

In my blog I use Muhimbi Merge action and that is the reason I am using a different array structure.

If you do not get correct results, I would request you to decorate - the File_Content with base64ToBinary()

base64ToBinary(body('Get_file_content')['$content'])

{

"Name": <Name>,

"ContentBytes": base64ToBinary(body('Get_file_content')['$content'])

}

Keep us posted on how things go!!!

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!

P.S. take a look at my blog here and like & subscribe to my YouTube Channel thanks.

Was this reply helpful? Yes No
dchow18 10 on at

Like (0)

Report
Copy link

Link copied!

Thanks @eric-cheng , @CFernandes . This was helpful and it worked.

Was this reply helpful? Yes No
CFernandes 8,482 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Wohooo... We are glad that we could assist you 😊

Was this reply helpful? Yes No
geddb 109 on at

Like (0)

Report
Copy link

Link copied!

Hi & @CFernandes & @eric-cheng ,

I hope this is the appropriate place for me to post my question. If not, please direct me to the right place.

I am completely new to JSON and I'm trying to convert records stored in a proprietary app and parse them using JSON to a SharePoint List using a Power Automate Flow. The proprietary app has a field that stores multiple attachments (mostly emails).

It's all working fine but when the flow gets to the 'Apply To Each' action which checks for multiple attachments and loops through the attachments, it fails because my Split() function is expecting a string but is getting an array. This is the error I get:

My Split() function looks like this:

Where 'Attachments' is the name of the proprietary application field and varAttachmentCount is a loop counter in Power Automate.

Here is the JSON object relating to attachments:

I have had to create a 'webhook' in the proprietary application which is named 'upload_attachments' and this was the JSON code recommended to me by others.

I've tried changing the property type from 'array' to string in the JSON but that didn't work either.

I'm hoping this provides you with enough information to point me in the right direction. Any assistance you can give me will be appreciated immensely. I have been going around in circles for days.

Sincere thanks in advanced.

Was this reply helpful? Yes No