Hello everyone,
I am using a Gallery and a Data Table to display information from an Excel source.
For my Gallery, I am using the following:
This displays me all entries from the column "Assigned to" while deleting all duplicates, which is perfect.
For my Data Table, I use:
Where I take a certain column, I want to display. This then gives me all entries from the specific column, which is connected to the "Assigned to" column.
The result is, that I select "Assinged to" from the Gallery list on the left and get all assets, which are connected to this user ('Assigned to = User name).
Now I want to populate a form with ALL the data from the "Assigned to", not only one column. For that, I create a form, add all fields and use Gallery.Selected but it is not working because of the Distinct method I used. When I remove the Distinct I can populate the form with all the information from the selected user. Any idea how I can solve this or what other method I should use? I am kinda lost.
Thanks in advance!
