Skip to main content

Notifications

Power Apps - Building Power Apps
Answered

If statement

(0) ShareShare
ReportReport
Posted on by 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:
  • Big_S Profile Picture
    Big_S 494 on at
    Re: If statement

    Hi @v-xida-msft 

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

  • Verified answer
    v-xida-msft Profile Picture
    v-xida-msft on at
    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,

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,422

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,711

Leaderboard