Hello,
i have a sharepointlist (workers):
id=1, title=Peter
id=2, title=manuel
And then an other sharepointlist (tickets):
id=1, title=case xxx, worker=1
id=2, title=case yyy, worker=2
id=3, title=case zzz, worker=1
Booth are connected as Dataconnection.
In my App, i have an dropdownbox mit peter and manuel (worker.title)
Now i want a gallery, based on worker peter (worker.id=1) if i select him in dropdown box
What i need to insert in onselected for the gallery?!?
Thanks a lot for your help.
Solved! Go to Solution.
Assuming your dropdown has an Items property of : workers
Your Gallery Items property should have the following formula:
Filter(tickets, worker=yourDropdown.Selected.id)
This should give you what you are looking for.
I hope this is helpful for you.
Ok, i found the error - i has in the Sharepointlist Tickets only in workers the Title and not the ID, i select the ID - and now it work. Thanks a lot for your help - you made my Day :).
Assuming your dropdown has an Items property of : workers
Your Gallery Items property should have the following formula:
Filter(tickets, worker=yourDropdown.Selected.id)
This should give you what you are looking for.
I hope this is helpful for you.
Hello Randy,
thanks for your fast help. But i get no results - i think the error is, that i compare the wrong Fields. I think in the Dropdown is Peter and i compare peter with 1, not with the name - cause autocomplete makes worker to worker.title .
Is it possible to see the "raw" data in Sharepointlist (if the field worker has 1 or peter and so on)?
Many Thanks.
Ok, i found the error - i has in the Sharepointlist Tickets only in workers the Title and not the ID, i select the ID - and now it work. Thanks a lot for your help - you made my Day :).
This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.
User | Count |
---|---|
185 | |
53 | |
50 | |
36 | |
35 |
User | Count |
---|---|
273 | |
91 | |
82 | |
76 | |
75 |