Lookup on combobox multiple selected value

Like (0) Share

Report

Posted on 9 Dec 2022 08:47:04 by nejhade

Hello Genius out there,

Here I need help in power apps.

Actually I am trying to have Lookup on mutiple values selected from Combo box and concating them with','

I have written code below but not working as expected.(It is doing lookup on first combo selection only and giving repeated value)

Concat(
ForAll (
BusinessRoleComboBox.SelectedItems,
LookUp(
'UAM_BUSINESS.RLS_CONFIG',
PRODUCT_NAME = ComboBox1_2.Selected.Result And ENVIRONMENT = EnvironmentComboBox.Selected.Result And DATA_RESTRICTION = BusinessRoleComboBox.Selected.Result,
AD_GROUP_ID
)
),
Value,
","
)

I have made 2 selection in combo box, the value should match with DATA_RESTRICTION and give respective ADGROUPID to me. but it is giving 2 ADGROUP ID with same details.

Can someone else me with this.

Categories:

Using Apps Using Formulas

General Questions

All responses (2)

Answers (1)

MechEng2013 257 on 22 Aug 2023 at 21:32:29

Like (0)

Report

Re: Lookup on combobox multiple selected value

@nejhade Where did you place this code to make it work?? I'm trying to do the same thing.
Thanks!
Verified answer

nejhade 80 on 09 Dec 2022 at 10:52:14

Like (0)

Report

Re: Lookup on combobox multiple selected value

I got answer for this, Thanks. Keeping it for future if someone needs it.

Concat(
ShowColumns(
Distinct(
Filter(
'BUSINESS.RLS_CONFIG',
PRODUCT_NAME = ComboBox1_2.Selected.Result && ENVIRONMENT = EnvironmentComboBox.Selected.Result && DATA_RESTRICTION in BusinessRoleComboBox.SelectedItems.Result),
AD_GROUP_ID),"Result"),
Result,
","
)