Answered

Check if record exists in Sharepoint and if not - create item

(0) Share

Report

Posted on by shibathedog

Hi all, I am very new to Power Automate so I would ask for some help. I managed to do the following:
I get data from SAP, parse JSON from it, filter the array from parsed json, set variable for every entry and make a new array out of it (append to array variable).
I get data from Sharepoint, compose the column I need, set variable from items in it, and append it to array variable.

In the last step I want to make a condition to check if the elements from SAP new array exist in the Sharepoint array, and if not, I would like to add them to the Sharepoint table (create item).

I tried numerous things but I either end up with 1 new entry, with duplicated entries, with multiplied entries (for array x array items) or with a blank entry. Can somebody please advise? Thank you very much for the help!!

In the screenshoted example I have: 2 entries in the Sharepoint, 7 entries in the SAP array (of which 5 should be written to sharepoint) but I end up with 7 times one of the entries (so the same entry entered 7 times and nothing except it).

Thanks

All responses (5)

Answers (1)

shibathedog 58 on at

Like (0)

Report

Re: Check if record exists in Sharepoint and if not - create item

I think the Apply to each x3 is too much to handle, well depending on the number of items you have. Can you try to do a condition with a create item if it doesn't exist and an update item if it exists?
MashaOvchar 40 on at

Like (0)

Report

Re: Check if record exists in Sharepoint and if not - create item

Hi @shibathedog ,

thanks for the fast reply! But it seems I'm still having trouble.. My initial flow was, when a .JSON is created in a Sharepoint folder, it needs to be parsed, then an item needs to be created in a Sharepoint list.
But at the end I want to check if an item (eg. filtered on OrderNumber) already exist in the list, if so it needs to be updated, otherwise a new item should be created. Have tried a couple of times.. most of the time the flow gets in a loop..

Initial flow:

What do you think? Any ideas?
shibathedog 58 on at

Like (0)

Report

Re: Check if record exists in Sharepoint and if not - create item

Hi @MashaOvchar ,

I hope this will help you:

If not, please share your problem and I might be able to help out!
MashaOvchar 40 on at

Like (0)

Report

Re: Check if record exists in Sharepoint and if not - create item

Hi Shibathedog,

Do you mind sharing your end results? I'm stuck with the same problem, but having no clue what you mean..
Thanks in advance! (:
Verified answer

shibathedog 58 on at

Like (1)

Report

Re: Check if record exists in Sharepoint and if not - create item

Solved it! I should've passed item() to reference items in the list, and not the name of the variable which went into the array. The same for writing to sharepoint.