If Or condition

(0) Share

Report

Posted on by Kmayes

792

Hi Community

I have a question with the IF(OR function within Power Apps I'm building an page where I want a button to be visible on condition of the values of data card values. Some data types are string and some are number on doing some testing I can get this to work if values are one type but not a mixture.

Text Example

IF(Or(DataCardValue71.Text="Yes",DataCardValue72.Text="Yes"),true, false)

Number Example

If(Value(DataCardValue75.Text)>0,true,false)

How do I write the formula to check both number and string types?

Categories:

Building Power Apps

I have the same question (0)

All responses (10)

Answers (1)

eka24 20,923 on at

Like (0)

Report

If(DataCardValue71.Text="Yes" Or

Value(DataCardValue75.Text)>0),true, false)

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

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

Was this reply helpful? Yes No
Kmayes 792 on at

Like (0)

Report

@eka24

Unfortunately this doesn't work it doesn't pick up when entering the number only the text?

Was this reply helpful? Yes No
eka24 20,923 on at

Like (0)

Report

If you can explain further what is not picking up. What do you want the formula to do if number or if text.

Do you want to text if it number or text?

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

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

Was this reply helpful? Yes No
Kmayes 792 on at

Like (0)

Report

@eka24 So for example if "Yes" is entered in the first Data card or a number >0 is entered in the second data card I want a button to be visible

Was this reply helpful? Yes No
Verified answer

eka24 20,923 on at

Like (1)

Report

On the Visible property of the button you want to hide put;

DataCardValue71.Text="Yes" Or

Value(DataCardValue75.Text)>0

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

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

Was this reply helpful? Yes No
Kmayes 792 on at

Like (0)

Report

@eka24

Hi
I know where to put it, the formula isn't working though it comes up with an error?

Was this reply helpful? Yes No
eka24 20,923 on at

Like (0)

Report

You have changed the code I suggested. Can you try that and give feedback?

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

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

Was this reply helpful? Yes No
Kmayes 792 on at

Like (0)

Report

@eka24

When entering the exact suggested code it brings back an error as above

Was this reply helpful? Yes No
eka24 20,923 on at

Like (0)

Report

This was the last code I posted

DataCardValue71.Text="Yes" Or

Value(DataCardValue75.Text)>0

Remove the if.

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

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

Was this reply helpful? Yes No
Kmayes 792 on at

Like (0)

Report

@eka24 Perfect thank you sorry I thought you just missed the 'IF' off

Was this reply helpful? Yes No