After parsing .JSON, create or update items in Sharepoint

(0) Share

Report

Posted on by MashaOvchar

Hi community,

I am attempting to build a flow where I need to parse a .JSON and create or update those items in SP list.

I have the flow working, expect for the final step I get lost.. I need to add a control where it checks if those items already exist (WorkInstructionNumber) in Sharepoint, if yes, they need to be updated. I either end up in a loop or ALL my items in my SP list get updated..

Any ideas someone?

.JSON:

[{"WorkInstructionNumber":"1620348",
"WorkInstructionSubfileNumber":1,
"ETA":"2022-03-30T00:00:00",
"Description":"XXX",
"LocationDescription":"YYY",
"RegioCode":"ZZZ",

"Customers":
[{"CustomerName":"Client A",
"CustomerReference":"123456789",
"Required":"Y",
"UpdatesTo":"XXX",
"CustomerLetter":"A"},

{"CustomerName":"Client B",
"CustomerReference":"987654321",
"Required":"N",
"UpdatesTo":"",
"CustomerLetter":"B"}]}]

Visual

My current flow:

Categories:

Building flows

I have the same question (0)

All responses (7)

Answers (0)

v-jefferni on at

Like (0)

Report

Hi @MashaOvchar ,

Technically, you need a Condition control after a List items of the list as well as the Filter array operator, you also need an Integer variable to countrows outputs of Filter array, in the Condition control, if the variable equals to 0, create item, else update item (item ID could be found in the Filter array outputs).

Best regards,

Was this reply helpful? Yes No
MashaOvchar 40 on at

Like (0)

Report

Hi @v-jefferni ,

Thanks for the quick reply, but you lost me at the first sentence. 😅

Was this reply helpful? Yes No
MashaOvchar 40 on at

Like (0)

Report

Hi @v-jefferni ,

Almost there, but not quite yet.. It seems when the item gets updated, each ID gets updated with details from each costumers.. So I end up for each ID with same customer details of the last customer in the .JSON..

Any ideas how to work around this? Much appreciated.

Was this reply helpful? Yes No
CRod 62 on at

Like (0)

Report

Did you figure this out? Im having the same issue.

Was this reply helpful? Yes No
MashaOvchar 40 on at

Like (0)

Report

Unfortunately no...

Was this reply helpful? Yes No
CRod 62 on at

Like (1)

Report

I was able to figure out the issue. If you see in your "if no" statement you have two "apply to each" blocks. You have two items in 'apply to each 3' and two in 'apply to each 4'.

I'm new to flows too, hope this makes sense.
When you run the 'if no' statement. It takes the first item in 'apply to each 3' then runs 'apply to each 4' twice since it has two items. Then it goes to your second item in 'apply to each 3' and runs again 'apply to each 4' again twice because there are two items.

You need to arrange your statements so you dont create a new "apply to each" .

Was this reply helpful? Yes No
DynamicDerek 3 on at

Like (0)

Report

I had the same issue as the OP, @MashaOvchar.
Thank you for the solution, @CRod!

Was this reply helpful? Yes No