You’re offline. This is a read only version of the page.
Hello,
I am a newbie to power automation and trying to connect to the SharePoint list data but the condition is not running the "YES" part it only runs the "NO" part.
I have created a SharePoint list called "Financial" and that has the "3PP Prod" column and I used that same column in the other SharePoint list called "Request form" as a lookup field.
Then I created a flow on the "Request Form" as below.
Step -1: when "An item is created or modified"
Step -2: Condition
Work unit = HR
If yes -> There is another condition -->This condition is currently not working. Not sure what am I doing wrong here.
if the "work unit:3PP Prod" is greater than or equal to 102% --> I used String(102) function here (Is this correct function for percentage value?)
AND if Reason = Replacement
Then send an email
IF No --> Send an email --> It only runs this condition
Any help would greatly be appreciated. Thank you for your time in advance.
Hi @ScottShearer ,
Thank you for your quick reply. A work unit is the "Single line of text" and 3PP Prod is the "Number" type in the SharePoint "Financial list".
And a "work unit" and "Work unit:3PP Prod" is the "Lookup" type in the "Request Form" list in SP. So when I select the "Work unit" value from the dropdown it fills out the appropriate 3PP Prod value in the "Work unit:3PP Prod" field.
I have selected Work unit:3PP Prod value from dynamic it is still running the 'NO' part only and skipping "YES" part of the condition. I have added the screenshot below.
Please see the below screenshot of the "Request Form" list.
Work Unit:3PP Prod is the lookup value coming from the "Financials" list but I have not added that on the form just showing it on the "All Items" default view.
So based on the value selected from the "Work Unit" lookup dropdown on the form it will add the appropriate value to the "Work Unit:3PP Prod" lookup column on the "Request Form" list which is coming from "Financials" list.
What type of column is Work unit? If it is a choice column, you need to select "Work unit Value" from Dynamic properties in your condition.
#1
Michael E. Gernaey
497
Super User 2025 Season 2
#2
David_MA
436
Super User 2025 Season 2
#3
Riyaz_riz11
244
Super User 2025 Season 2
Share
Report
All responses (
Answers (
