Shuffle collection based on date

(0) Share

Report

Posted on by BianceBee

102

Hi there

I am creating a app that a department admin just clicks on a button to select a winner based on.

I want to be able to sort these by month but also if there was noone tagged for that month it looks at the previous month for the winner.

At the moment i have a collection called "ShuffledNames" (datasource sharepoint list) which will have the email of the tagged user and comments showing. On the button i put in the below command on the "onselect" property. The shuffle works but i want to be able to get data for the current month and if no data for that month then look at previous month. I have tried to sortbycolumns, using "Messages" column which has the dates of when the posts were posted but no luck. Any suggestions please?

ClearCollect(
ShuffledNames,
Shuffle('Appreciation - National Operations'),SortByColumns('Appreciation - National Operations',"Messages",SortOrder.Ascending)
)

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Verified answer

v-bofeng-msft Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @BianceBee ,

Please try:

ClearCollect( ShuffledNames, If( IsBlank(LookUp(DataSource,DatTimeColumn>=Date(Year(Today()),Month(Today()),1))), Filter(DataSource,DatTimeColumn>=DateAdd(Date(Year(Today()),Month(Today()),1),-1,TimeUnit.Months)), Filter(DataSource,DatTimeColumn>=Date(Year(Today()),Month(Today()),1)) ))

Best Regards,
Bof

Was this reply helpful? Yes No
BianceBee 102 on at

Like
a
(0)

Report
Copy link

Link copied!

thanks for this @v-bofeng-msft

it worked. I just added the shuffle option so it shuffles. Thank you for this 🙂

Was this reply helpful? Yes No