Forum Discussion
Solved
How to merge and count same cells
Hi All. i have export from Power Automate with a list of all my flows and confections, the thing is that if a flow A uses two connectors OneDrive and SharePoint, the list countians two rows for flow A for every connector used.
Here are some examples:
| HNICE: Coverages Update SP | Office 365 Outlook |
| HNICE: Coverages Update SP | SharePoint |
| HNICE: Coverages Update SP | SQL Server |
| CorriganSP: Insert Zywave employees | SharePoint |
| CorriganSP: Insert Zywave employees | SQL Server |
| Office 365 Outlook | |
| SharePoint | |
| Sadoff: Accident SP to SQL Update | SharePoint |
| Sadoff: Accident SP to SQL Update | SQL Server |
| Sadoff: Accident SP to SQL Update | SQL Server |
| Producer Commission Reports : update MI Report | Office 365 Outlook |
| Producer Commission Reports : update MI Report | SharePoint |
| Brecht Sharepoint: Update probationary driver to active | SharePoint |
| Brecht Sharepoint: Update probationary driver to active | SQL Server |
| Great West Sharepoint Coverage Update | SharePoint |
| Great West Sharepoint Coverage Update | SQL Server |
| prospect reports | SharePoint |
| prospect reports | SQL Server |
| ICCExpress: Move Billing to sharepoint | Office 365 Outlook |
| ICCExpress: Move Billing to sharepoint | SharePoint |
I want to summarize this by showing the Flow name (first column on the left) only once, but the user reading this file to see how which connectors is using? how is this achievable, any ideas?
An alternative could be Power Query. In the attached file you can add data to the blue dynamic table. Then you can click in any cell of the green table and right-click with the mouse and select refresh to update the green result table.
The data layout in the screenshot and in the attached file is for illustration. You can place the green result table to the right of the blue table or in another worksheet.
An alternative could be Power Query. In the attached file you can add data to the blue dynamic table. Then you can click in any cell of the green table and right-click with the mouse and select refresh to update the green result table.
The data layout in the screenshot and in the attached file is for illustration. You can place the green result table to the right of the blue table or in another worksheet.- That looks great, exactly how i thought should look like, to summarize and separate every connector for a flow in a comma delimiter, that i was i reduce the rows to half and have this high-level overview of Top connectors being used. Thank you for the solution, i will inspect the Query to see the logic behind and definitely re-use it in other examples like this one.
