Announcements
I'm developing a Power Apps application connected to a SharePoint list called ‘PROYECTOS’. This list has a column named SUB_PROYECTOS, which is a Choice column with multiple selections enabled, and the available options are:
SUB_PROYECTOS
SubProyecto01
SubProyecto02
SubProyecto03
SubProyecto04
There is also another column called NOM_PROYECTO that stores the name of the project.
NOM_PROYECTO
I have a dropdown control (Dropdown1) that lets the user select a project. Below that, I have a gallery where I want to display the selected subprojects (multi-choice values) corresponding to the selected project.
Dropdown1
I tried using ThisItem.SUB_PROYECTOS inside the gallery, but it throws an error, since the column returns an array (a table of records).
ThisItem.SUB_PROYECTOS
What would be the best way to filter and display the individual values of a multi-select Choice column in a gallery, based on the project selected in the dropdown?
Thanks in advance for your help!
First( Filter( PROYECTOS, NOM_PROYECTO= Dropdown1.Selected.Value ) ).SUB_PROYECTOS
Enjoy Power Platform and have a great day 🚀 | My LinkedIn
If the answer helps, please consider 👍, Thanks.
Hi @stampcoin
First of all, thank you very much for your clear and helpful response — it worked perfectly for my scenario! 🙌
I’d like to kindly ask a follow-up question based on your example using the SharePoint list PROYECTOS. In addition to the SUB_PROYECTOS column (which is of type Choice and allows multiple selections), my list also includes the following columns:
PROYECTOS
PROYECTO01_DETAILS, PROYECTO02_DETAILS, PROYECTO03_DETAILS, PROYECTO04_DETAILS (text type)
PROYECTO01_DETAILS
PROYECTO02_DETAILS
PROYECTO03_DETAILS
PROYECTO04_DETAILS
PROYECTO01_ADVANCE, PROYECTO02_ADVANCE, PROYECTO03_ADVANCE, PROYECTO04_ADVANCE (number type or percentage)
PROYECTO01_ADVANCE
PROYECTO02_ADVANCE
PROYECTO03_ADVANCE
PROYECTO04_ADVANCE
Gallery1
Basically, I’d like to display two more Labels under each "Project" header inside the gallery, retrieving values from the other columns of the same selected project.
Would this kind of layout be achievable within a single gallery or would you recommend using a nested container or another layout strategy?
Thanks again for your valuable time and support!
Best regards, Alex | My LinkedIn
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our 2026 Super Users!
Congratulations to our 2025 community superstars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
11manish 530
WarrenBelz 459 Most Valuable Professional
Haque 314