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

Community site session details

Session Id : /CbLytJJRI8YULtTlKYZ2X
Power Apps - Building Power Apps
Unanswered

Sharepoint Data not Showing to Most People

Like (0) ShareShare
ReportReport
Posted on 13 Jan 2021 01:00:32 by 156

I'm working on this project but after fixing all the errors. I seem to stumble upon a problem where the data shows on my end and my co-owners end but not to anyone other than the 3 of us. I checked the permissions in Sharepoint and for testing purposes, I allowed others to edit the list but the problem still persist. They are not even allowed to update the data inside through the apps. Below are the screenshot of the page where the data is missing.

OnSuccess

 

With({LeaveDataforUser:
 LookUp('EMP Leave Quota',
 Name.DisplayName=varUserName &&
 'Leave Type'=Switch(DataCardValue15.Selected.Value,
 "Medical","Medical Leave",
 "Maternity","Maternity Leave",
 "Additional Annual Leave", "Additional Leave",
 "Carry Forward Leave", "Carry Forward Leave",
 "Annual Leave")
 ),
 AddDays:Value(DataCardValue24.Text)},
Patch('EMP Leave Quota', 
 LeaveDataforUser,
 {Used:LeaveDataforUser.Used + AddDays}
 )
);

Patch(
 eLeaveApp,
 {ID:Self.LastSubmit.ID},
 Form4_1.Updates,
 Form2.Updates,
 Form4.Updates,
 {DateApply: Now()}
);
Navigate(Review);
ResetForm(Form3);
ResetForm(Form2);
ResetForm(Form4_1);
ResetForm(Form4);
UpdateContext({showAlert:false})

 

 

Data Capture from List

 

With(
 {
 eLeave:
 Filter(
 'EMP Leave Quota',
 'Leave Type' = "Carry Forward Leave"
 )
 },
 LookUp(
 eLeave,
 Lower(Name.DisplayName) = varUserName
 ).Entitlement
)

 

 

 

  • gimar01 Profile Picture
    156 on 14 Jan 2021 at 05:28:38
    Re: Sharepoint Data not Showing to Most People

    The sharepoint list currently only has around 100 records. So I guess it's under by a lot from the threshold limit.

  • joeinmay Profile Picture
    205 on 14 Jan 2021 at 04:49:24
    Re: Sharepoint Data not Showing to Most People

    What about the number of items in the SharePoint list, did that exceed the 5000 threshold limit. Reindex the data if so and apply filters if needed.

  • v-qiaqi@microsoft.com Profile Picture
    on 14 Jan 2021 at 04:18:54
    Re: Sharepoint Data not Showing to Most People

    Hi@gimar01,

    Which license do they have?

    Could you check if these end users owned proper PowerApps license to run your shared app?

    Let me summarize the current situation:

    1. All the end users have enough permission to the SP list and they can edit it within.

    2. There is no any other premium features and connectors within your shared app.

    Sorry that I could not reproduce your issue, please check the license assigned to these end users to see if they have enough license to access to your shared app.

    If the workload is not too heavy, you can create a new app and share it with these end users to see if this issue could be solved.

    If the issue is still, please consider open a ticket to our support team:

    https://powerapps.microsoft.com/en-us/support/

    Regards,

    Qi

  • gimar01 Profile Picture
    156 on 13 Jan 2021 at 11:22:46
    Re: Sharepoint Data not Showing to Most People

    I'll have to double check on the permission page again later on but as of now the users (testers) are able to edit in the Sharepoint List. They can directly interact with the table, for testing purposes only that is.
    To answer your questions:
    1. Yes, they should have the right permissions.

    2. No, there is no usage of any premium features.

    3. Currently for those who are testing it, they are allowed to edit it. But for some reason I can but others can't 

    I'll double confirm they have the edit access. For the code, I'll have to test it in another 12 hours or so. I'll be doing it in my office as I need their access towards it. Is there any other possibilities besides the few you mentioned?

  • v-qiaqi@microsoft.com Profile Picture
    on 13 Jan 2021 at 09:59:16
    Re: Sharepoint Data not Showing to Most People

    Hi@gimar01,

    Could you please share a bit more about the scenario, is there any error message generated?

    Please tell me the answer to the following questions:

    1. do all the users have the permission to the data source within your app?
    2. do you add any other Premium data source or On-premises data source in your app?
    3. which permission of your SP list has been assigned to your end users? Read permission only or Edit permission?

    If you want your end users to use this shared app to edit your SP list, please make sure that you have assigned "Edit" permission of your SP list to your end users.

    Or, if you use the SubmitForm() function, please consider using the Patch() function.

    If(
     EditForm1.Mode = FormMode.New
     Patch('SPlist', Defaults('SPlist'), EditForm1.Updates), // Add new record
     Patch('SPlist', BrowseGallery1.Selected. EditForm1.Updates) // Edit existing record
    );
    If(
     IsEmpty(Errors('SPlist')),
     Back(),
     Notify("Submit Fail!", NotificationType.Error)
    )

    Or you could re-create the app based on the SP list and share the app with your end users again. Then check if this issue is solved.

    Hope it could help.

    Best Regards,

    Qi

     

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Telen Wang – Community Spotlight

We are honored to recognize Telen Wang as our August 2025 Community…

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 637 Most Valuable Professional

#2
stampcoin Profile Picture

stampcoin 570 Super User 2025 Season 2

#3
Power Apps 1919 Profile Picture

Power Apps 1919 473

Loading complete