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.
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?
Solved! Go to Solution.
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.
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.
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.
No worries i can accept solution from your behalf.
This one is already marked as solution.
Enjoy you automation and have nice weekend.