Output of Filter Array suddenly become no output

[Liyana05]

I created a flow involving SharePoint and Excel.

I have been using the flow for few months but suddenly last friday, the output of Filter array become no output.

It seems like the filter array unable to filter the data from the excel.

So , I m not sure where is the actual problem as it has been working fine until last friday .

When the ID is filtered using filter array , it will find the ID in the excel.

Then, it will either create a new row or update a row if the ID is already there.

But now, it keeps creating new row in excel because the output of filter array is empty. As if there were no existing data in the excel.

Before last friday , successfully filtered.

now, the output become like that .

The flow :

[v-yetonggu-msft]

Hi @Liyana05 ,

Make sure the ID type on both sides is the same, you can nested the string function outside the dynamic content ID.

string(item()?['ID'])

Best Regards,

Sunshine Gu

[Liyana05]

Thank you for your advise.

I did tried as per advised but still the filter array unable to filter the existed value from the excel.

Do you have any idea why suddenly the filter array is not functioning?

[v-yetonggu-msft]

Hi @Liyana05 ,

I don't think the problem is on the Filter Array control. Has your table modified after Friday?

Best Regards,

Sunshine Gu

[Liyana05]

@v-yetonggu-msft 

is it the Excel table? 
It has not been modified.

For the file of the flow, last modification is around 1 month ago because I created the copy of the file.

For the flow itself , last modification maybe around 2-3 months

But now,  the flow run successfully.

It is just that suddenly it cannot update a row in excel as the filter array cannot detect existed ID.

What could be the problem from your opinion?

Is there any other way I can check what is the actual problem ? 

[v-yetonggu-msft]

Hi @Liyana05 ，

Can you provide information in this?

Best Regards,

Sunshine Gu

[Liyana05]

@v-yetonggu-msft 

sure but i just need to cover some details
but it just repeating the information for each row existed in the excel

The red words are the title of each column in the table (excel)

[v-yetonggu-msft]

Hi @Liyana05 ,

Can your String formula be launched for me?

Best Regards,

Sunshine Gu

[Liyana05]

sure . 

string(triggerOutputs()?['body/ID'])

I checked again today, but the issue still remained 

[v-yetonggu-msft]

Hi @Liyana05 ,

Did you manually add the ID column in the SP list yourself?

The My ID column comes with the list.

Best Regards,

Sunshine Gu

[Liyana05]

@v-yetonggu-msft 
No, I didn`t add manually . I just tick from the column list.

Its automatically created by the list .

I use the ID column in my flow so that it can be easily filtered and only 1 ID for 1 item will be created

[v-yetonggu-msft · Accepted solution]

Hi @Liyana05 ,

Add a condition to the Filter Query of the 'List rows present in a table' control.

And delete the 'Filter_array' control.

empty(outputs('List_rows_present_in_a_table')?['body/value'])

Best Regards,

Sunshine Gu

[Liyana05]

@v-yetonggu-msft  
Thank you very much ! 
The problem solved.

I just need to monitor for a few days.

What could be the problem ? because the filter array works fine before this issue.

[v-yetonggu-msft]

Hi @Liyana05 ,

Due to the limitations of the "List rows present in table" control, by default it can only fetch 256 records at a time.

There are probably more than 256 pieces of data in your table. The control cannot obtain records after 256.

If you add ID eq string(triggeroutputs()?['body/ID']) to the control, you will get one record you need.

Best Regards,

Sunshine Gu

[Liyana05]

@v-yetonggu-msft 

Understood.
Thank you so much for your explanation.