Unanswered

Sharepoint Data not Showing to Most People

(0) Share

Report

Posted on by gimar01

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
)

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (0)

Sort by

v-qiaqi@microsoft.com Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!
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:

do all the users have the permission to the data source within your app?

do you add any other Premium data source or On-premises data source in your app?

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

Was this reply helpful? Yes No
gimar01 156 on at

Like
a
(0)

Report
Copy link

Link copied!

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?

Was this reply helpful? Yes No
v-qiaqi@microsoft.com Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
joeinmay 205 on at

Like
a
(1)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
gimar01 156 on at

Like
a
(0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No