Output of Filter Array suddenly become no output

(0) Share

Report

Posted on by 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 :

Categories:

Using flows

I have the same question (0)

All responses (14)

Answers (1)

v-yetonggu-msft on at

Like (1)

Report
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

Was this reply helpful? Yes No
Liyana05 18 on at

Like (0)

Report

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?

Was this reply helpful? Yes No
v-yetonggu-msft on at

Like (0)

Report

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

Best Regards,
Sunshine Gu

Was this reply helpful? Yes No
Liyana05 18 on at

Like (0)

Report

@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 ?

Was this reply helpful? Yes No
v-yetonggu-msft on at

Like (0)

Report

Hi @Liyana05 ，
Can you provide information in this?
Best Regards,
Sunshine Gu

Was this reply helpful? Yes No
Liyana05 18 on at

Like (0)

Report

@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)

Was this reply helpful? Yes No
v-yetonggu-msft on at

Like (0)

Report

Hi @Liyana05 ,
Can your String formula be launched for me?
Best Regards,
Sunshine Gu

Was this reply helpful? Yes No
Liyana05 18 on at

Like (0)

Report

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

I checked again today, but the issue still remained

Was this reply helpful? Yes No
v-yetonggu-msft on at

Like (0)

Report

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

Was this reply helpful? Yes No
Liyana05 18 on at

Like (0)

Report

@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

Was this reply helpful? Yes No