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

All responses (4)

Answers (2)

Sort by

Verified answer

RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
@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|
knishal 185 on at

Like
a
(0)

Report
Copy link

Link copied!

@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?
knishal 185 on at

Like
a
(0)

Report
Copy link

Link copied!

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

knishal 185 on at

Like
a
(0)

Report
Copy link

Link copied!

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