Gathering data for a gallery from two tables

(0) Share

Report

Posted on by Kato249

Hi All,

I have a main business calendar built from this YouTube video:

https://www.youtube.com/watch?v=NAEZ4m-EjDA

We use it for tracking job milestone dates stored in the table 'Jobs'. In this calendar we also want to display 'custom date entries'. These might be notes about when material will arrive, picking up parts etc. This is stored in the 'CandarEntryDate' column in the 'OtherCalendarEntries' table.

The code I'm using to filter data into my gallery Items is:

Filter(
 Jobs,
 And(
 'Action Date' = ThisItem.Value,
 Or(
 IsBlank(cbDateType.SelectedItems),
 IsEmpty(cbDateType.SelectedItems),
 'cr07e_datetype' in cbDateType.SelectedItems
 )
 )
)

From what I've read, using a collection might be a good way to ensure column name consistency but I'm unsure how to implement this as a solution?

Thanks in advance!

Categories:

Building Power Apps

All responses (1)

Answers (0)

v-jefferni Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Kato249 ,

For the 'OtherCalendarEntries' table, other than the 'CandarEntryDate' where stores 'custom date entries', is there an 'Action Date' column as well? According to the column name, it seems like the CandarEntryDate column should include date values, not the notes you mentioned in your post.

Best regards,