News and Announcements icon

Power Platform CommunityForums Power Apps - Microsoft Dataverse FetchXML: how to get r...

Power Apps - Microsoft Dataverse

Answered

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

Like (0) Share

Report

Report

Posted on 26 Feb 2024 12:31:44 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

All responses Img

All responses (2)

Answers Img

Answers (1)

Max77 264 on 26 Feb 2024 at 20:14:53

Like (1)

Report

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

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

a33ik 3,304 Most Valuable Professional on 26 Feb 2024 at 19:20:28

Like (1)

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

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.

Helpful resources

News and Announcements

🌸You're Invited: Community Spring Festival Awards Celebration 🌸

Replay: Power Platform Community AMA - Copilot Studio | April

Welcome to the Power Platform Communities

Quick Links

Subscribe to this forum!

Stay up to date on forum activity by subscribing.

Leaderboard

#1

WarrenBelz 146,745 Most Valuable Professional

#2

RandyHayes 76,287 Super User 2024 Season 1

#3

Pstork1 66,091 Most Valuable Professional

Leaderboard

Featured topics

Product updates

Microsoft Power Platform Community release plans