Parse Jason output to check if item already exist in SharePoint before creating or updating item

(0) Share

Report

Posted on by Leu0101

141

I've dug around the internet and I have not found anything clear or working for myself for that matter.

I have a SharePoint list of property names called (Winterization List). I email myself a csv and parse JSON it correctly. However, I have no figured out to check the parse JSON output against the Property Name List. I am trying not to produce duplicates of the record if the record is already in the SharePoint list. I've been stuck on this for days trying different results. Any help would be greatly appreciated! Screenshot 2022-10-13 123951.png

Categories:

General topics

All responses (22)

Answers (2)

Sort by

SudeepGhatakNZ 14,396 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Please elaborate with some examples. I am not sure if I understand your question
Leu0101 141 on at

Like
a
(0)

Report
Copy link

Link copied!

In short I have a csv report that is emailed and picked up by power automate. It is broken down in Parse JSON. And it's information is created into a SharePoint list. The problem is, that every 24 hours, a new report goes out and it create duplicates of the same record as I currently dont understand how to compare the JSON body against the sharepoint list. I want to check by address name and compare the street address in the Json to the street address in the SharePoint list so I either create a new property address or update the existing.
Verified answer

SudeepGhatakNZ 14,396 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Are you able to provide your JSON schema?
Assuming your JSON schema returns the Street Address, you could try
Leu0101 141 on at

Like
a
(0)

Report
Copy link

Link copied!

{
    "type": "array",
    "items": {
        "type": "object",
        "properties": {
            "Street Address 1": {
                "type": "string"
            },
            "Unit": {},
            "Days Vacant": {},
            "Last Move Out": {},
            "Unit Status\r": {}
        },
        "required": [
            "Street Address 1",
            "Unit",
            "Days Vacant",
            "Last Move Out",
            "Unit Status\r"
        ]
    }
}
Leu0101 141 on at

Like
a
(0)

Report
Copy link

Link copied!

What happens to be your expression under the condition for length used to count get items?
SudeepGhatakNZ 14,396 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

length(outputs('Get_items')?['body/value'])
Leu0101 141 on at

Like
a
(0)

Report
Copy link

Link copied!

When I try in the condition "greater than" 0 it doesn't work to create any records in the sharepoint list. When I try "equal to" it just loops the creations of items for infinity and doesnt stop creating the items.
Leu0101 141 on at

Like
a
(0)

Report
Copy link

Link copied!

Here you can see the top end code being ran...
Verified answer

SudeepGhatakNZ 14,396 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

What that means is the filter criteria is not returning any matching results. Check for spaces, upper/lower cases
Leu0101 141 on at

Like
a
(0)

Report
Copy link

Link copied!

Here you can see the property name column as well as how I have it in the filter query and it appears correct.