Hi,
I am new to Power Automate. Please help me in building flows using power automate. I need to remove rows 1-3, retain row 4 (Agent Name/ACD Calls etc.) and remove row with TOTALS/953 etc. Row with Agent name will be my header. I am receiving same pattern in a daily basis. I can't find any videos or research on how to remove rows with a specific range. This flow will be used in Power BI once cleaned. Please help. Thank you.
Agent Group: IT Service Desk
Date: 8/1/2023
Time Zone: default
Agent Name ACD Calls Avg ACD Time Avg ACW Time % Agent Occupancy w/ ACW % Agent Occupancy w/o ACW Extn In Calls Avg Extn In Time Extn Out Calls Avg Extn Out Time ACD Time ACW Time Agent Ring Time Other Time AUX Time Avail Time Staffed Time
Totals 953 5:46 :04 92 91 2 7:56 220 2:29 91:42:30 :57:42 :04:53 7:22:47 301:27:10 9:03:08 410:38:10
SD Davao Ronald 29 4:51 :00 98 98 0 1 :17 2:20:33 :00:00 :00:00 :17:43 6:16:20 :03:01 8:57:37
SD Leads Alden 0 0 3 2:02 :00:00 :00:00 :00:00 :00:00 :34:45 :00:00 :34:45
SD Cebu2 Clarie 0 0 22 1:51 :00:00 :00:00 :00:00 :00:00 9:16:57 :00:00 9:16:57
SD Cebu1 Jordan 0 0 0 :00:00 :00:00 :00:00 :00:00 :00:20 :00:00 :00:20
SD Cebu2 Ryan 0 0 2 4:12 :00:00 :00:00 :00:00 :00:00 9:11:11 :00:00 9:11:11
