Hello-
I have a collection that is loaded (ClearCollect) when a screen is opened (OnVisible). I want the collection to only contain active records. Note that this is a custom entity, but for the sake of anonymity I will be using Accounts instead of the entity name.
When I set the formula collect all entity records, it works perfectly -> ClearCollect(ActiveAccounts, 'Accounts')
However, when I set the formula to collect based on status or status reason, I get an error.
So I'm trying to have it set based on a system view -> ClearCollect(ActiveAccounts, 'Accounts', Accounts(Views). 'Active Accounts')
I'm not getting an error message, but my gallery doesn't show any data. I know for sure that my database (CDS) has 42 records on that particular view. (record count is low because this is a sandbox).
My gallery is set to show the collection items, and it does show two blank rows, but the data itself is blank.
Any idea why? I've been combing through blogs and docs without much help.
Here are the resources I've tried to follow:
https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/create-update-collection
https://powerusers.microsoft.com/t5/Building-Power-Apps/How-to-resolve-delegation-warning-message-on-PowerApps-formula/td-p/274507
https://davidlozzi.com/2019/02/01/best-practices-for-working-with-data-in-microsoft-powerapps/
https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/delegation-overview#delegable-data-sources
Please help!