Help With Separator

(0) Share

Report

Posted on by knishal

185

I have the following code which filter a SharePoint list and look up the data.

With({_dataForSecondDD: Choices(AccountCreationList.'Client''s Floor Number:')},
 ForAll(Choices(AccountCreationList.'Client''s Work Address:') As _choice,
 {Value: _choice.Value,
 Items: 
 Switch(_choice.Value,
 "56 Wood ST", Filter(_dataForSecondDD, Value in "8th floor 9th floor 12th floor"),

 "59 Main Street", Filter(_dataForSecondDD, Value in "34th floor, 35th floor, 36th floor, 37th floor"),

 

 _dataForSecondDD
 )
 }
 )
)

Currently the code is separating the numbers for example: 34th floor is showing as 4th floor. Is there a way to separate this to show 34th floor etc?

This is resolve on a another post:

https://powerusers.microsoft.com/t5/Building-Power-Apps/Hide-Dropdown-Fields-Based-On-a-Selection/m-p/1787804#M453391

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (2)

Verified answer

RandyHayes 76,297 Super User 2024 Season 1 on at

Like (0)

Report
@knishal

Yes, the key is to get it specific by providing a separator around it.

The formula would become:

With({_dataForSecondDD: Choices(AccountCreationList.'Client''s Floor Number:')}, ForAll(Choices(AccountCreationList.'Client''s Work Address:') As _choice, {Value: _choice.Value, Items: Switch(_choice.Value, "56 Wood ST", Filter(_dataForSecondDD, "|" & Value & "|" in "|8th floor|9th floor|12th floor|"), "59 Main Street", Filter(_dataForSecondDD, "|" & Value & "|" in "|34th floor|35th floor|36th floor|37th floor"), _dataForSecondDD ) } ) )

This will enforce that you are really matching |34th floor| against |34th floor|

Was this reply helpful? Yes No
knishal 185 on at

Like (0)

Report

@RandyHayes thank you so much. It works. Do you know why I am unable to add hint text after adding this formula and unable to search the dropdown?

Was this reply helpful? Yes No
knishal 185 on at

Like (0)

Report

@RandyHayes update: I was able to turn on the search combox. Still Need help with the hint text

Was this reply helpful? Yes No
Verified answer

knishal 185 on at

Like (0)

Report

This is resolved, just needed to turn on allow search.

Was this reply helpful? Yes No