I'm hoping someone can help provide some information as to the cause of this issue. In the Power Pages I'm creating, there is a specific need to use an API call to get data from a specific table. I need to get all the rows from the table, but I'm unfortunately receiving this error message.
{"error":{"code":"9004010D","message":"Common Data Service error occurred.","cdscode":"0x0","innererror":{"code":"0x0","message":"Could not find a property named 'xxx_Project' on type 'Microsoft.Dynamics.CRM.xxx_taskyear'."}}}
The interesting part is that there is no longer a column named Project in this table. It has been deleted and a new relationship has been established. I've also configured the site settings for the Task Year table to enable API calls and to retrieve all fields, and I'm able to pull specific entries when I pass in a GUID. There are a couple other tables that are experiencing the same issue.
The only common thing between all the tables is that they each had a lookup column that has been deleted and replaced with a different one. I am using these lookup columns to establish a relationship and configure the table permissions (meaning I have table permissions with the parent access type). I want to avoid deleting the tables and recreating them if there is a way to fix this issue. Any help or guidance would be appreciated.