Power Platform Community Forum Thread Details

Agent_Name	Case_Number	Case_Type
Ash	10001	Support
Ash	1111	Billing
Ash	22222	Technical
Ash	10002	Support
Ash	11899	Billing
Ash	22333	Technical
Ash	22565655	Technical
Paul	10989898	Support
Paul	1000345	Support
Paul	2200909	Technical
Paul	550909	Order
Paul	55676767	Order
Nikki	551111	Order
Nikki	5552222	Order
Nikki	5556868	Order
Nikki	55454545	Order

This is a sample data (CSV file) that I generate from Salesforce and upload in a SharePoint once in a week. The data shows agent name and the cases that they have worked on. I want to develop a Power Automate solution that will extract one case type per one agent, in a random manner. If an agent has only one Case Type associated, then i need to extract only one sample. The randomly extracted data then needs to be added to a different SharePoint site as List items. The extracted data should have agent name, case number and the case type. From the sheet, my desired output will be as below (should be randomly generated)--