ClearCollect Missing Field Values for Some Rows in Collection

(0) Share

Report

Posted on by ruihaolrh

473

My datasource has both Name and Date fields, as per CRM view that I am fetching data from.

However, when get .Date and .Name field, all 'Date' fields are fetched correctly, but 'Name' fields are missing for some rows.

Edit: The 'Value' column in 'varDateRange' matches the date with record of '08/02/2024, 00:00:00' above with missing 'Name' value.

May I know why this situation occurred, as this wasn't happening earlier in the day.

Below is my formula for reference.

Thank you

 //Store Public Holidays Date and Name
 ClearCollect(
 ServiceCalendarDateAndNameBetweenSelectedDates,
 AddColumns(
 Filter(
 varDateRange,
 Value in Filter(
 'Service Calendars',
 'Service Calendars (Views)'.'Active Service Calendars'
 ).Date
 ),
 "Name", LookUp('Service Calendars', Date = Value).Name
 )
 );

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (0)

Sort by

vaubeee 533 on at

Like
a
(1)

Report
Copy link

Link copied!

HI @gymcode ! More or less a guess, but since this behavoiur means, that for that specific rows 'Service Calendars'.Date does not match the value of 'Value' I would check what exactly is returned as 'Value' in these cases. Just throw the return-value into a text-field. Good luck 😉

Was this reply helpful? Yes No
ruihaolrh 473 on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @VauBee , edited my response, misunderstood your reply.

May I know if there is a simple way to "concatenate the 'value' data during 'ClearCollect'?

Thank you

Was this reply helpful? Yes No
ruihaolrh 473 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @VauBee , after reviewing the code, I believe 'Value' comes from my 'varDateRange' collection earlier, using it's column 'Value' to Lookup the view's 'Date' column.

The Values are datetime values, and it was also found, and match the record in CRM view with the missing Name.

Was this reply helpful? Yes No
vaubeee 533 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @gymcode, tbh I still don't get what your 'Value' holds at runtime, so I'm fishing in murky waters 😉 Irrespective of this, I wonder whether this could work
//Store Public Holidays Date and Name ClearCollect( ServiceCalendarDateAndNameBetweenSelectedDates, AddColumns( Filter( varDateRange, Value in Filter( 'Service Calendars', 'Service Calendars (Views)'.'Active Service Calendars' ).Date ), "Name", LookUp('Service Calendars (Views)'.'Active Service Calendars', Date = Value).Name ) );

------------------------------------------------------------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved. Remember, you can accept more than one post as a solution.

If you like my response, please give it a Thumbs Up.

Was this reply helpful? Yes No