web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Issue loading data int...
Power Apps
Unanswered

Issue loading data into collection from Dataverse

(0) ShareShare
ReportReport
Posted on by 2

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"

Termigez00000_0-1610956260267.png

 

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. 

 

Categories:
  • v-xiaochen-msft Profile Picture
    Microsoft Employee on at

    Hi @Termigez00000 ,

     

    I think it’s a security role issue.

    Please check whether you and your colleague have permission to view each other's data.

     

    1\ Select the security role you have, then edit it.

     

    2\ Choose Custom Entities and find the Bookings entity.

    v-xiaochen-msft_0-1610961998743.png

     

     

    3\ Give enough permissions to 'Read' and save the setting.

    v-xiaochen-msft_1-1610961998743.png

     

     

    Best Regards,

    Wearsky

    If my post helps, then please consider Accept it as the solution to help others. Thanks.

  • Termigez00000 Profile Picture
    2 on at

    Hi, thanks for reply.

     

    I checked our security roles and they are the same and there is a permission to read data from "Bookings" table.

     

    I have also investigated this issue further and what I have found is:

    1.  When I create new records via patch function in the Canvas App - I can load those records, my colleague can not

    2. When he creates new records via patch function in the Canvas App - I can load those records, my colleague can not

    3. When I create new record via form in model-driven app - I can load those records, my colleague can not

    4. When he creates new record via form in model-driven app - I can not load those records, my colleague can

     

    Do you have any other ideas based on those observations? Or you still believe that something is wrong with security roles and we should look into it more? 

  • v-xiaochen-msft Profile Picture
    Microsoft Employee on at

    Hi @Termigez00000 ,

     

    This seems to be a strange problem.

    I suggest to check if it is a security role issue first.

    I suggest you assign a System Administrator role to your account and the account used by your colleagues.

    If you still encounter this problem after setting the security role, then I’m afraid the problem is not here.

     

    Best Regards,
    Wearsky
    If my post helps, then please consider Accept it as the solution to help others. Thanks.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Leaderboard > Power Apps

#1
11manish Profile Picture

11manish 397 Super User 2026 Season 2

#2
Mohsin Ali Profile Picture

Mohsin Ali 354

#3
WarrenBelz Profile Picture

WarrenBelz 232 Most Valuable Professional

Last 30 days Overall leaderboard