I am creating a Flow that uses a condition based on a SharePoint list, if equals 1 send Supervisor Email otherwise Send Employee Email. When I run it using "is equal to" 1, and the value provided is 1, it runs it as false (incorrect). If I run it using "is less than" 2, it creates an "Invalid Template" error. I thought initially it may be due to the data type of the column in my SharePoint list (single line text), but when I create a calculated column to convert to a number, it still behaves the same way.
It doesn't seem to be reading the number, period. Any clue how to fix this?
Hi there - Can we take a look at the condition step? Try putting the number value ("1" or "2") in the expression box vs. just adding it to the field.
Keep us posted,
If this reply has answered your question or resolved your challenge, please consider marking it as a Solution. This helps other users find it more easily via search.
Ok, so ya...try getting rid of the "2" that's loose in the condition and re-adding it through the expression box so it ends up looking like this:
May not fix it, but I've seen that cause issues.
I've done both, re-run a test and triggered with new data. Here is the data feeding the Flow, it's a simple SharePoint list.
Rounded Seniority comes from Excel as a single line of text but Years of Service is a calculated column and is formatted as a number.
Calculated columns are calculated at run time in SharePoint
the value will always return as null in Flow
You will have to add the same calculation logic in Flow to get the Years of Service info and then perform condition on it
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Based on @RezaDorrani reply, I changed the field from Years of Service back to Rounded Seniority which is not a calculated field. I continued using @edgonzales suggestion for writing the number in the expression versus the text field. This is what the output looks like...it's still failing if I use "Less than" 2. It completes with "Equal to" 1 but again, doesn't read the SharePoint field correctly and says the condition is false and processes based on that.
Fill out a quick form to claim your user group badge now!
We've given our badges an overhaul and also added some brand new ones!
Learn how to build the business apps that you need.
Find out where you can attend!
Watch & learn from the Power Automate Community Video Gallery!