Showing results for 
Search instead for 
Did you mean: 
New Member

Database and powerapps.

Hello everyone, (I am French excuse me forthe English faults)

I need assistance, today I don't know how to do to make a app with database.

I have several tables, I have my SQL request which goes perfectly, I tried to make the request in Excel then of
to bind Excel to powerapps, the problem is that actualization between Excel and the database didn' t work, I always had
same results on the app.

Then I tested with SQL server, and I find that it's too much complicated to only bind 2 tables it's horrible then of simple functions
as first () is not displayed


Exist there a software in which I can use my SQL request, which will put the result in a table form and which could be compatible with Powerapp?

else, which alternatives advise me?

By thanking you for reading my post.

Quentin. :)

Community Support
Community Support

Hi @Quentin,


I'm afraid that I didn't fully understanding what you are trying to do. What do you need the 2 tables to do? If you want to add record to a SQL database, then you just need to create the app with SQL connection from New > SQL Server in PowerApps. Then you will be able to add new record in this app and also submit data to the table.




Community Support Team _ Mona Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

hi @v-monli-msft,


i have a data base where there are all details of my company and i would like to find a software who can do a SQL query, take the result and put it in powerapps. I need to join 2 tables to have the goud result. 🙂


example : 

city      | gains         | lost

Paris   | 2M$           | 150k$


i tried with excel but it didn't work very well, and i don't know how i can join 2 tables with a SQL server connection, i read the documentation... but i found nothing for this case or it seems to be too difficult or i didn't understand.


So i need in the Gallery1 to display the example. (city -> table 1 & gains/lost -> table 2).

Like city in the label1, gains of the city in a label2 and lost of the city in the label3.


Thank's 🙂

UP ! plz 😞

Helpful resources

Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (3,479)