Question on Hiding a Datacard Based on the Value of a Multi-Select Options Datacard

Like (0) Share

Report

Posted on 10 Aug 2022 17:08:14 by kddsling

Hi Folks,

So I couldn't find a suggestion or solution for this that I can get working. I am able to and know how to hide a datacard based on a selection from another datacard if it was a single options field (the datacards/fields are all from a Sharepoint list). I am however getting stuck with getting it to work based on the selections from another datacard which is a multi-select options field.

Currently the formula I have (which does not work) is as follows for Visible:

("SIJS" in Type_of_Case_DataCard1.SelectedItems.Value), true, false

I'm assuming my syntax is wrong here?

Categories:

Using Apps Using Formulas

General Questions

All responses (13)

Answers (1)

SBax 1,348 on 10 Aug 2022 at 20:18:39

Like (1)

Report

Re: Question on Hiding a Datacard Based on the Value of a Multi-Select Options Datacard

Excellent news, glad I could help in some way
kddsling 49 on 10 Aug 2022 at 20:15:45

Like (1)

Report

Re: Question on Hiding a Datacard Based on the Value of a Multi-Select Options Datacard

@SBax Your concat formula proved to be useful as I had datacards which I needed to hide if either of 2 dropdown options were selected (so a If Or formula). The concatenation was the solution for that problem 🙂
rohitsbots 264 on 10 Aug 2022 at 18:16:34

Like (1)

Report

Re: Question on Hiding a Datacard Based on the Value of a Multi-Select Options Datacard

@kddsling Glad it worked!
kddsling 49 on 10 Aug 2022 at 18:12:31

Like (2)

Report

Re: Question on Hiding a Datacard Based on the Value of a Multi-Select Options Datacard

@rohitsbots Thank you graciously for the solution! This appears to be working.

@SBax Thank you graciously for your solution as well! I will test it separately (more tools for the toolbox!) just to see it working. I used Rohitsbots solution in my actual project though as that was just a bit cleaner and streamlined.
Verified answer

rohitsbots 264 on 10 Aug 2022 at 18:03:58

Like (2)

Report

Re: Question on Hiding a Datacard Based on the Value of a Multi-Select Options Datacard

@kddsling Instead of using Type_of_Case_DataCard1 use the DataCardValue. In my case

Data Card Name: TypeofCase_DataCard1
Data Card Value: DataCardValue8 (Select the combobox to see this)

You Visible formula should be--> "SIJS" in DataCardValue8.SelectedItems.Value
SBax 1,348 on 10 Aug 2022 at 18:03:50

Like (2)

Report
Re: Question on Hiding a Datacard Based on the Value of a Multi-Select Options Datacard

@kddsling

I have a solution, you need to concatenate the selected items into a Comma Separated String, then check if that string contains SIJS

to do this you would use Concat(ComboBoxName.SelectedItems,Value , ", ")

We could also simplify by removing the if since the in statement will return true/false anyway

"SIJS" in Concat(DataCardValue4.SelectedItems,Value , ", ")
SBax 1,348 on 10 Aug 2022 at 17:51:14

Like (1)

Report

Re: Question on Hiding a Datacard Based on the Value of a Multi-Select Options Datacard

I have managed to replicate this and am getting similar behaviour (i.e. its hidden it it should be, but not visible if it the combobox field does not contain "SIJS")

I'm working on a solution now, please bear with me for 30 mins
kddsling 49 on 10 Aug 2022 at 17:41:07

Like (0)

Report

Re: Question on Hiding a Datacard Based on the Value of a Multi-Select Options Datacard

Datasource is a Sharepoint list. The field is a Choice field that allows for multiple selections.
NandiniBhagya20 4,667 Super User 2024 Season 1 on 10 Aug 2022 at 17:41:05

Like (1)

Report

Re: Question on Hiding a Datacard Based on the Value of a Multi-Select Options Datacard

Apologies, there should be “before SIJS in above formula
@SBax
thanks for pointing it out
SBax 1,348 on 10 Aug 2022 at 17:39:50

Like (0)

Report

Re: Question on Hiding a Datacard Based on the Value of a Multi-Select Options Datacard

In your datasource, is the field that contains SIJS a plain text field or a lookup?