Hide characters in a Combo Box

(0) Share

Report

Posted on by collinktx

232

Hello,

In my Power App I have a Data Card with a Combo Box pulling it's data from a sharepoint list. I want to hide the first 4 characters from showing up in the Power App. Is there a way to do this?

Example:

Sharelist Column is 1 - Apple, 2 - Orange, 3 - Bannana

When accessed through my Combo Box in Power Apps I want them to only see Apple, Orange, Bannana

Thanks,

Collin

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Verified answer

charlessexton 21 Super User 2024 Season 1 on at

Like (2)

Report
Copy link

Link copied!
One way you could do it would be to add a formatted column to your data. So in the Items property of your combobox you would have:
AddColumns(SHAREPOINTLIST, "New Title", Mid(Title, 5))
The Mid() function tells the string to start at the 5th character, so ignoring the first 4 characters.

Then in the DisplayFields property of your combobox you would have:
["New Title"]

Was this reply helpful? Yes No
collinktx 232 on at

Like (0)

Report
Copy link

Link copied!

That worked. I do have 2 new problem that maybe you can help me with.

1. Making the characters I want hidden means my Power App cannot interact with them now, is this correct? I was using a Concatenate and Left formula to take the numbers at the begining of the data and combine them in another data card. This does not work now. I assum the formula we used just takes the values away and not hide them, correct?

2. The Sharelist I use has multiple columns and some are very long. How can I have blank values not show in my combo box?

For example I have one column with 15 items and another with just 4. The column with 4 items is giving me 11 blank spaces. I set the sharelist up for all my drop down options to import from one location.

Thanks again and I do love the solution. Sorry if I am not explaining everything well. I am still pretty new to this.

Collin

Was this reply helpful? Yes No
charlessexton 21 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi Collin,

I'm glad it worked. Would you mind marking it as a solution and then pasting your new questions into their own topic(s)? This will help others who are looking for the same thing.

Was this reply helpful? Yes No