Hello all,
I am creating an app that allows users to book a desk. I have a table in Dataverse called "Bookings" with information such as desk ID, date, status or who has booked it.
I also use office365 connection to identify a user when application starts.
The issue is with the load of my collection colBookings, the function is:
ClearCollect(
colBookings,
AddColumns(
Filter(
Bookings,
Date in colDates
),
"Desk2",
Desk.Name,
"Employee2",
Employee.Name
)
);
where colDates is a collection of dates for next 7 days.
Currently I have 3 records in the table "Bookings"

Records number 1 and 2 are records that I created using function Patch inside my application. Record number 3 was created by my colleague inside model-driven application.
Now for some reason when the application loads (using my account), the collection colBookings only collects first two records, the record created by my colleague does not load (and it should have loaded).
Also when my colleague starts the app the colBookings function does not load those 2 records I created inside the app, it only loads the one record he created himself.
Any ideas what can cause such issue? We are both co-owners of the app.