I'm attempting to load a collection from a datasource in the application. I am getting the correct number of rows, and the fields are correct, but there is no data.
What's weird is the row count is correct, so I know it's seeing the datasource and filtering correctly.
I read several threads about the data not being loaded at the time, so I put a button in to try doing it that way with the same result.
ClearCollect(lastUserEntries, Distinct(Filter('Labor Allocation', ActuallyCreatedBy = User().Email, Date >= DateAdd(Today(),-10,Days)), Resource));
Solved! Go to Solution.
The use of the Distinct() function here is causing your problem. Distinct(datasource,ColumnName) reduces the datasource table to a single column of unique values from the column name and renames the column "Result". Your collection, lastUserEntries, will consist of one column of unique Resources named "Result".
The use of the Distinct() function here is causing your problem. Distinct(datasource,ColumnName) reduces the datasource table to a single column of unique values from the column name and renames the column "Result". Your collection, lastUserEntries, will consist of one column of unique Resources named "Result".
It was a little of both, the collection was initialized for a different object, so I was also trying to put a square peg in a round hole. Thank you for the help..
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
User | Count |
---|---|
165 | |
94 | |
69 | |
64 | |
63 |
User | Count |
---|---|
222 | |
160 | |
96 | |
86 | |
80 |