Power Platform Community Forum Thread Details

In Data verse there is a Email default table, where all email data are stored. I have created another table manually to store the status, aging calculation etc and created email message id column as unique one.. I have created relationship with Email to another table as N:1. I am trying to create view in Email table and filter using both table column, the data for the other data column is blank. When i add filter with other other table then i am getting no item to display. when remove the other table column in filter, the value in the specific relationship filled value appearing blank. Other fields having values. Please guide how to create views by creating relationship filter and column

Categories:

Microsoft Dataverse with Power Apps

Steps to Fix and Create a Working View in Dataverse

Check Relationship Type and Data Availability
- Since you created an N:1 (Many-to-One) relationship from your custom table to the Email table, ensure that:
  ✅ The custom table actually has records linked to the Email table via Email Message ID.
  ✅ The Email Message ID column in the custom table correctly maps to the primary key of the Email table.
Ensure Records Exist in Related Table
- Open both tables in Dataverse and check:
  - If your custom table has values populated in the Email Message ID field.
  - If the Email table has related records in the custom table.
Fix the View Filtering Issue
- When creating a view in the Email table:
  - If you add columns from the related table, Dataverse will only show emails that have related records in the custom table.
  - If no matching record is found, those related columns appear blank.
✅ Solution: Use a left join-style filter by modifying the view:
- Instead of filtering only on fields from the related table, try:
```
 
```
  plaintext
  
  CustomTable.Status is not null
- This ensures that only emails with related records in the custom table are displayed.
Using Advanced Find or FetchXML
- Instead of just filtering in a view, try using Advanced Find:
  - Open Power Apps > Dataverse > Tables > Email.
  - Click Advanced Find.
  - Add a filter like:
```
 
```
    plaintext
    
    Related Custom Table > Status contains data
  - This ensures that only emails with related records are shown.
Consider a Power Automate Flow (If Needed)
- If you want all emails to always have a related record, you could create a Power Automate flow to automatically insert a record in the custom table whenever an email is created.