Announcements
Hello !I have 2 table(Table A & Table B) with many-to-many relationship then i created a junction table that connect those table , in my powerapps i connect with data source from table A , and i have a combobox and i want to display column from Table B. how do i do that ?
@lunalovegood to display the data in the Combo box plz try this formula in item property:
Filter(TableB, LookUp(JunctionTable, TableAID = SelectedItem.ID).TableBID = ID)
If this is the answer for your question, please mark the post as Solved.If this answer helps you in any way, please give it a like.
Thanks!
when i try to add other table name , it says that the table isnt recognized
@gcmfaizan
Filter('Action Party', LookUp(LessonLearned_ActionParty, LessonLearned.ID = SelectedItem.ID).ActionParty_ID = ID)
when i enter this column, it says that the SelectedItem isnt recognized
@lunalovegood that is an example, you have to replace datasource name and column name as per your schema.
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 community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
WarrenBelz 364 Most Valuable Professional
11manish 186
MS.Ragavendar 105 Super User 2026 Season 1
