How can I avoid power automate from reading duplicate values in my excel spreadsheet?

(0) Share

Report

Posted on by alopez222

158

I am trying to have power automate read some values from an excel spreadsheet. There are some duplicates values and I am trying to prevent power automate from reading those values because it seems that errors occur when reading those duplicate values. There is a select query under advanced options but I am unsure how to use it so that I only non-duplicate values are read.

All responses (1)

Answers (1)

Verified answer

v-bofeng-msft on at

Like (1)

Report
Re: How can I avoid power automate from reading duplicate values in my excel spreadsheet?

Hi @alopez222 :

Don't you need to get duplicate rows in the table? If so, I'm afraid that the advanced options of 'List rows present in a table' do not provide such an option. However you could try the 'Union' function to achieve it.

I've made a test for your reference:

1\My table:

2\My flow

expression:

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

The Result(Duplicates have been filtered out):

Best Regards,

Bof