Multi Criterial to define value

(0) Share

Report

Posted on by iMacPromoter

I am creating a program for calculate labour charge. I created a Microsoft power form to collect 3 value.

- No. of Normal working hour ($100)

- No. of OT working hour ($200)

- No. of Overnight working hour ($300)

I have use "initialize variable" create value collect no. of working hour and int the value for calculation.

Before multiple hourly charge and email the result out, we need to verify number of working hours as below criterial.

If value less than or equal to 0, value =0

If value larger than 0 and less than 2, value =2

If value larger than 2, value = value.

Which action should I use ?

I found I am not able to use 2 or 3 if value in one compose.

Please help to advise. Thanks!

iMac

Categories:

Building flows

I have the same question (0)

All responses (13)

Answers (5)

v-chengfen-msft on at

Like (0)

Report

Hi @iMacPromoter ,
Please try:
if(lessOrEquals(variables('no.of working hour'),0),0,if(and(greater(variables('no.of working hour'),0),less(variables('no.of working hour'),2)),'2',if(greater(variables('no.of working hour'),2),variables('no.of working hour'))))
I made a template for your reference

Here is result:

Best Regards
Cheng Feng

Was this reply helpful? Yes No
Verified answer

iMacPromoter 27 on at

Like (0)

Report

Thank you very much for your reply. However, I found error as below. Could you please help on that? Thanks!
The formula =
if(lessOrEquals(variables('TotalNormalHour'),0),0,if(and(greater(variables('TotalNormalHour'),0),less(variables('TotalNormalHour'),2)),2,if(greater(variables('TotalNormalHour'),2),variables('TotalNormalHour'))))

Error message:

iMac

Was this reply helpful? Yes No
Verified answer

v-chengfen-msft on at

Like (0)

Report

Hi @iMacPromoter ，
Sorry, the formula I gave did not take into account the case of equal to 2, so the formula failed.
Please try :
if(lessOrEquals(variables('TotalNormalHour'),0),0,if(and(greater(variables('TotalNormalHour'),0),lessOrEquals(variables('TotalNormalHour'),2)),2,if(greater(variables('TotalNormalHour'),2),variables('TotalNormalHour'))))

Best Regards
Cheng Feng

Was this reply helpful? Yes No
iMacPromoter 27 on at

Like (0)

Report

I found the formula is still not works and I found the flow will pass on value =0 or below 2. If value over 2 than error will shown. But if value over 0 and below 2, the value will not auto adjust to 2. Could you please advise? Thansk!

iMac

Was this reply helpful? Yes No
Verified answer

grantjenkins 11,063 Moderator on at

Like (0)

Report
I would suggest making a few changes to your Microsoft Form as described below. For all of your Working Hours fields do the following.
Restrict the entry for all the hours to number greater than or equal to 0.
Make the fields required.
Add subtitle informing the user to enter 0 if no hours.
This will ensure the data you get in your flow is never empty and a number greater than or equal to 0.

Clicking on Submit with no value entered.

Entering a number less than 0

Entering a non-number

Then within your flow use the following expressions.
//Initialize variable - change to your actual Microsoft Form field float(outputs('Get_response_details')?['body/r36af96f52ccb46ea8a572a44cc9094c0']) //Compose if( and( greater(variables('numberOfNormalWorkingHours'), 0), lessOrEquals(variables('numberOfNormalWorkingHours'), 2) ), 2, if( greater(variables('numberOfNormalWorkingHours'), 2), variables('numberOfNormalWorkingHours'), 0 ) )

----------------------------------------------------------------------
If I've answered your question, please mark the post as Solved.
If you like my response, please consider giving it a Thumbs Up.

Was this reply helpful? Yes No
Chriddle 8,441 Super User 2025 Season 2 on at

Like (0)

Report
You only need 2 comparisons and coalesce() handles null value:
if( greater(coalesce(outputs('No'), 0), 2), outputs('No'), if( greater(coalesce(outputs('No'), 0), 0), 2, 0 ) )

Was this reply helpful? Yes No
iMacPromoter 27 on at

Like (0)

Report

Hello,

Thank you very much for your reply. I have changed the form and code in the float. I found compose parts is works. But when I paste it in email and calculate (* hourly charge). I found the value is still keep before compose. (e.g. input value =1, in compose action =2, in email =1.) I have tried to add apply to each but show below error message. Please help! Thanks!

iMac

Was this reply helpful? Yes No
Verified answer

Chriddle 8,441 Super User 2025 Season 2 on at

Like (0)

Report

You do the calculation in the compose action, but in the mail you still use the variable.

Was this reply helpful? Yes No
iMacPromoter 27 on at

Like (0)

Report

Dear all,

Thank you very much for your support. Finally I successfully create my first flow for my company. I would like to ask more on the IF script. Could you please help to advise? Thanks!
If(and(greater(variables('TotalNormalHour'),0),lessOrEquals(variables('TotalNormalHour'),2)),2,If(greater(variables('TotalNormalHour'),2),variables('TotalNormalHour'),0))
1. For If statement, can we use more than 1 If statement in one compose action (or any limit on If statement in one compose)
2. What is the function of and in this formula? How should I use?

iMac

Was this reply helpful? Yes No
v-chengfen-msft on at

Like (0)

Report

Hi @iMacPromoter ,
Sorry, it took so long to reply to you,
the link below is the formula document link about power automate, please check
Reference guide for expression functions - Azure Logic Apps | Microsoft Learn

Hope this helps you

Best Regards
Cheng Feng

Was this reply helpful? Yes No