web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Automate how to get count of re...

Power Automate

Unanswered

how to get count of records that are returned

(0) Share

Report

Report

Posted on by Community Power Pla...

This is my List Records action and I’ve named it as List records.

I am getting the list records as below

I wanted to have the count of data that is returned from the above query in the values.

Please suggest me on how to do that. i have tried

length(body(‘List records’)?[‘value’])

length(body('List_records')?['value'])

In the condition to check but it always returns false.

I have tried with aggregation transformation which works fine from FetchXML and does not return values in MS flow

Categories:

I have the same question (0)

All responses Img

All responses (3)

Answers Img

Answers (1)

MJain 2,450 on at

Like (0)

Report

Hi @Anonymous ,

Considering your scenario this only is retrieving count of distinct columns, rather checking on the length checking the cds_xxxxx_count should give you exact number of records.

Thanks

Was this reply helpful? Yes No
Verified answer

v-bacao-msft on at

Like (1)

Report
Hi @Anonymous ,

Please try to use the following expression:

length(body('List_records')?['value'])

Feel free to let us know if you have any other questions.

Best Regards,

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

It worked @v-bacao-msft ,Thank you

Was this reply helpful? Yes No

Join the conversation