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 a 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.
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.
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. 🙂
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.
Fill out a quick form to claim your user group badge now!
Find out where you can attend!
Features releasing from October 2019 through March 2020
Learn how to build the business apps that you need.