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
Solved! Go to Solution.
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,
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,
Stay up tp date on the latest blogs and activities in the community News & Announcements.
Mark your calendars and join us for the next Power Apps Community Call on January 20th, 8a PST
Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.
User | Count |
---|---|
208 | |
187 | |
82 | |
56 | |
36 |
User | Count |
---|---|
287 | |
245 | |
119 | |
81 | |
55 |