cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Big_S Helper IV
Helper IV

If statement

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

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Community Support
Community Support

Re: If statement

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,

Community Support Team _ Kris Dai
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

2 REPLIES 2
Highlighted
Community Support
Community Support

Re: If statement

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,

Community Support Team _ Kris Dai
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Big_S Helper IV
Helper IV

Re: If statement

Hi @v-xida-msft 

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

Helpful resources

Announcements
MBAS Gallery 2020

MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.

firstImage

New Ranks and Rank Icons released on April 21!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power Apps Community!

Top Solution Authors
Top Kudoed Authors
Users online (6,491)