cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Magoforrest
Helper I
Helper I

if function value and text return

Hello, i am new in power apps and i need some help.

i am trying to get a text or a number back from an if function. let me explain my self better.

if from my dropdown list from excel (1,2,3,4,5) i select  4 i'll need to write in my input label "selection not valid"...and if i select a value  ❤️ i need to have a number value back.

if(E12p.Selected.Value="WET"&&Value(E16n.Selected.'Misurazioni in mm')>3,"no",........other multiple if)

 

in this case if from my drop down i select WET and athe sametime from an ather dropdown "E16" i select a value greater then 3 i will like to write "no" in my TextInput ..... 

2 ACCEPTED SOLUTIONS

Accepted Solutions

Label : If(Dropdown3.Selected.Name="Test" &&Value(Dropdown3_1.SelectedText.Value,"en-us")<2,"no")

Dropdown3: Table({Name:"Test"},{Name:"Testing"})

Dropdown3_1: Table({Name:"1"},{Name:"2"})

image.png

It's working fine... you can see

View solution in original post

the solution u gave me works fine  🙂 for my project, but now i am trying to filter my selection in the second dropbox.... if in the first drop box i choose an item i want the item to have it special list....

for example if in the fisrt dropbox i have:

water

in the second i want the user to select only certain values like:

-2

-3

if in the first dropbox the select snow:

-6

-7

-8

 THKS!

 

View solution in original post

10 REPLIES 10
AsanKani
Skilled Sharer
Skilled Sharer

You can try below 

if(E12p.Selected.Value="WET"&&Value(E16n.Selected.'Misurazioni in mm',"en-US")>3,"no",.......)

Did this post solve your problem? Please click
Accept as Solution so that others may find it more quickly.
If you liked my response, please give it a Thumbs Up.

Magoforrest_0-1614009695645.png

thx for the replay but it returns a black value...have a look

ArminSimon
Helper II
Helper II

If I interpret this correct, you mix up numbers and text. If you just return text (i.e. "3", "no" etc.) may help.

 

Just my 2 cents

You can once try single if not more logical condition.. what you required that is working or not ? let me know

from what i see if i keep it with no other if's it works..... 

Label : If(Dropdown3.Selected.Name="Test" &&Value(Dropdown3_1.SelectedText.Value,"en-us")<2,"no")

Dropdown3: Table({Name:"Test"},{Name:"Testing"})

Dropdown3_1: Table({Name:"1"},{Name:"2"})

image.png

It's working fine... you can see

Ok, this works...great! can i add an other question? if i select "name"in the first dropdown how can i restict the visible values in the other drop down?

I can't catch what did you ask exactly ?

the solution u gave me works fine  🙂 for my project, but now i am trying to filter my selection in the second dropbox.... if in the first drop box i choose an item i want the item to have it special list....

for example if in the fisrt dropbox i have:

water

in the second i want the user to select only certain values like:

-2

-3

if in the first dropbox the select snow:

-6

-7

-8

 THKS!

 

Helpful resources

Announcements
Power Apps Africa Challenge 2022

Power Apps Africa Challenge

Your chance to join an engaging competition of Power Platform enthusiasts.

Super User 2 - 2022 Congratulations

Welcome Super Users

The Super User program for 2022 - Season 2 has kicked off!

September Events 2022

Check out all of these events

Attend in person or online, there are incredible conferences and events happening all throughout the month of September.

Government Carousel

New forum: GCC, GCCH, DoD - Federal App Makers (FAM)

In response to the unique and evolving requirements of the United States public sector, Microsoft has created Power Apps US Government.

Users online (2,510)