Ihaveseveraltables,IhavemySQL requestwhichgoesperfectly,Itriedto makethe requestinExcelthenof to bindExceltopowerapps,theproblem is thatactualizationbetweenExcelandthe databasedidn' twork,Ialwayshad sameresultson the app.
ThenItestedwithSQLserver,andIfindthatit'stoomuchcomplicatedto only bind2tablesit'shorriblethenofsimplefunctions asfirst()is not displayed…
ExistthereasoftwareinwhichIcanusemySQL request,whichwill puttheresultin a table formandwhichcouldbecompatible withPowerapp?
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.
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.