Unanswered

Move items between two galleries

(0) Share

Report

Posted on by ppl111

Hello.

I have two Dataverse tables and two galleries. These galleries display rows from those tables. The OnSelect property in the first gallery patches another table with data from the selected row. How do I need to filter the first gallery to ensure that it does not display rows that are already in another table.

For example in this screenshot questions 2 and 3 must not be displayed.

Categories:

Building Power Apps

All responses (5)

Answers (0)

Sort by

SpongYe 5,909 Super User 2026 Season 2 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @ppl111

To filter the first gallery to exclude the rows that are already in another table, you can use the NotIn operator in your Filter function. The NotIn operator returns true if a value is not found in a collection or table.

For example, if your first gallery is based on Table1, and your second gallery is based on Table2, and you want to filter out the rows that have the same QuestionID/QuestionTitle in both tables, you can use this formula in the Items property of the first gallery:
Filter( Table1, Not( QuestionID in Table2.QuestionID ) )
This will display only the rows from Table1 that do not have a matching QuestionID in Table2.

If you have any questions or feedback, please let me know. Have a great day! 😊

-----------------------
PowerYsa Power Platform Enthusiast [LinkedIn] | [Youtube]

I love to share my knowledge and learn from others. If you find my posts helpful, please give them a thumbs up 👍 or mark them as a solution ✔️. You can also check out my [@PowerYSA] for some cool solutions and insights. Feel free to connect with me on any of the platforms above. Cheers! 🍻
ppl111 26 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you @SpongYe
But it doesn't show me columns of second table
SpongYe 5,909 Super User 2026 Season 2 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @ppl111

Try this:
With( {_QuestionsTable : Questions }, Filter( QuestionnaireItems, Not( QuestionID in _QuestionsTable.QuestionID ) ) )
I assume both tables are Sharepoint Lists?
ppl111 26 on at

Like
a
(0)

Report
Copy link

Link copied!

Same problem. It is two dataverse tables
SpongYe 5,909 Super User 2026 Season 2 on at

Like
a
(0)

Report
Copy link

Link copied!
Your formula should be:
With( {_QuestionsTable : Questions }, Filter( QuestionnaireItems, !(QuestionID in _QuestionsTable.QuestionID) ) )

If you have any questions or feedback, please let me know. Have a great day! 😊

-----------------------
PowerYsa Power Platform Enthusiast [LinkedIn] | [Youtube]

I love to share my knowledge and learn from others. If you find my posts helpful, please give them a thumbs up 👍 or mark them as a solution ✔️. You can also check out my [@PowerYSA] for some cool solutions and insights. Feel free to connect with me on any of the platforms above. Cheers! 🍻