Showing results for 
Search instead for 
Did you mean: 
New Member

Rollup Fields


I hope someone can help a beginner.

I have two entities: Entity A "Program" and Entity B "Application"

they have a one to many relationship "one program to many application"

I tried to create a rollup field (datatype is Whole number) in Entity A to count all the active applications in Entity B.

I cannot see the "application status" field (datatype is Option set) under the list of fields that show in the rollup filter query. The "application status" field was created in Entity B


Is there a way to resolve this? is there something I'm doing wrong?

Dual Super User II
Dual Super User II


You should be able to see the application status, are you sure you have published your latest changes?


If this post helps you with your problem, please mark your as Accepted solution.If you like my response, please give it a Thumbs Up.

Blog: here

I saved the table. I will attach two images here... one of them shows the rollup query where the "Application Status" Field doesn't show and the second image shows the "Application Status" field in the Application Entity Rollup ImageRollup ImageApplication TableApplication Table 

Super User
Super User

Hello @JumiyaUmoru,


Try Checking weather the field is Searchable or not.


Go to

Then Click On Dataverse --> Click tables --> Open the Table where you are refereing --> Click On Fields --> Make Sure Searchable is enabled. --> Save then Publish and try again.


Please mark as Answer if it is helpful and provide Kudos

Subscribe :
Blog :

Helpful resources

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Power Platform Call June 2022 768x460.png

Power Platform Community Call

Join us for the next call on June 15, 2022 at 8am PDT.

PA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.


New Release Planning Portal (Preview)

Check out our new release planning portal, an interactive way to plan and prepare for upcoming features in Power Platform.

Users online (2,509)