Power Apps Community,
I have two SharePoint lists that are connected by IDs that track a time entry and an associated tag in the Title column:
TimeEntries.ID = TimeEntryTags.TimeEntryID
I have a created collections for both of these lists using the same date filters where VarUserName is the Full Name of the user and StartTimeAsNumber is the date as a number in yyyymmdd format:
ClearCollect(EntriesCol1, Filter(TimeEntries, Title = VarUserName, StartTimeAsNumber >= Value(FilterByStartDateInput_1.Text)));
ClearCollect(TagsCol1, Filter(TimeEntryTags, 'Full Name' = VarUserName, StartTimeAsNumber >= Value(FilterByStartDateInput_1.Text)));
Next, I want to create a new collection which has the Tag associated with the TimeEntry.
ForAll(EntriesCol1, Collect(EntriesWithTagCol2, {TimeID: ID, Tag: LookUp(TagsCol1, TimeEntryID = ID).Title}));
For some reason, the Title column of TagsCol1 does not transfer to the new collection EntriesWithTagCol2.
I can use a gallery to display EntriesCol1 and then use a LookUp in a Label to get the associated tag in the Title column:
Label.Text within Gallery = LookUp(TagsCol1, TimeEntryID = ThisItem.ID).Title
I can also hard code labels with the matching IDs to get the Title column:
LookUp(TagsCol1, TimeEntryID = 118).Title
Why can I not get the ForAll(EntriesCol1 statement to work with the LookUp to get the Title column from TagsCol1?
I would really appreciate some help. I've spent a lot of time banging my head against a wall trying to figure this out.
Thank you!
