web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Automate Power Automate - If It...

Power Automate

Answered

Power Automate - If Item exists, update row, do not create duplicates. If new item then create row.

(0) Share

Report

Report

Posted on by wonka1234

920 Super User 2024 Season 1

Hi,

I am trying to use a power automate to

1) Create NEW items

2) If Item exists - update item and row

3) Do not create duplicates.

step 1 - i am creating items in my sharepoint list via an excel table.

Step 2 - now that these are created, how can I view update values in this row each time the flow is ran and not create duplicates?

condition - length(outputs('Get_items')?['body'])

getting an error on my condition - "Action 'Condition' failed"

any help would be appreciated.

Categories:

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (1)

Sort by

wonka1234 920 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Trying this - cant get this to work - not sure what ID is or if my condition length is accurate - length(body('Filter_array'))

Was this reply helpful? Yes No
Verified answer

v-qiaqi@microsoft.com Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @wonka1234,

Do you want to sync the SharePoint list based on excel?

Actually, I think you should also list the items from the SharePoint list if you want to avoid creating duplicates because you need to compare if there is existing items the same as the new items from Excel file.

Here is a simple demo for your reference:

Write the following expression for the condition:

length(outputs('Get_items')?['body/value'])

Was this reply helpful? Yes No

Join the conversation