Unanswered

How to add percentage value in the power automate condition?

(0) Share

Report

Posted on by Priti1

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.

All responses (2)

Answers (0)

Priti1 75 on at

Like (0)

Report

Re: How to add percentage value in the power automate condition?

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.
ScottShearer 25,150 on at

Like (0)

Report

Re: How to add percentage value in the power automate condition?

@Priti1

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.