How to Combine Duplicate Flow Names and List Their Connectors in WPS Power Query
Question details
The user needs to consolidate a Power Automate export that repeats a flow name for each connector, grouping rows by flow name and listing all associated connectors in a single summary row.
- Product
- WPS Office Spreadsheets - Power Query
- Device & OS
- not provided
- Scenario
- Working with a Power Automate export in WPS Spreadsheets where each flow appears multiple times because it uses several connectors.
- Observed behavior
- Duplicate flow names create one row per connector; the goal is to condense them into one row with a comma-separated connector list.
Open the Power Automate export in WPS Spreadsheets and confirm that the flow name and connector information are in separate columns. If the required values are combined in one column, split them before starting the Power Query grouping.
Group duplicate flow names and combine connector values in Power Query
Use this method when a Power Automate export has multiple rows for the same flow and you need one summary row per flow with all connectors listed.
Power Query groups rows by a key column and lets you aggregate the remaining columns. To combine text values into a single cell, use an All Rows group operation and then add a custom column that extracts and joins the distinct connector names.
In WPS Spreadsheets, click any cell inside the export table, then go to the Data tab and click From Table/Range to load the data into Power Query.
In the Power Query Editor, click the column that contains the flow names so it can be used as the grouping key.
Go to the Transform tab and click Group By. Choose the flow name column as the group key and enter a new column name such as AllData.
Click Add Column > Custom Column and enter a formula like =Text.Combine(List.Distinct([AllData][Connector]), ", "). Replace Connector with the exact connector column name from the export.
Delete the helper table column if it is not needed, then click Home > Close & Load to return the grouped summary to WPS Spreadsheets.
Consolidate Power Automate flow rows with WPS Spreadsheets Power Query
WPS Spreadsheets includes Power Query tools that let you group duplicate flow names, combine connector values into one cell, and load the summary back to Excel without switching applications.
- 1. Open your export table in WPS Spreadsheets: Open the Power Automate export file in WPS Spreadsheets and click a cell inside the data range.
- 2. Launch Power Query: Go to Data > From Table/Range to load the export table into the Power Query Editor.
- 3. Group by flow name: Select the flow name column, go to Transform > Group By, and create an All Rows group.
- 4. Combine distinct connectors: Click Add Column > Custom Column and enter =Text.Combine(List.Distinct([AllData][Connector]), ", ") to create a comma-separated connector list.
- 5. Load the grouped result: Click Home > Close & Load to place the consolidated summary in a new worksheet.
Frequently Asked Questions
How do I start Power Query in WPS Office for an Excel export?
Open the export in WPS Spreadsheets, click a cell in the table, then go to Data > From Table/Range. If the source is a CSV file, use Data > From Text/CSV to load it into Power Query first.
What if my flow name and connector are stored in the same column?
Split the column before grouping. In Power Query, select the column, go to Transform > Split Column, choose the delimiter used in your export, and rename the resulting columns to Flow Name and Connector.
Can I remove duplicate connector values during the combine step?
Yes. In the custom column formula, use Text.Combine(List.Distinct([AllData][Connector]), ", "). List.Distinct removes repeated connector names for the same flow before joining the values.
Will the grouped summary refresh when I update the source table or CSV?
Yes. If the data was loaded as a Power Query connection, go to Data > Refresh All or right-click the query in the Queries & Connections pane and choose Refresh to update the grouped summary.
