Hi @skoopman1988 ,
Could you please share a bit more about the Activitystatus column? Is it a Number type column in your Activity Entity?
Based on the screenshot that you mentioned, I think you have faced Delegation issue with your formula. Please note that the Delegation issue is not an error, it just means that you could not delegate the data process to your data source itself from your app, instead, you could only process data locally.
In default, you could only process 500 records at most in your app locally, you could change this limit to maximum value -- 2000, then you could process 2000 records locally at most. If the amount of your activities records is not more than 2000, you could ignore this issue.
Please refer to the following article for more details:
https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/delegation-overview
In addition, I also found an error with the "=" operator in your formula, please make sure the data type of the Activitystatus column in your Activity Entity is a Number type.
If the Activitystatus column is a Option Set type column in your Activity Entity, please modify your Filter formula as below:
Filter([@ModelDrivenFormIntegration.Item.Activities, Activitystatus = OptionSetName.Option1)
If the Activitystatus column is a Two Options type column in your Activity Entity, please consider modify your Filter formula as below:
Filter([@ModelDrivenFormIntegration.Item.Activities, Activitystatus = 'Activitystatus (EntityName)'.Option1)
If you also want to sort above Filter result based on the modifiedon clumn, please consider modify above formula as below:
SortByColumns( // Activitystatus is Option Set type column
Filter([@ModelDrivenFormIntegration.Item.Activities, Activitystatus = OptionSetName.Option1),
"modifiedon"
)
or
SortByColumns( // Activitystatus is a Two Options type column
Filter([@ModelDrivenFormIntegration.Item.Activities, Activitystatus = 'Activitystatus (EntityName)'.Option1),
"modifiedon"
)
Best regards,
