I have two lists in SharePoint Online.
Companies and Articles.
There can be numerous Articles about a Company.
In the Articles list there is a Lookup to the Company List value "Title".
I am trying to filter the Articles Gallery by Company.
I created a Combo Box "cbFilterByCompany" with
DefaultSelectedItem = Choices(Articles.CompanyTitle)
And a Label with
Concat(cbFilterByCompany.SelectedItems, "CompanyTitle", ",")
But it just shows the text "CompanyTitle,CompanyTitle,CompanyTitle,CompanyTitle,CompanyTitle"
Also the Combo Box isn't displaying the names of the Companies (and it seems to be trying to show the names of comanies multiple times as there can be multiple articles about the same company)
Solved! Go to Solution.
This! This is still half baked answer but will do for now.
Filter(AddColumns(ProjectThamesRecentDevelopments,"CompNames",Concat(FirmTitle,Value,"##")), Dropdown1.Selected.Title in CompNames)
Remove the quotes on the CompanyTitle.
Concat(cbFilterByCompany.SelectedItems, CompanyTitle, ",")
Do you know how I'd filter the items in the gallery?
Filter(Articles, CompanyTitle.Value in cbFilterByCompany.SelectedItems)
but it says expected a one-column table.
Filter(Articles, CompanyTitle.Value in ShowColumns(cbFilterByCompany.SelectedItems),Title))
Replace Title with the actual name of the column.
Filter(Articles, CompanyTitle.Value in ShowColumns(cbFilterByCompany.SelectedItems,Title))
Try that, I added extra parenthesis earlier.
Keep up to date with current events and community announcements in the Power Apps community.
A great place where you can stay up to date with community calls and interact with the speakers.
Check out the latest Community Blog from the community!