Returning Wrong Count Number

Question

I have a simple flow in which,

count number of items are updated in excel file from a sharepoint list name(procurement).

for example : in sharepoint there are 10 items and when flow trigger in excel column '10' shows

in this im using filter query [RequisiteType eq'Service'] RequisiteType=column name in sharepoint list,

it should update number as 9 but its updating as 11.

Compose4=length(body('Get_items_3')?['value'])

Answer 1

Thanks for your reply but i am so so sorry this error was happening from my end and i solved it

Answer 2

Dear Muzammil,

Welcome to share any updates when you have time if you need further help on this issue.

Sincerely,

Cliff | Microsoft Community Moderator

Answer 3

Dear Muzammil,

Welcome to the forum here.

I did a quick test and I can't reproduce the issue as yours in our environment.

I'd like to confirm what output the Compose 4 connector returns and whether it returns 11 after you run the flow.

It seems that there are only 10 items in the list you test. If it is convenient, could you upload some screenshots about the list you are using for our reference and about the Compose 4 connector's output for our confirmation?

If it is convenient, please upload the table screenshot of the Excel file you are using and the full flow screenshots for us to do a test in our environment as well.

Note: Remove any private information before uploading the screenshots.

Welcome to share any updates when you have time if you need further help on this issue.

Thanks for your effort and time!

Sincerely,

Cliff | Microsoft Community Moderator