Answered

Unable to complete Parse JSON form without attachment

(0) Share

Report

Posted on by AdamMullins

Hi. I have successfully created a form that now sends to an email address (other than my own) and includes attachments using the Parse JSON tool. When an attachment is uploaded in the form, the flow is successful - however the upload attachments is optional. When users do not add an attachment the flow fails, with the following error:

Unable to process template language expressions in action 'Parse_JSON' inputs at line '0' and column '0': 'Required property 'content' expects a value but got null. Path ''.'.

I have spent the last 3 hours Googling how to overcome this - with the only solution being to 'include a condition before the Parse Json'. This is probably correct, however I have zero knowledge how Power Automate really works and everything I have done so far has been copying Youtube content!!

Failed Flow below:

Successful flow below (when attachment is added)

Can any one help me, with a step by step guide assist me how to get this form to send with or without an attachment! If you can, please treat me like I've never seen a computer before! LOL

Really appreciate this community and your support.

Cheers

Categories:

Building flows

I have the same question (1)

All responses (8)

Answers (1)

Verified answer

Expiscornovus 33,195 Most Valuable Professional on at

Like (0)

Report
Hi @AdamMullins,

I would use a condition action to check that the answer to the Upload Please question is not empty. You can do that by using an expression with the length function. When the length is not equal to 0 it will mean you have some attachment data.

Below is an example of that approach.

1. Add a Condition directly after the Get response details action. Use the following expression:

length(outputs('Get_response_details')?['body/rcef90edcfcdb49b7b8db8ca7580a964c'])

Make sure you add the expression via the expression tab and also change the question id by your Upload Please question id. That will be different in your form.

2. Place all the other actions (related to the send with attachment scenario) in the If Yes section.

3. Add whatever you want to do in the no attachment scenario in the If No section.

Was this reply helpful? Yes No
AdamMullins 12 on at

Like (0)

Report

Thank you for getting back to me so quickly! I now seeing a new error:
Below is the config you have suggested:

I dont suppose you would be free for a Teams call?

Was this reply helpful? Yes No
Expiscornovus 33,195 Most Valuable Professional on at

Like (0)

Report

Hi @AdamMullins,

Did you update my question id rcef90edcfcdb49b7b8db8ca7580a964c (of the Upload Please question) to your specific question id?

This id will be different in your Microsoft Form.

Was this reply helpful? Yes No
AdamMullins 12 on at

Like (0)

Report

This is where my complete lack of knowledge comes in.... could you show me how to obtain the question ID that I need to insert?

Thank you for your patients!!!

Was this reply helpful? Yes No
Expiscornovus 33,195 Most Valuable Professional on at

Like (0)

Report

Hi @AdamMullins,

You can hover over the field in the interface or even easier, use the peek code feature. With the peek code you can also copy the id value. So, I would use that one.

Below is an animation how you can find it in the Parse Json action.

Was this reply helpful? Yes No
AdamMullins 12 on at

Like (0)

Report

Awesome! I have it working. Thank you! The only issue I have now, is this new error - although the email was received as expected both with and without the attachment.

I'm assuming I can ignore this error.....

Was this reply helpful? Yes No
Expiscornovus 33,195 Most Valuable Professional on at

Like (0)

Report

Hi @AdamMullins,

If you want to avoid that error I would add the Initialize variable action (varFiles of type Array). It looks like that action is missing in your flow setup (while it was there before in your opening post of this thread).

Place it above the Condition action.

Was this reply helpful? Yes No
AdamMullins 12 on at

Like (1)

Report

Thank you so much for your help with this. I now have a working flow and my users are using the form with great success! Cheers.

Was this reply helpful? Yes No