web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps ADD COLUMNS FILTERED G...

Power Apps

Answered

ADD COLUMNS FILTERED GALLERY

(0) Share

Report

Report

Posted on by SENDAN

65

I have a gallery with several functions for filtering. To add an extra search function related to a second data source, I attempted to add a new column to my gallery's data source that consolidates my results. Both data sources share a common column, 'container.' However, it's not working as expected. I suspect the issue lies in the placement of my 'AddColumns' formula, as my gallery ends up blank. There will also be multiple results From my second DataSource. That's why I added the Concat function.

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (1)

Verified answer

v-qiaqi@microsoft.com Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @SENDAN,

First of all, if you want to filter records based on the common column CONTAINER, you should use the following formula:

Filter(list1, CONTAINER in list2.CONTAINER)

This will help you display the sharing records based on the same container in both lists.

Was this reply helpful? Yes No

Join the conversation