Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Power Automate - Using Flows
Unanswered

Having trouble getting my condition action to filter results properly

(0) ShareShare
ReportReport
Posted on by 10

I have a flow that sends data into a SP list for the company I work for. The data that is being pushed in would easily be duplicated. So put a condition action in place that basically says if an ID number from the data coming in matches an ID number from the list, to just update that particular item so that I can avoid duplicates. I also set that column to require unique values to safeguard even further against items being duplicated multiple times. The only problem is even when the IDs are of equal values, the condition evaluates to false and attempts to create a new item and fails due to the requirement to have unique values in that particular column. Please see the screen shot and please help. Thank you in advance.

 

byrdman0806_0-1638893039774.png

 

 

byrdman0806_1-1638893090362.png

 

  • jdoss Profile Picture
    458 on at
    Re: Having trouble getting my condition action to filter results properly

    For some troubleshooting, try setting a compose in the false section that captures both the Title and ID and you can compare them to make sure they are the correct values.

    If they are try making sure they are both the same types. In the condition use the expression string(your_dynamic_variable) to make sure they are both set to the same type. Or int(your_dynamic_variable) if the ID is a number, etc.

  • byrdman0806 Profile Picture
    10 on at
    Re: Having trouble getting my condition action to filter results properly

    Edit your flow _ Power Automate — Mozilla Firefox 12_7_2021 12_55_07 PM (2)_LI.jpgEdit your flow _ Power Automate — Mozilla Firefox 12_7_2021 12_55_18 PM (2)_LI.jpg

     

    Thanks for the help.

  • ScottShearer Profile Picture
    25,208 Most Valuable Professional on at
    Re: Having trouble getting my condition action to filter results properly

    @byrdman0806 

    Can you post screen shots of your Flow in design/edit mode.  Please make sure that you show the detail of the update Item action.

     

     

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

🌸 Community Spring Festival 2025 Challenge 🌸

WIN Power Platform Community Conference 2025 tickets!

Markus Franz – Community Spotlight

We are honored to recognize Markus Franz as our April 2025 Community…

Kudos to the March Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 146,524 Most Valuable Professional

#2
RandyHayes Profile Picture

RandyHayes 76,287 Super User 2024 Season 1

#3
Pstork1 Profile Picture

Pstork1 65,906 Most Valuable Professional

Leaderboard

Featured topics

Restore a deleted flow