Unanswered

Dataverse Views where related table does NOT contain data

(0) Share

Report

Posted on by DerekShalShan

I would like to create a Dataverse (for Teams) View where related records do NOT exist in the related table.

So this could be a 1-Project-to-Many-Deliverables relationship where there are no related deliverables for some Projects, how to show those Projects? I don't see a way to do this within the View designer itself, since while "Contains data" is a dropdown that is the only option....

And it would seem that trying to use NOT (!) IN within the app's PowerFx formula would make the inverse View non-delegable, am I missing something?

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (3)

Answers (0)

Prakash4691 1,332 on at

Like (0)

Report

@DerekShalShan ,
Through UI for public view there is only option available as contains data. But you can create personal view via advanced find in that you will get option for does not contain. That private/personal view can be shared with others in your organization but we can't add it inside solution as a component for deployment.

There is one more option you can try that requires export (only the entities view which requires changes)->change in customization.xml->import back to the environment.

Below link for your reference. You can generate fetchxml for related data that not contains data and amend those changes in solution customization.xml file.
https://www.inogic.com/blog/2019/12/how-to-convert-personal-view-to-system-view-in-dynamics-365-crm/

If it answers your question, Kindly give kudo and accept it as solution.

Regards,
Prakash

Was this reply helpful? Yes No
Ram Prakash Duraisamy 5,593 Super User 2025 Season 2 on at

Like (0)

Report

Hello @DerekShalShan,

As per OOB Behavior Related Filter is not possible in VIEW Level.

Suggestion:

1. Navigate to https://make.powerapps.com
2. Click Gear Icon at the top
3. Click Advance Settings
4. Click Filter Symbol(ADVANCE FIND) at the top of the Banner
5. Select Lookup as Table
6. Create your Condition
7. Click Save As then provide name to the View.

That's it 🙂

Now you can able to see the view in your Views(My Views).

In Future if you want to share the Views then Go the Advance Find again Click SAVED VIEWS, Select the Views then Click SHARE and Share the Views to all the Users/Teams.

Please mark as Answer if it is helpful and provide Kudos

Subscribe : https://www.youtube.com/channel/UCnGNN3hdlKBOr6PXotskNLA
Blog : https://microsoftcrmtechie.blogspot.com

Was this reply helpful? Yes No
DerekShalShan 25 on at

Like (0)

Report

I'm still trying to make progress here.

CSG Pro in this video shows view technique to create a filtered view for "orphan children" (no parent record):

https://youtu.be/7fj87TAaTvw?t=1030

...But I'm still looking for efficient way to filter for "childless parents" and wondering if there will eventually be a "Does not contain data" option that would do the trick.

Was this reply helpful? Yes No