cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Anonymous
Not applicable

Is it possible to add multiple SQL tables to a gallery?

Hello,

 

I am new to using SQL as a connection to PowerApps.  I was wondering if it is possible to have a gallery that contains more than one SQL table?  I know the gallery only allows you to connect to one data source, so if it is possible, how would I go about this?

 

Thanks!

2 REPLIES 2
Highlighted
Super User
Super User

Re: Is it possible to add multiple SQL tables to a gallery?

You can't directly add to SQL tables to gallery. You could create a collection, add both tables to that collection then use that collection with your gallery.



--------------------------------------------------------------------------------
If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.
Highlighted
Advocate III
Advocate III

Re: Is it possible to add multiple SQL tables to a gallery?

Powerapps supports database views now, could you create a view that combines the two tables e.g. In your DB

CREATE VIEW v_combinedTable AS
SELECT Column1, column2, Column3
FROM Table1
UNION ALL
SELECT Column1, column2, Column3
FROM Table2

And then call this view as a data source in powerapps?


Helpful resources

Announcements
secondImage

Demo-Extravaganza 2020

Check out these cool Power Apps & vote on your favorite!

secondImage

Robotic Process Automation

Let's talk about the solution provided by Microsoft for Robotic Process Automation (RPA)

secondImage

Community Highlights

Check out whats happening in Power Apps

secondImage

Community User Group Member Badges

FIll out a quick form to claim your community user group member badge today!

Top Solution Authors
Top Kudoed Authors
Users online (9,806)