New to power Apps and I have managed to create simple apps connected to a MYSQL single table, but now im trying to get a bit more advanced.
I have 2 tables (below) one table has a Unique ID which is the PERSID and the other table is a list of bookings. There may be lots of occurances with the same PERSID in the second table.
I'm trying to create a simple app with below in a browse gallery. When I click on the person i get a detailed form with the persons name and the bookings they have had.
I'm sure this is simple but struggling. If someone can point me in the direction of the best formulas to use to achive this.
If the persons names and the bookings are not in the same SQL table, then I'm afraid that you need to have 2 data sources in this app and you cannot have both data sources shown in one DisplayForm. You might need to do this with 2 display forms.
2 Data sources is fine.
Have managed to get both into the App need a way of building the join between the 2 tables on the PERSID.
and for the reservation form to just show the data of the person i have selected.
Check out our new profile badges recognizing authored solutions!
We are excited to announce the Power Apps Super Users!
Did you miss the call? Check out the Power Apps Community Call here.
Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!