Answered

If statement

(0) Share

Report

Posted on by Big_S

494

Hi Guys,
Does anyone know how to apply the If statement on this scenario? What happened If the Requestor request for >=500000 amount the approver is team.chua@leader.ph if the amount is >=100000 the approver is team.guioguio@leader.ph. My problem is if the requestor is team.guioguio@leader.ph and amount she requested is >=100000 her approver is herself(team.guioguio@leader.ph) supposedly her direct approver is team.chua@leader.ph

this is my formula
If(
Value(TotalAmount_4.Text) >= 500000,
Office365Users.UserProfile("team.chua@leader.ph").DisplayName,
If(
Value(TotalAmount_4.Text) >= 100000,
Office365Users.UserProfile("team.guioguio@leader.ph").DisplayName,
Office365Users.UserProfile(Label40.Text).DisplayName
)
)

Thank you so much

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

v-xida-msft Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!
Hi @Big_S ,

Do you want to make the approver as "team.chua@leader.ph" if the Requestor is "team.guioguio@leader.ph" and the request amount is more than 100000?

Based on the needs that you mentioned, I think the If function could achieve your needs. I have made a test on my side, please consider modify your formula as below:

If( Value(TotalAmount_4.Text) >= 500000, Office365Users.UserProfile("team.chua@leader.ph").DisplayName, Value(TotalAmount_4.Text) >= 100000, If( User().Email = "team.guioguio@leader.ph", Office365Users.UserProfile("team.chua@leader.ph").DisplayName, Office365Users.UserProfile("team.guioguio@leader.ph").DisplayName ), Office365Users.UserProfile(Label40.Text).DisplayName )

Please consider take a try with above solution, then check if the issue is solved.

Best regards,

Was this reply helpful? Yes No
Big_S 494 on at

Like (0)

Report
Copy link

Link copied!

Hi @v-xida-msft

I will execute this! thank you so much!!!! ❤️ 🙂

Was this reply helpful? Yes No