Shuffle but do not repeat the same names etc

(0) Share

Report

Posted on by BianceBee

102

Hi there

I have an app where it gets data from a sharepoint list and shuffles between the data. Below is the current formula used to shuffle the data for the first month then go to previous months. Issue is, that it is showing the same name multiple times for that month. I want to be able to shuffle through the first month and not have the same data show up and then moves onto the previous month.

For example names are sam, susan, grace, daphe, ava, when i press shuffle i want to only see their names once during the shuffle for that month and then go to previous months if no data for current month.

ClearCollect(ShuffledNames,Shuffle(If(IsBlank(LookUp('Appreciation - National Operations','Date of mention'>=Date(Year(Today()),Month(Today()),1))),Filter('Appreciation - National Operations','Date of mention'>=DateAdd(Date(Year(Today()),Month(Today()),1),-1,TimeUnit.Months)),Filter('Appreciation - National Operations','Date of mention'>=Date(Year(Today()),Month(Today()),1)))))

Categories:

Building Power Apps

All responses (4)

Answers (0)

Sort by

v-xiaochen-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @BianceBee ,

Please try to use distinct function.

https://learn.microsoft.com/en-us/power-platform/power-fx/reference/function-distinct#example

Best Regards,

Wearsky
BianceBee 102 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @v-xiaochen-msft

thanks but how will that work with the shuffle function? I want to shuffle the current months without repeating the names and then move to the previous months if there is no data for current month. The shuffling from current to previous is working but its repeating data from current month.
v-xiaochen-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @BianceBee ,

Try this

ClearCollect(ShuffledNames,Distinct( Shuffle(If(IsBlank(LookUp('Appreciation - National Operations','Date of mention'>=Date(Year(Today()),Month(Today()),1))),Filter('Appreciation - National Operations','Date of mention'>=DateAdd(Date(Year(Today()),Month(Today()),1),-1,TimeUnit.Months)),Filter('Appreciation - National Operations','Date of mention'>=Date(Year(Today()),Month(Today()),1)))) ,<Column Name>) )

Best Regards,

Wearsky
BianceBee 102 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @v-xiaochen-msft
I have tried this and had no luck. No data is appearing in the gallery. I tried different columns but still, no data appeared in the gallery. The gallery comes up blank with no errors. Below is the data that is suppose to appear up in the gallery