Announcements
Hello Community,
How can i join two tables in power apps. I want to use two joined tables as a data source for Gallery.
What would the code look like?
thanks
@Alice87
Have a look at this post: Solved: Syntax for joining tables - Power Platform Community (microsoft.com)
Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.
...
In addition to the suggestions above, I would also consider the data source that you're using.
If it's a SQL data source, the best approach would be to create a view in SQL. This would be the most performance way, and it would help mitigate any potential delegation issues that you may encounter.
@timl @mdevaney
Datasource is SQL Server.
what would that look like with View?
@Alice87 I cannot answer the question for Tim. My idea is above with code...
You would need to create a view in SQL upfront and then use this view in powerapps instead of a table. Keep in mind that you can't make any modifications against a view!
Hi @Alice87
Here are some similar related posts where I've given some examples of how to create a view that joins 2 tables. That should give you the gist of what you need to. If you need more help, you can post some additional details about the schema of your tables and we can advise further.
https://powerusers.microsoft.com/t5/Building-Power-Apps/Using-quot-in-quot-operator-in-Filter-function-for-binding-drop/m-p/114542
https://powerusers.microsoft.com/t5/Building-Power-Apps/Chart-Item-Syntax/m-p/384032
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.
11manish 395 Super User 2026 Season 2
Mohsin Ali 328
WarrenBelz 260 Most Valuable Professional
