Add form details in an array

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hello everyone,

I want to put some form details in a array. When i make a variable array with the details, it works fine:

Before run:

First variable.jpg

After run:

First variable (executed).jpg

However, when i add an "Parse JSON", I get the following error:

JSON error.png

What am i doing wrong?

I also want to enter an action that comes from the form that contains text. How to do that?

Thanks in advance

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (2)

Sort by

Verified answer

Jcook 7,783 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hello @Anonymous

Could you share a screenshot of your Flow in Edit mode, and show how your Parse JSON action looks.

For grabbing a text field from your form, use a Compose action

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hey @Jcook, thank you for helping me.
The code in the action "variable initialiseen" is seen below this line. The flow after is the flow in edit mode.
formatDateTime(body('Reactiedetails_ophalen')?['ra8ff95dfd58b4c528b48fe28555381f9'],'dd-MM-yy')

The next image is the code from the JSON

I tried to use a compose action. It work in the variable, but I it won't work in JSON:
"Opmerking":@{outputs('Opstellen')}

Was this reply helpful? Yes No
Verified answer

Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hey @Jcook,
I solved the problem on my own, but thanks for your tip to use a compose action.
Every time I was use the 'Parse JSON' action, i cliked on the 'Use sample payload to generate schema' and copy the schema of the variable. That didn't go well in the JSON.

Later on I manually typed in the values between the "" and the action worked.
Thanks to you, i added the text variable into the JSON with success.

For everyone else that wants to use a variable from something else (like MS Forms):
Load the (Form) details in a variable first before use the Parse JSON action.

Use the example of the details below in the Parse JSON action:

{ "type": "array", "items": { "type": "object", "properties": { "Number": { "type": "string" }, "Date": { "type": "string" }, "Note": { "type": "string" } }, "required": [ "Number", "Date", "Note" ] } }

Good luck everyone!

Was this reply helpful? Yes No