Help with Create Item in Sharepoint Action - Issue Writing Expressions

(0) Share

Report

Posted on by stov1a

I need help writing the expressions for the Create Item in SharePoint action. See image for details.

Screenshot 2024-03-14 121019.jpg

Categories:

Using flows

I have the same question (0)

All responses (10)

Answers (3)

Rhiassuring 8,690 Moderator on at

Like (0)

Report

Hi there,

Do you have an anonymized version of the JSON output with the [ ?

I can take a look.

Was this reply helpful? Yes No
stov1a 55 on at

Like (0)

Report

Attached. Thanks!

Raw Outputs JSON....

Was this reply helpful? Yes No
Rhiassuring 8,690 Moderator on at

Like (0)

Report

Thank you!

I ran the JSON through the JSON validator and it is very upset with the P3P line.

I've tried a couple things, but I'm not sure the best way to do this. I think maybe someone who knows xpath will be able to get a clean solution for you, perhaps. @Chriddle

Was this reply helpful? Yes No
Verified answer

Chriddle 8,434 Super User 2025 Season 2 on at

Like (0)

Report

The JSON provided looks good.
Although there is no “Description Vendor” property.

The character mentioned (“[”) means that “formDataList” is an array.

Therefore, you need to add an "Apply_to_each" to loop through this formDataList and create an SP list item for each of these array elements.

Was this reply helpful? Yes No
stov1a 55 on at

Like (0)

Report

Thanks so much for identifying the the “[“ character is.

Do you mind helping me identifying how to configure the “apply to each” action?

Was this reply helpful? Yes No
Verified answer

Chriddle 8,434 Super User 2025 Season 2 on at

Like (2)

Report
The input of the Apply to each is

outputs('Get_form_field_dataof_agreement_in_JSON_format')['body/formDataList']

In the Create item (within the Apply to teach) you address the items's properies like this:

items('Apply_to_each')['Vendor Email']

Was this reply helpful? Yes No
stov1a 55 on at

Like (0)

Report

Thanks so much. I’ll give it a try!

Was this reply helpful? Yes No
stov1a 55 on at

Like (0)

Report

The 'Apply to Each' action worked perfect. My only issue now is that it is adding an additional item to the list for the Approver's inputs, which are not needed. How do I mark the end of where i want the outputs form the form data to be included in the create list item?

See image below.

Was this reply helpful? Yes No
Verified answer

Chriddle 8,434 Super User 2025 Season 2 on at

Like (1)

Report
Use this as Apply to each's input:

take( outputs('Get_form_field_dataof_agreement_in_JSON_format')['body/formDataList'], 1 )

Was this reply helpful? Yes No
stov1a 55 on at

Like (2)

Report

You are the best! Thanks so much. I tweaked the action name to add an underscore between "data" and "of" and it worked!

Edited Expression: take(outputs('Get_form_field_data_of_agreement_in_JSON_format')['body/formDataList'],1)

Was this reply helpful? Yes No