cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Big_S
Level: Powered On

Change Approver

Hi Guys,
Does anyone know how to execute this scenario?
I have 3 approvers this is the situations:
I will input amount to text input If less than or equal to 100,00.00 thousand Approver 1
If the amount is greater than 300,00.00 thousand Approver 2
If the amount is greater than 500,00.00 thousand Approver 3
aprvr1.PNG

1 ACCEPTED SOLUTION

Accepted Solutions
shailendra74
Level 8

Re: Change Approver

Hi @Big_S 

 

Having a list gives you more flexibility. However this what you are looking for:

 

Set the Text property of the label to :

 

If(
    Value(TextInput1.Text) >= 500000,
    "Approver 3",
    If(
        Value(TextInput1.Text) >= 300000,
        "Approver 2",
        "Approver 1"
    )
)
6 REPLIES 6
shailendra74
Level 8

Re: Change Approver

Hi @Big_S 

 

Do you have a approver list along with amount in sharepoint. If so, based on the amount entered you can get the list and populate dropdown/combobox.

 

On change of the TextInput control

 

ClearCollect(collApprovers, Filter('Approver List, 
Amount>= Value(TextInput1.Text), Amount <= Value(TextInput1.Text) ))

 

Set the Items property of combobox to collapprovers. You might have more than 1 approvers for a given range.

 

Thanks.

 

 

Big_S
Level: Powered On

Re: Change Approver

Hi @shailendra74 ,
I don't have amount list in SQL, I have default approvers and amount like
If lesser than or equal to 100,00.00 Approver 1
If greater than 300,00.00 Approver 2
If greater than 500,00.00 Approver 3
Can this execute on If statement?

 

Big_S
Level: Powered On

Re: Change Approver

@shailendra74 
I got your point on creating a list of approvers and their amounts on my data source

Big_S
Level: Powered On

Re: Change Approver

@shailendra74 
I have default names for Approver 1,2 and 3 that's why I'm trying to execute the If else statement can this be done?

shailendra74
Level 8

Re: Change Approver

Hi @Big_S 

 

Having a list gives you more flexibility. However this what you are looking for:

 

Set the Text property of the label to :

 

If(
    Value(TextInput1.Text) >= 500000,
    "Approver 3",
    If(
        Value(TextInput1.Text) >= 300000,
        "Approver 2",
        "Approver 1"
    )
)
Big_S
Level: Powered On

Re: Change Approver

@shailendra74 

Yes youre right, I will try this first Smiley Happy THANK YOU SO MUCH! <3 I will keep you posted Smiley Happy

Helpful resources

Announcements
firstImage

Watch Sessions On Demand!

Continue your learning in our online communities.

SecondImage

Follow PowerApps on Twitter

Stay Up-to-Date by following PowerApps on Twitter

Top Community Contributors for July 2019

Top Community Contributors for July 2019

Let's thank our top community contributors

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

FirstImage

Power Platform World Tour

Coming to a city near you

thirdimage

PowerApps Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

FourthImage

Join PowerApps User Group!!

Connect, share, and learn with your peers year-round

FifthImage

Dynamics 365 and Power Platform April 2019 Release notes

Features releasing from April 2019 through September 2019!

Users Online
Currently online: 55 members 4,273 guests
Please welcome our newest community members: