You’re offline. This is a read only version of the page.
55
I need help writing the expressions for the Create Item in SharePoint action. See image for details.
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)
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.
The input of the Apply to each is
Share
Report
All responses (
Answers (
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']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.
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
Attached. Thanks!
Hi there,
Do you have an anonymized version of the JSON output with the [ ?
I can take a look.
#1
WarrenBelz
146,537
Most Valuable Professional
#2
RandyHayes
76,287
Super User 2024 Season 1
#3
Pstork1
65,908
Most Valuable Professional
