dropdowns in galleries to auto select random items from dropdown options

(0) Share

Report

Posted on by ArturDjali10

Hi All

I currently have a process where an excel list is uploaded, to a PowerApps a flow runs which adds all the users into a SharePoint list.

I have another SharePoint list that has all the asset number, Status and role :

Asset Id	Status	Role
0001	Assigned	Grad
0002	Unassigned	Manager
0003	Assigned	Manager

I currently have a form setup for single users, and depending on the role selected and whether the status is available it only returned those assets.

This is on the select asset box of the form: Distinct(Filter('Asset List',Role = Dropdown1.Selected.Result && Status.Value = "Unassigned"),Title)

What I then want to do is bring all the items uploaded into a gallery so that assets can be auto assigned, which would have dropdown in each record and depending on their record and the above formular would automatically select an asset for them.

I believe there is a shuffle function but not had great success so any help is appreciated

Thank you

Categories:

Building Power Apps

I have the same question (0)

All responses (1)

Answers (0)

TheRobRush 11,128 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
If you are in PowerApps, wrap your Gallery Items in

Sort(AddColumns(/* Put your list name here */, "randomizer", Rand()), randomizer,SortOrder.Ascending)

then the top item in the gallery will br random every time and you can just assign it. or can even have the assignment be that formula wrapped in a First() which will just give you a random record every time

Was this reply helpful? Yes No