Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Power Automate - Using Flows
Answered

Condition Statement reading results incorrectly...maybe

(0) ShareShare
ReportReport
Posted on by 40

Hello All,

 

I want to thank you in advance for any help you can provide, so let's jump in.  I have a flow that updates every week with new data and will "Get Items" from a SharePoint List, do a condition if the Store Numbers equal a certain number, then if they do match will send an email.  Below is my flow.

Col5anders_0-1602178903595.png

 

The issue I'm having is it will see "003" and "043" and send out the email, but when it finds "107" it says the condition is false when it clearly shows the input/output to be "107".  I even tried converting the data to a string first but no luck.  Any ideas as to why this is happening?

Col5anders_1-1602179131431.png

 

  • Hardesh15 Profile Picture
    7,087 Super User 2024 Season 1 on at
    Re: Condition Statement reading results incorrectly...maybe

    @Col5anders 

     

    No worries i can accept solution from your behalf. 

    This one is already marked as solution.

    Enjoy you automation and have nice weekend.

     

    Thanks

    Hardesh

  • Col5anders Profile Picture
    40 on at
    Re: Condition Statement reading results incorrectly...maybe

    @Hardesh15 

     

    I thought I did, but the "Accept As Solution" button is now gone from your previous reply.

    Col5anders_0-1602256021142.png

     

  • Hardesh15 Profile Picture
    7,087 Super User 2024 Season 1 on at
    Re: Condition Statement reading results incorrectly...maybe

    @Col5anders 

     

    If your problem resolved please accept post as Accepted Solution. It will help others to see solution.

     

    Thanks

    Hardesh

  • Col5anders Profile Picture
    40 on at
    Re: Condition Statement reading results incorrectly...maybe

    @Hardesh15 

     

    There we go, that did it.  I put the int('107') on the wrong side when testing.  So it looks like anything that doesn't start with a '0' will need this this in its place instead of the SP List column name.  Thanks for the help, I really appreciate it.

     
     

    Screen Shot 2020-10-09 at 9.48.16 AM.pngScreen Shot 2020-10-09 at 9.49.50 AM.png

  • Verified answer
    Hardesh15 Profile Picture
    7,087 Super User 2024 Season 1 on at
    Re: Condition Statement reading results incorrectly...maybe

    @Col5anders 

     

    Try in this way (Which i meant in last post)- i have tested this its running fine.

    Hardesh15_0-1602217959259.png

    Hardesh15_1-1602218037096.png

     

    Thanks

    Hardesh

     

  • Hardesh15 Profile Picture
    7,087 Super User 2024 Season 1 on at
    Re: Condition Statement reading results incorrectly...maybe

    @Col5anders

    I will try it and update you further.

     

    Thanks

    Hardesh

  • Col5anders Profile Picture
    40 on at
    Re: Condition Statement reading results incorrectly...maybe

    @Hardesh15 

     

    Darn, same results.  I was thinking that would work too.

    Col5anders_0-1602185177837.png

     

  • Hardesh15 Profile Picture
    7,087 Super User 2024 Season 1 on at
    Re: Condition Statement reading results incorrectly...maybe

    @Col5anders 

    I faced this issue some time back. Have you tried with converting 107 in integer?. Use only for this number not for others. Use in expression Int('107') instead of 107.

     

    Thanks

    Hardesh

  • Col5anders Profile Picture
    40 on at
    Re: Condition Statement reading results incorrectly...maybe

    @Hardesh15 

     

    It is "Single line of text".  I didn't want it to be a number column type since I need them to be three characters long, like the "003" store.

  • Hardesh15 Profile Picture
    7,087 Super User 2024 Season 1 on at
    Re: Condition Statement reading results incorrectly...maybe

    @Col5anders 

     

    What is column type in SharePoint List?

     

    Thanks

    Hardesh

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,653 Most Valuable Professional

#2
RandyHayes Profile Picture

RandyHayes 76,287 Super User 2024 Season 1

#3
Pstork1 Profile Picture

Pstork1 65,999 Most Valuable Professional

Leaderboard

Featured topics

Restore a deleted flow