Answered

ComboBox - ForAll and LookUp

(0) Share

Report

Posted on by VictorMafra

Hello,
I have a problem that, in my combobox has the Name to filter the collection to filter the Name_ID from another table.
So I'm trying to create something like this:

ClearCollect(colVault, Filter('mdf.Vault_Changes', Item_Reviewed = false || Item_Reviewed = Blank(), **** (right here ->) ***** Site_ID in LookUp(colSite, ForAll(cb_SiteName.SelectedItems) in Site_Name, Site_ID)));

But it's not working, I can make it works with ONE selected value from the combobox, but I want to have the possibility to pick more than one value.
Does anyone know how to fix this?

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Sort by

v-jefferni Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!
Hi @VictorMafra ,

Based on your formula, I assume you would like to add a criteria in the first Filter function, i.e. get site IDs based on the selected site names in the Combo box. If so, please try below formula OnChange of the Combo box:

Clear(colSiteIDs); ForAll(cb_SiteName.SelectedItems.Site_Name As SN ,Collect(colSiteIDs,LookUp(colSite, SN.Site_Name = Site_Name, Site_ID)); ClearCollect(colVault, Filter('mdf.Vault_Changes', Item_Reviewed = false || Item_Reviewed = Blank(), Site_ID in colSiteIDs.Site_ID))

Best regards,

Was this reply helpful? Yes No
Verified answer

VictorMafra 30 on at

Like (0)

Report
Copy link

Link copied!
Hello @v-jefferni ,

I got it creating some support collections. I dont know why but the combobox SearchField is not able to use columns with number type.
In the combobox I am just showing the site_name, and in the button to filter I have this code below:

Clear(colSupport2); Clear(colGridData); Clear(colVault); ClearCollect(colSupport2, cb_SiteName.SelectedItems); ForAll(colSupport2, Collect(colVault, Filter('mdf.Vault_Changes',Item_Reviewed = false || Item_Reviewed = Blank(),Site_ID = colSupport2[@Site_ID]))); ClearCollect(colGridData,AddColumns(colVault,"Site_Name",LookUp(colSite,Site_ID = colVault[@Site_ID],Site_Name),"Site_Acronym",LookUp(colSite,Site_ID = colVault[@Site_ID],Site_Acronym)))

colSupport1 is the collection just with Site_Name and Site_ID.
This solution is working and whether I select all items in the combobox, it can give me a collection with more than 2000 rows too.

Was this reply helpful? Yes No