If record already exist into SharePoint than need to update it else create new record

(0) Share

Report

Posted on by Viral21

194

Hello All

I have one Power app that submitted data into the Shrepoint List.

I am using Flow for that because it also creates documents in Sharepoint.

My Query:

If the recored already exists in Sharepoint List (we need to check based on "Document Type" and "EntityID"), then we need to update that record with new values, otherwise create a new entry.

So can anyone guide me through what I need to do?

My Flow:

My Power apps button code:

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Sort by

Verified answer

EddieE 4,650 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

@Viral21

You can use the 'Get items' action with the Filter Query to check for "DocumentType" &"EntityID". Then, use the length() function inside a Condition to check if a record exists. If length = 0, then it doesn't exists.

So, you'd use the 'Yes' side of the condition to create an item, and the 'No' side to Update an existing item.

This blog post runs you through what you need

https://tomriha.com/how-to-check-if-sharepoint-item-already-exists-in-power-automate/

Was this reply helpful? Yes No
Viral21 194 on at

Like
a
(0)

Report
Copy link

Link copied!

Hello @EddieE
I have updated flow as per your suggestion, but I get below error.
Can you please help me how I need to write filter query code?
My SharePoint List Columns Name: "Entity ID" & "Document Type"
Note: I pass value for that from power app

Was this reply helpful? Yes No
EddieE 4,650 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

@Viral21

Spaces in column names need to be written differently in the Filter, ie

'Entity ID' should be

Entity_x0020_ID

... and so on

Was this reply helpful? Yes No
Viral21 194 on at

Like
a
(1)

Report
Copy link

Link copied!

@EddieE I wrote without space like "EntityID" and it's working fine.
Thanks for your support

Was this reply helpful? Yes No