I have an Excel file that has a list of sales account leads. The unique field in the data is the Full Name which is the contact manes at each of the companies. There are multiple entries for a specific Account Name - Company as I have been given multiple lead-contacts per company to reach out to. I love the new "Ideas" in Power Apps where they attempt to help users build querries but It is in it's infancy. Here is what I am trying to do:
Sort(Distinct('Table1', 'FullName'), Result, Ascending) group by AccountName.
I want my results to be grouped and sorted by AccountName and list the Contact names for each account within that account and each would have the usual arrow to go to the details of that unique "FullName" data entry.
The results should look like this:
Santa Cruz Software company (AccountName)
Brian Jones (FullName) >
David Super (FullName) >
Flambeau (AccountName)
Alejandro Rosado (FullName) >
Basil Ledet (FullName) >
Tom Kimble (FullName) >
David Rutzler (FullName) >
Is this even possible with a sort and group query or do these one-to-many relationships need to be separated into separate lists?
I am hoping a query can solve this because this is how we are being given the data...
I have attached the Excel file AccountLeads.xlsx