cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
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. :)

3 REPLIES 3
Highlighted
Community Support
Community Support

Re: Database and powerapps.

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.

 

Regards,

Mona

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.
Highlighted
New Member

Re: Database and powerapps.

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 🙂

Highlighted
New Member

Re: Database and powerapps.

UP ! plz 😞

Helpful resources

Announcements
August 2020 Community Challenge: Can You Solve These?

August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

secondImage

Return to Workplace

Reopen responsibly, monitor intelligently, and protect continuously with solutions for a safer work environment.

secondImage

Super Users Coming in August

We are excited for the next Super User season.

secondImage

Community User Group Member Badges

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

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors
Users online (8,232)