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 Automate / Condition Statement re...
Power Automate
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

 

Categories:
I have the same question (0)
  • Hardesh15 Profile Picture
    7,087 Super User 2024 Season 1 on at

    @Col5anders 

     

    What is column type in SharePoint List?

     

    Thanks

    Hardesh

  • Col5anders Profile Picture
    40 on at

    @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

    @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

    @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

    @Col5anders

    I will try it and update you further.

     

    Thanks

    Hardesh

  • Verified answer
    Hardesh15 Profile Picture
    7,087 Super User 2024 Season 1 on at

    @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

     

  • Col5anders Profile Picture
    40 on at

    @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

  • Hardesh15 Profile Picture
    7,087 Super User 2024 Season 1 on at

    @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

    @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

    @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

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Automate

#1
David_MA Profile Picture

David_MA 86 Super User 2026 Season 1

#2
Haque Profile Picture

Haque 55

#3
Ellis Karim Profile Picture

Ellis Karim 53 Super User 2026 Season 1

Last 30 days Overall leaderboard