Share
ReportI have following list in SharePoint:
| Name | Place | Date | Status | |
| Jane | jane@zzz.com | aaa | 4-Apr | Pending |
| Peter | peter@zzz.com | aaa | 4-Apr | Pending |
| Nick | nick@zzz.com | aaa | 4-Apr | Pending |
| Maggie | maggie@zzz.com | bbb | 8-Apr | Pending |
| Aron | aron@zzz.com | bbb | 8-Apr | Pending |
| Sharon | sharon@zzz.com | bbb | 8-Apr | Pending |
| Cher | cher@zzz.com | ccc | 11-Apr | Pending |
| Mac | mac@zzz.com | ccc | 11-Apr | Pending |
The aim is to use Power Automate to choose 2 records for each date and place (e.g. Place aaa on 4-Apr have 3 records but we have to randomly choose any two). After the choice have been made we will have to update the column Status to "Successful" and have it saved to the Sharepoint list.
I have tried many approaches but cannot seem to wrap my head around the correct approach that integrates all into a coherent solution. The approaches I have tried included:
1. Get random items from SharePoint list or arrays (https://365corner.pl/2021/09/03/get-random-items-with-power-automate/#ItemsSharePoint). This helps to randomly pick an item from an array of objects but I am not sure how to get the grouping by date and place into this in the first place.
2. Create grouping based on date and place (https://johnliu.net/blog/2018/6/do-group-by-in-flow-with-two-simple-elegant-loops). I managed to do this and get the output as separate groups (in html tables).
Now I am lost on how I can proceed further to solve the above issue. I really hope to find help here. Thanks.
All responses (
Answers (
8,649
