Answered

Make DataCard required/visible based on inputs of another DataCard

(1) Share

Report

Posted on by max.030

Hello, I am currently trying to create an Form that needs to make an DataField appear if specific values are being choosen (see Screenshot 1).

To be precise, 3 out of 11 Values (Screenshot 2) need to trigger the DataField "Alternative Supplier" as visible. The catch is that a multiple selection must be possible within the DataField "Material Category".

This means that as soon as one of the three relevant material categories is being choosen, the "Alternative Supplier" field must be triggered.

I only used

If(DataCardValue113.Selected.Value="Yes";true;false)

so far. This worked out for me since all of the fields only used a "yes" or "no". I never needed to include more than one condition.*

I need something like:

If("Material Category".Selected.Value="A201 or A314 or D506";true;false)

Can you support me somehow?

Thanks in advance. 

*edit: The example I showed has been added to the "visibility" field of the respective DataCard I want to make in/visibile.

Categories:

Building Power Apps

I have the same question (0)

All responses (7)

Answers (1)

Sort by

Suggested answer

AmínAA 1,228 Moderator on at

Like (2)

Report
Copy link

Link copied!
Greetings!

Well, you can certainly try something like the following!

If( Or( DataCardValue113.Selected.Value = "A201", DataCardValue113.Selected.Value = "A314", DataCardValue113.Selected.Value = "D506" ); true; false )

It's pretty much basic, but that should suffice for you . . .

Hopefully that's enough to solve your problem, if so, feel free to mark this reply as an answer, otherwise feel free to reply!

Was this reply helpful? Yes No
max.030 10 on at

Like (2)

Report
Copy link

Link copied!

Hey @AmínAA,

damn, you are quick! Thank you! It is indeed very basic, unfortunately I am not an expert and need to work mostly with youtube tutorials and this forum that already helped me a lot.

That being said, I tried to implement what you just posted by it tells me that seemingly somewhere is a mistake.

Any idea what the issue could be?

Was this reply helpful? Yes No
AmínAA 1,228 Moderator on at

Like (1)

Report
Copy link

Link copied!

Hi there Max.030!

The error is pretty simple I forgot to change the commas for semicolons just switch the "," of your code with ";". That should do the trick!

Was this reply helpful? Yes No
max.030 10 on at

Like (1)

Report
Copy link

Link copied!
It now makes the field visible whenever at least one of the 3 Numbers is being choosen.

The problem is, whenever you choose a different number than one of the three, the field is unvisible again. I get the logic why this happens, but no chance to translate it into code. Any idea how this could be approached?

If( Or( DataCardValue113.Selected.Value = "A201"; DataCardValue113.Selected.Value = "A314"; DataCardValue113.Selected.Value = "D506" ); true; false )

Was this reply helpful? Yes No
Verified answer

AmínAA 1,228 Moderator on at

Like (1)

Report
Copy link

Link copied!
Sure thing, something like this should be able to accomplish that without any problems!

If( CountIf( DataCardValue113.SelectedItems; Or( Value = "A201"; Value = "A314"; Value = "D506" ) ) > 0; true; false )

Was this reply helpful? Yes No
max.030 10 on at

Like (2)

Report
Copy link

Link copied!

This worked for me! It may be a small step for you, but a huge one for me. Thank you!

Was this reply helpful? Yes No
AmínAA 1,228 Moderator on at

Like (1)

Report
Copy link

Link copied!

You're welcome max.030!

Every step forward, no matter small or huge, is progress. Keep it up!

Was this reply helpful? Yes No