web

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

News and Announcements icon

Power Platform CommunityForums Power Apps How to get records cou...

Power Apps

Unanswered

How to get records count of column with data in Dataverse

(0) Share

Report

Report

Posted on by SG013

74

HI

1.)I need to get record count based on choice field values of specific column in dataverse table.

2.)Is it feasible to get the related records count based on choice column values in Dataverse.

Please help me to find out the way to achieve the above

Thanks in Advance

SG

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (0)

Jonathan Manrique 2,695 on at

Like (0)

Report
Copy link

Link copied!

Hi @SG013

There are many ways to do it, but it depends on whether you are using a Canvas App or Model Driven Apps.

If you are using Model Driven, use the views and filter by the attribute so that you can obtain the total number of records with that characteristic. If you are using Canvas Apps you must create a collection with the dataverse table, and then you can use the countrow in a label, you can also make a countrow against the dataverse table, here you must be careful with delegation.

Like the previous point, you can do it in various ways, the classic thing is to include within the form a subgrid of the related table and it will give you the records, then you can use JS to count the total records of that grid, or use a rollup to tell.

You can also use the filters within the views and there you can filter by the parameters you want. Everything will depend on what you are really looking for and need, because what you need may be a Dashboard in Power Bi.

Was this reply helpful? Yes No
AllanDeCastro 412 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
Hello

You can use the Fetch query to do this, but beware of the limitation - you might want to do a pagination instead of a grouping as below!

Here's a sample FetchXML query to count records based on a choice field named new_choicefield in an entity named new_entity:

<fetch distinct="false" mapping="logical" aggregate="true"> <entity name="new_entity"> <attribute name="new_entityid" alias="count" aggregate="count"/> <filter type="and"> <condition attribute="new_choicefield" operator="eq" value="Option1"/> </filter> </entity> </fetch>

In this example:
Replace new_entity with the logical name of your entity.
Replace new_choicefield with the logical name of your choice field.
Modify the <condition> element to match the specific choice field value (Option1 in this case)
It is feasible to get the count of related records based on the values of a choice column in Dataverse. Here's a simplified example assuming a 1:N relationship from new_parententity to new_childentity:

<fetch distinct="false" mapping="logical" aggregate="true"> <entity name="new_childentity"> <link-entity name="new_parententity" from="new_parententityid" to="new_parententityid" alias="parent"> <attribute name="new_parententityid" alias="count" aggregate="count"/> <filter type="and"> <condition attribute="parent.new_choicefield" operator="eq" value="Option2"/> </filter> </link-entity> </entity> </fetch>

Was this reply helpful? Yes No

Join the conversation