Unanswered

Random employee audit

(0) Share

Report

Posted on by CU20121617-0

I'm trying to build a random associate audit, and I'm having trouble with the logic. All the data is stored in sharepoint lists and I have an associate table (basic ID, name and Last_Audit_Date) / manager table (mostly helps with having a distinct list of managers (plus permissions)).

At the click of a button, I want to generate an audit for a random associate for each manager. I planned to "ForAll(managers, collect first associate with the oldest audit date (pulling nulls first)" but it seems I can't nest a clearcollect in a ForAll, and I'm not sure how to proceed.

Every manager has a different amount of associates so can't hard code any numbers. Once I have the random associate, I plan on patching to the audit table to track audit history.

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (0)

TheRobRush 11,128 Moderator on at

Like (0)

Report
Copy link

Link copied!
You could achieve a random order in several ways, here is one of them.

///Initiate ClearCollect ClearCollect( ///CollectionName RandomList, ///Sort This Data Sort( ///Check ALl applicable Data ForAll( ///Source is SPList TROSTER TMROSTER, { ////Columns we wil haae in our new collection Identifier:ID, EmployeeName:Title, RandomSelf:Rand() } ), ////Column to Sort by RandomSelf, ///Order to sort in Ascending))

You could even further break this down with other checks and modifiers etc

Was this reply helpful? Yes No
TheRobRush 11,128 Moderator on at

Like (0)

Report
Copy link

Link copied!

The random employee would just be the First(RandomList).EmployeeName forgot to clarify. but will be different and random every time

Was this reply helpful? Yes No
timl 36,713 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!
@Damiancds

The Shuffle function provides a really easy way to retrieve a random record.

https://docs.microsoft.com/en-gb/powerapps/maker/canvas-apps/functions/function-shuffle
Therefore, you can call the AddColumns function on your manager list to include a column that contains a random associate record.

AddColumns(ManagerList, "RandomAssociateRecord", First(Shuffle( Filter(AssociateList, ManagerID=ManagerList[@ManagerID] ) ) )

Was this reply helpful? Yes No
CU20121617-0 6 on at

Like (0)

Report
Copy link

Link copied!
I apologize for not coming back sooner. I was able to implement the solution from @timl, and it appears to work, but I am running into some weird issues.

This is my current code:
ClearCollect(AssociateAudit,AddColumns('2920_Manager_List',"Associate",First(Shuffle(Filter('2920_Associate_List',Status ="Active" && Supervisor = '2920_Manager_List'[@Supervisor])))));
when I look at the collection in a gallery, I have to access the associate by using
ThisItem.Associate.Associate
And when I throw the collection in a data table, it shows the associate as [object Object].

Am I joining these incorrectly? I would assume that I should be able to say ThisItem.Associate and have it be the text column and not treat it like an object/record?

Was this reply helpful? Yes No