web

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

News and Announcements icon

Power Platform CommunityForums Power Apps FetchXML: how to get r...

Power Apps

Answered

FetchXML: how to get records by page and records count in the same query?

(0) Share

Report

Report

Posted on by Max77

264

Hi, guys!

There are about 50k records in my entity.

I use "PA: List Rows" with some conditions to get records.

<fetch count='@{triggerBody()['number']}' page='@{triggerBody()['number_1']}' >
 <entity name='pbl_items'>
 <attribute name='pbl_itemsid' />
......

So I get a portion of records, but i'd like to get record count that match my conditions.

Is it possible to get RecordCount in the same query (in one touch)?

Maybe FetchXML has the feature/trick?

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (1)

Verified answer

a33ik 3,306 Most Valuable Professional on at

Like (1)

Report
Hello,

You can try to use the following attribute in FetchXml query:

<fetch returntotalrecordcount="true">

It should return the total number of records. One thing I'm not sure is how to get it out of the results.

Was this reply helpful? Yes No
Max77 264 on at

Like (1)

Report

@a33ik thank you very much!
It works.
The list Rows result contains odata.count

Was this reply helpful? Yes No

Join the conversation