Unanswered

Copilot Excel and Power Automate

(1) Share

Report

Posted on by David Granados

Hello. I have an excel file and I want to create a flow in Power Automate that get data of an specific row removing duplicates and all the values that all the data of that row I want to retorn to Copilot Studio. how can I do that? I am trying with different ways.

Categories:

General topics

I have the same question (0)

All responses (2)

Answers (0)

AllanMouraDev 142 Super User 2025 Season 2 on at

Like (0)

Report
To achieve this in Power Automate, follow these steps:

1️⃣ Read the Excel File

Use the "List rows present in a table" action from Excel Online (Business).

Select the File and Table where the data is stored.

If needed, apply an OData filter to get only the specific row.

2️⃣ Select the Desired Row

Add a "Filter array" action.

In From, select the value from the previous step.

Set the filter condition to get the specific row you need (e.g., ID equals a specific value).

3️⃣ Remove Duplicates

Power Automate does not have a built-in "Remove Duplicates" function, so we need to use an Array Union Trick:

Use the "Select" action to format the row data.

Use a "Compose" action with the following expression to remove duplicates:

union(body('Select'), body('Select'))

This removes duplicate values because union() merges arrays and automatically removes duplicates.

4️⃣ Remove Blank Values

Use another "Filter array" action.

In From, select the output of the previous "Compose" step.

Set the condition to remove blank values:

Field: item()

Operator: is not equal to

Value: '' (empty string)

5️⃣ Return Data to Copilot Studio

Use a "Join" action to convert the filtered array into a single string:

From: The output from the "Filter array" step.

Separator: , (or any separator you prefer).

Finally, use the "Return value(s) to Power Virtual Agents" action (if using Copilot Studio as a bot backend).

Set the response to the joined string.

Final Output

Your Copilot Studio will receive a clean, unique, and formatted row data without duplicates or blank values.

Hope it helps!!

Was this reply helpful? Yes No
David Granados 2 on at

Like (0)

Report

I have 1 question, the Row that I want to select is BU, Selecting BU is the correct way?

Was this reply helpful? Yes No