Change Display based on Value

(0) Share

Report

Posted on by RyoIshi731

238

I would like to change visible/nonvisible based on the item selected.

In below picture, if the Service Category Value includes Troubleshoot, I don't want to display 1.Symptom of trouble.

Now questions are

1. I write like this however error happens.

If(ThisItem.'Service Category' ="*TroubleShooting*",false,true)

The error says that data type is different. Since Service Category is table type, it is error? How can I solve this error?

2. I want to use wild card. Is it possible in PowerApps? If possible, how can I do it?

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (1)

Sort by

shoog 2,164 on at

Like (1)

Report
Copy link

Link copied!

For the first one, you probably want to refer to the dropdown rather than ThisItem, so the visibility changes when someone changes the service category. The formula for Visible would be DataCardValue1.Selected.Name = "TroubleShooting" (replace DataCardValue1 with the appropriate control).

For the second question you are probably looking for the IsMatch function. If not, please clarify what you want to achieve.

Was this reply helpful? Yes No
RyoIshi731 238 on at

Like (0)

Report
Copy link

Link copied!

@shoog Thank you for your answer.

Sorry I still don't understand what should I write visible formula. Error is happening.
The error message is saying that data type is different.

and could you explain more detail about this.
(replace DataCardValue1 with the appropriate control)
What I want to do is to make 'Symptoms of Trouble 'invisible if the dropdown of 'Service Category' included "Troubleshooting".

Sorry I am quite beginner.

Was this reply helpful? Yes No
RyoIshi731 238 on at

Like (0)

Report
Copy link

Link copied!

@shoog

>For the second question you are probably looking for the IsMatch function. If not, please clarify what you >want to achieve.
Yes, I think isMatch function. If the 'Service Category' includes the "TroubleShooting" I want to display/not display certain datacard.
However isMatch function can be used for text input? 'Service Category' is dropdown, so data type is table.
How can I convert data type from dropdown to text?

Was this reply helpful? Yes No
Verified answer

v-qiaqi@microsoft.com Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!
Hi @RyoIshi731,

Have you solved your problem?

Do you want to make the data card invisible based on the Combo Box selected?

Could you please tell me more about your scenario?

Actually, make sure how you configure your Combo Box name in your Service Category data card. DataCardValue90 is the control from your Symptoms of Trouble data card, so please ensure the real data card value in your Service Category data card.

Please select the whole Symptoms of Trouble data card and set the Visible property as below:

If("TroubleShoot" in Concat(DataCardValue_Service_Category.SelectedItems,Value,","),false,true)

In addition, how to write the above formula depends on how you configure your dropdown of 'Service Category' Items property.

What's more, to convert dropdown value to text, just use the Concat() function as the above formula wrote.

Was this reply helpful? Yes No
RyoIshi731 238 on at

Like (0)

Report
Copy link

Link copied!

@v-qiaqi-msft Thank you so much.
I could solve it by writing like this.

If("TroubleShoot" in Concat(DataCardValue85.SelectedItems,Value,","),false,true)
The Service Category is DataCardValue85.

Was this reply helpful? Yes No
RyoIshi731 238 on at

Like (0)

Report
Copy link

Link copied!

@v-qiaqi-msft

Thank you.
Thanks to your advice I can do it what I want to do.
# Before select anything, screen is like this.
If I select 'Troubleshoot' in "service category" drop down, some items are disappeared like below picture.
However there is unnecessary space marked in Yellow. This is not beatiful and is it possible to allign in nice way? I don't want this space, "Project Name" should come right of Transportation.

Was this reply helpful? Yes No