What's happening?
When attempting to add a related column from a table with a many-to-one relationship to a custom table view in Dynamics 365, the related columns do not appear under the "Related" columns section.
Reason:
The "Searchable" option was not enabled in the relationship settings between the custom table and the related table.
Resolution:
- From Power Apps and ensure the correct environment is selected
- Navigate to Tables then select the custom table.
- Select Relationships
- Find and select the relevant many-to-one relationship.
- Enable the "Searchable" option for this relationship then select Done
- Publish the changes to the table
- After publishing is complete, the related columns will appear under the Add Columns > Related section when creating or editing views.
After enabling this setting, the related columns will become available for selection in your custom table views.