cancel
Showing results for
Did you mean:
Highlighted
Helper V

## 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,
If(
Value(TotalAmount_4.Text) >= 100000,
Office365Users.UserProfile(Label40.Text).DisplayName
)

Thank you so much

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
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,
Value(TotalAmount_4.Text) >= 100000,
If(
),
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.
2 REPLIES 2
Highlighted
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,
Value(TotalAmount_4.Text) >= 100000,
If(
),
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.
Highlighted
Helper V

## Re: If statement

Hi @v-xida-msft

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

Announcements

#### Power Platform Community Conference

Check out the on demand sessions that are available now!

#### Power Platform ISV Studio

ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.

#### Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

#### Maratón de Soluciones de Negocio Microsoft

Una semana de contenido con +100 sesiones educativas, consultorios, +10 workshops Premium, Hackaton, EXPO, Networking Hall y mucho más!

Top Solution Authors
Top Kudoed Authors
Users online (10,460)