Condition IF or Switch - With Field Text Input Cost and Field Text Input E-mail related Each Other

[WendeReisss]

Hi!
@RandyHayes @mdevaney ,

Can you help me with the follow doubt:

I have a field (Text Input 1) to insert "cost" ($ 1,000 etc...) maually.

I have another field (Text Input 2) to insert "Email" as simple text manually (wend@powerapps.com) or (wend@powerapps.com; reis@powerapps.com)

---------------------------------------------------------------------------------------------------------------------------------

I need help for this:

I need to link cost with e-mail. For instance:

If or Switch cost (Text Input 1) be >= $ 1,000 and <= $ 2,000, the field Text Input 2 show "wend@powerapps.com"

If or Switch cost (Text Input 1) be between >= $ 2,001 and <= $ 3,000, the field Text Input 2 show "wend@powerapps.com; reis@powerapps.com"

If or Switch cost (Text Input 1) be between >= $ 3,001 and <= $ 4,000, the field Text Input 2 show "name@powerapps.com"

If is blank field stay in blank

[Ismael_Novo · Accepted solution]

Hi WendeReisss.

This could be a first aproach to your need:

If( 
    Value(TextInput1.Text) >= 1000 And Value(TextInput1.Text) <= 2000; "wend@powerapps.com" ;
    Value(TextInput1.Text) >= 2001 And Value(TextInput1.Text) <= 3000; "wend@powerapps.com;reis@powerapps.com" ;
    Value(TextInput1.Text) >= 3001 And Value(TextInput1.Text) <= 4000; "name@powerapps.com" 
)

 Kind regards

[WendeReisss]

Because of my Power Apps language, I have to change semicolon (;) in your solution to comma (,).

You explanation was very helpful. Thank you so much for your help.

[WendeReisss]

Ismael_Novo
Because of my Power Apps language, I have to change semicolon (;) in your solution to comma (,).

You explanation was very helpful. Thank you so much for your help.