Hiding Datacard within form problem

(0) Share

Report

Posted on by qwedwq

Hi there,

I have a form that has a dropdown in a datacard which contains a Yes/No choice option.

I have another datacard that I only want visible if the dropdown choice = yes

I'm using the following formula but am getting a "incompatible type for comparison" error.

If(DataCardValue24_1.Selected.Value="Yes",true,false)

Any help would be much appreciated.

Categories:

Building Power Apps

I have the same question (0)

All responses (10)

Answers (1)

TheRobRush 11,128 Moderator on at

Like (0)

Report
Copy link

Link copied!

should change it to DataCardValue24_1.Selected.Value=1 or true, one of those should work (yes no column in sharepoint is boolean)

Was this reply helpful? Yes No
qwedwq 22 on at

Like (0)

Report
Copy link

Link copied!

Thanks - Unfortunately i'm getting the same error with either =1 or =true.

Was this reply helpful? Yes No
qwedwq 22 on at

Like (0)

Report
Copy link

Link copied!

I should also add that I am using dataverse rather than Sharepoint.

Was this reply helpful? Yes No
TheRobRush 11,128 Moderator on at

Like (0)

Report
Copy link

Link copied!
put a label next to your DataCardValue24 and set its text to

DataCardValue24.Selected.Value

so hyou can find out what the appropriate format is on your form

Was this reply helpful? Yes No
VaidasG 469 on at

Like (0)

Report
Copy link

Link copied!

hi @qwedwq

I managed to replicate your requirement, and it works perfectly well for me...
nothing wrong with your formula, I used - If(DataCardValue26_6.Selected.Value = "Yes", true, false), if items inside your dropdown list are Strings!!!
Make sure you set this formula for DataCard Visible property of the card you want to hide

Regards

Was this reply helpful? Yes No
qwedwq 22 on at

Like (0)

Report
Copy link

Link copied!

The label is returning "Yes" as the value, so not sure why the original formula I am using isn't working.

Was this reply helpful? Yes No
VaidasG 469 on at

Like (0)

Report
Copy link

Link copied!

what do you have in the Items property of your dropdown?

Was this reply helpful? Yes No
qwedwq 22 on at

Like (0)

Report
Copy link

Link copied!

Here is what I have in the Items property: Choices('Service? (Kaizen Job Sheets)')

The formula I'm using to hide the datacard is in the visible property.

Was this reply helpful? Yes No
Verified answer

VaidasG 469 on at

Like (2)

Report
Copy link

Link copied!

ahhhh, why don't you try - If(DataCardValue24_1.Selected.Value='Service? (Kaizen Job Sheets)'.Yes ,true, false)

In this case you need to reference to Choice item, rather than label value

Regards

Was this reply helpful? Yes No
qwedwq 22 on at

Like (2)

Report
Copy link

Link copied!

Thats worked - thank you so much 👍

Was this reply helpful? Yes No