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
)
The sharepoint list currently only has around 100 records. So I guess it's under by a lot from the threshold limit.
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.
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
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?
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:
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
WarrenBelz
637
Most Valuable Professional
stampcoin
570
Super User 2025 Season 2
Power Apps 1919
473