web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Power Automate Workflow
Power Apps
Answered

Power Automate Workflow

(0) ShareShare
ReportReport
Posted on by 194

Hello together

I am working on a workflow that should have the following function. My workflow should check if an ID already exists as a sharepoint entry. If it exists, then it should overwrite it please. If not it should create a new one.

However, I have the problem that it checks every entry and then simply creates all entries twice. Attached are the images (with german headline)

 

mer_0-1660553723438.png

In my test I wanted to check if the ID 15.11.2030 already exists and if so overwrite it but it created a new entry and duplicated the other entries too

 

For my power app, here's how I thought about it:

 

mer_1-1660553819973.png

I wanted to address the ID field directly. Then I wanted to create a variable with the value of the ID field

 

mer_2-1660554009641.png

Then I call my elements off I would not know now what I could write here still purely.

 

There is also the selection retrieve element but here I would need an ID and this I would have to write with a f(x) there I would not know what must purely there, therefore I have not used it.

 

mer_3-1660554146838.png

 

After the Get Items command I check if my PowerApp ID is the same as an ID in my sharepoint if so it should take the left path and update it. If no create a new entry.

But it only creates new items and I would need help here very urgently.

 

mer_4-1660554279380.png

 

 

Categories:
  • Verified answer
    BCBuizer Profile Picture
    22,854 Super User 2026 Season 2 on at

    Hi @Ömer,

     

    In the "Get Items" action, add a filter:

     

     

    Title eq '@{triggerBody()['ID-Field']}'

     

     

    This will retrieve the item with the matching ID-Field value if it exists.

     

    The condition after this will have to be changed to:

     

    length(outputs('Get_items')?['body/value']) is equal to 0

     

    In the Yes field, add the "Create item" action and in the No field, add the "Update Item" action.

     

    You may have to make some changes to the above to adjust for German language/locale.

     

    Edit: The "Update Item" action will be wrapped in an "Apply to each" loop automatically when selecting the value for Id from the Dynamic content. You can either ignore that or instead of selecting the Dynamic content, use the below:

     

     @{First(outputs('Get_items')?['body/value']?['ID'])}
  • Ömer Profile Picture
    194 on at

    Worked Thank you 

     

    i have tested it with two other sharepoint elements no duplicates it changes the right one 

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
11manish Profile Picture

11manish 393 Super User 2026 Season 2

#2
Mohsin Ali Profile Picture

Mohsin Ali 328

#3
WarrenBelz Profile Picture

WarrenBelz 278 Most Valuable Professional

Last 30 days Overall leaderboard