Hello there,
I'm very new to PowerApps, and would love to get some help on something!
I have a single page app that I have built using the "look-up customer" as a template starting point.
On the left hand side I have a gallery that is showing all of the customers in the database as I would like. When you click on one of them, the right side of the screen is populated with other data within that same table - this all works great!
What I would like to do is display another table underneath the already populated table, that uses the customer name as the linking/relationship. This table is a record that can be linked to a customer, and there is usually one record per customer, sometimes more than one, so this would be a many to one (many records, one customer) relationship. (all data is coming from my dataverse tables)
So in an ideal world - you could search through the customers, click the one you want, and see info from one table like name, date created, customer ID etc (from the customer table) and then a readout of all the records there are in relation to that customer and some details about that record (eg record name, record status, comments about record etc from the records table)
I have a drop down under the customer name from the records table, and it lets me select a customer, but I would like this to be autofilled, and display the data ONLY linking to that customer.
I have tried writing;
RecordsGallery1.Selected.'Customer Name'
but got "Expected Table value. The property on this control expects Table values, The rule produces Text values which are incompatible"
If there is another way to do this please let me know! 🙂 thank you so much!
