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:

Business Process Flows

All responses (14)

Answers (1)

Liyana05 18 on at

Like (0)

Report

Re: Output of Filter Array suddenly become no output

@v-yetonggu-msft

Understood.
Thank you so much for your explanation.
v-yetonggu-msft on at

Like (1)

Report

Re: Output of Filter Array suddenly become no output

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 18 on at

Like (0)

Report

Re: Output of Filter Array suddenly become no output

@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.
Verified answer

v-yetonggu-msft on at

Like (0)

Report
Re: Output of Filter Array suddenly become no output

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 18 on at

Like (0)

Report

Re: Output of Filter Array suddenly become no output

@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 on at

Like (0)

Report

Re: Output of Filter Array suddenly become no output

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 18 on at

Like (0)

Report

Re: Output of Filter Array suddenly become no output

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

I checked again today, but the issue still remained
v-yetonggu-msft on at

Like (0)

Report

Re: Output of Filter Array suddenly become no output

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

Like (0)

Report

Re: Output of Filter Array suddenly become no output

@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 on at

Like (0)

Report

Re: Output of Filter Array suddenly become no output

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