Unanswered

Help - If function with datacardvalue vs dropdown box

(0) Share

Report

Posted on by Rxdpunk

Hello all,

I have a custom canvas app that uses forms from a sharepoint list. I am trying to build in some validation. In my equipment inspection form the user will select many dropdown boxes that have a choice of either "pass" or "fail". When trying to use if(datacardvalue.selected.value = "fail", true) set on visible on my test label I can not get it to work. If do this with an input dropdown box outside of a form I can make it work. Any help would be appreciated.

Label - Visible - If(Dropdown1.Selected.Value = "906", true) this works and my label displays

Label - Visible - If(DataCardValue37.Selected.Value = "906", true) this does not work

Categories:

Building Power Apps

I have the same question (0)

All responses (11)

Answers (0)

PowerRanger 3,458 Super User 2024 Season 1 on at

Like (0)

Report
@Rxdpunk

Double check your formula if it really references the right ComboBox. I did a test on my side and for me it is working fine.

I have a form based on a SharePoint List, a column named myChoices which is a choice field with allowwed values of "Fail" and "Pass".
I use this formular on the <Visible> property of a label:

If(DataCardValue10.Selected.Value = "Pass",true,false)

If you still having issues please let me know and provide some more details about your form and maybe a screenshot of the controls/formulars.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Was this reply helpful? Yes No
Rxdpunk 12 on at

Like (0)

Report

Thanks for the reply. Still not working on my end. But I am very newb to this.

Was this reply helpful? Yes No
Rxdpunk 12 on at

Like (0)

Report

I tried it without the "false" in there as well

Was this reply helpful? Yes No
PowerRanger 3,458 Super User 2024 Season 1 on at

Like (0)

Report

@Rxdpunk

Is DataCardValue37 a MultiSelect ComboBox?

Was this reply helpful? Yes No
Rxdpunk 12 on at

Like (0)

Report

No it is not. The user should only be allowed to select one item.

Was this reply helpful? Yes No
PowerRanger 3,458 Super User 2024 Season 1 on at

Like (0)

Report

@Rxdpunk

Could you make a Screenshot of the field in SharePoint to see it's settings.

Was this reply helpful? Yes No
Rxdpunk 12 on at

Like (0)

Report

@PowerRanger does this help ?

Was this reply helpful? Yes No
Rxdpunk 12 on at

Like (0)

Report

@PowerRanger

Was this reply helpful? Yes No
PowerRanger 3,458 Super User 2024 Season 1 on at

Like (0)

Report

@Rxdpunk

YYes and no. This looks just like the column I created and for me it is working just fine with the formular I posted before.

Could you please try the following

1. Create a new list with a choice column, choices are Pass and Fail
2. Create a new app, add this list as a datasource, add a Form to the app and just select the title field and the choice field as fields.
3. Add a label and Set the text to show anything
4. Use the formular from my previous post in the Visible property of that label

Was this reply helpful? Yes No
Rxdpunk 12 on at

Like (0)

Report

@PowerRanger Sorry, for the delay. But, I had time today do do what you asked. I created a new Sharepoint List. It only has the title column and a choice column "Pass, Fail". I created a new canvas app. I added this list as my data source. I insterted a new form. The list is set as the data source for the form. I have title and choice as the only fields. I tried the code you posted and it is not working for me. I have included screenshots.

Was this reply helpful? Yes No