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

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Check if item exists i...
Power Automate
Unanswered

Check if item exists in one list, if no, create new item in list

(0) ShareShare
ReportReport
Posted on by 74

HI Everyone, 

 

After reviewing numerous threads with similar issues, I still cannot figure out my flow.

 

Essentially, this is what I am trying to create: 

    Trigger: When a new item is created in Request for Assistance (RFA)

    Check to see if the case number of the new item exists in Case Management List (CML)

     If it does, do nothing. If it doesn't, create new item in CML

 

Sounds simple, right? Well it's not working for me for some reason. Here is my current flow set up:

RFA Step 1.jpg

 

Where numRFA = length(outputs('Get_items_from_RFA')?['body/value'])

 

RFA Step 2.jpg

 

RFA Step 3.jpg

 

 

The flow says it succeeded but then doesn't create any items in the CML. Any help would be greatly appreciated!

 

Thank you!

Categories:
I have the same question (0)
  • abm abm Profile Picture
    32,865 Most Valuable Professional on at

    Hi @Masonf2265 

     

    You are nearly there. So here in that compose you are checking the total number of records which is great. Ideally in your if condition check 0 (zero) instead of 1. One means record exists. So check zero and under the Yes condition add the Create Item action step and map the values from the trigger() step (Request for assistance). Also delete all the current actions steps from the NO branch.

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

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 538 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 405 Moderator

#3
abm abm Profile Picture

abm abm 252 Most Valuable Professional

Last 30 days Overall leaderboard