I’m working on a flow where I fetch the list of custom tables from a specific environment that have not been modified in the past 3 years, and then export the list along with the row counts into Excel. For this, I’m using the ModifiedOn field as the key to identify the last modified date of each table.
The flow generally runs fine, but I’m encountering this error for certain tables:
Error:
Could not find a property named 'modifiedon' on type 'Microsoft.Dynamics.CRM.<tablename>'.
When I check the table manually in Dataverse, the ModifiedOn field is clearly present. However, Power Automate still throws this error while fetching the data.
Has anyone faced this issue before? Why would Power Automate fail to recognize the modifiedon
field in some tables even though it exists?
Hamza H
1,786
Muhammad Shahzad Sh...
1,132
Most Valuable Professional
Abhilash Warrier
351
Super User 2025 Season 2