Answered

Filtering Unique values

(0) Share

Report

Posted on by Maheshwari

Is there any way to filter unique values from particular column in excel?

I tried this by storing the column in array & using Union Expression in ' select' data operation i have filtered the values.But i need to use those filtered values to get particular row from another excel.

can anyone help on this?

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (2)

Verified answer

efialttes 14,756 on at

Like (0)

Report

Hi!

So your flow has a 'List rows present in a table' action block, right?

If so, did you consider to add a 'Filter array' action block, assign 'List rows present in a table' outputs as its input, then configure condition rule for filter purposes?

Or, did you consider to configure an ODATA expression in 'List rows present in a table' action block 'Filter query' input?

Newbie to Power Automate? THen I recommend the first approach

Hope this helps

Was this reply helpful? Yes No
Verified answer

v-litu-msft on at

Like (0)

Report

Hi @Maheshwari,

So you already get the unique value of the column, and want to get the corresponding value in another Excel file, right?

After you use the union() function to remove repeat value, you could put it into the Apply to each action, then use the expression to get its value: item?['ColumnName'], then put it into the Filter query in the List rows in present a table action:

Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Was this reply helpful? Yes No
Maheshwari 10 on at

Like (0)

Report

Thank you so much for all your prompt response!Would be really useful!

Already tried another way in between, because i need to filter more than five columns from the excel. I stored the list row o/p in array and using Item expression in select option ,got the desired output

Was this reply helpful? Yes No