Answered

Find duplicates in an Excel file and update a column in Sharepoint

(0) Share

Report

Posted on by SuperPowerUser1

Hi there,

I have built a flow where When an item is created the flow check for duplicates in the Sharepoint list and updates the created item as duplicate.

Now i want to add additional steps to the flow where i also check for duplicates in an Excel file based on 2 columns.

I've built the steps in the flow but the problem i have is that the Filter array output after List rows present in a table is empty even though i get the results in the output of the List rows present in a table.

I have attached the screenshot of the flow.

Basically in List rows present in a table i use Odata filter with 1 column and then in Filter array action i filter by the second column.

Thank you for your help!

Categories:

Building flows

image001.png

I have the same question (0)

All responses (3)

Answers (0)

v-qiaqi@microsoft.com on at

Like (0)

Report

Hi @SuperPowerUser1,

Show me how you configure the Filter array.

Actually, the most simplest thing is to add the condition directly, you don't need to configure the filter array, check the condition, if yes, update item.

Was this reply helpful? Yes No
SuperPowerUser1 21 on at

Like (0)

Report

Hi @v-qiaqi-msft
I am attaching a screenshot of the Filter array action.
When you say that it is more simple to add the condition directly do you mean to add the condition directly in Odata filter inside List rows action?

Screenshot 2024-0...

Was this reply helpful? Yes No
v-qiaqi@microsoft.com on at

Like (0)

Report

Hi @SuperPowerUser1,

The way you show the filter array could not make it clear that why it does not work, it seems that the way you configure in Filter arrary is correct, even though I am not sure the data type of both.

I mean add a condition and compare the SP list with Exce item directly.

Was this reply helpful? Yes No