Data not getting recorded

[Krix]

Hi Guys, can we ask for your help regarding an issue wherein the data is not getting recorded properly in our Sharepoint List?

We have created an app wherein it acts like a form and feeds the data in our Sharepoint List. This is being used by different users that they feed in data in daily basis. As we go along we noticed that some of the entries of other users are not getting recorded, there will be days that it will be okay but most of the time it's not. 

I am not sure if this is due to security or how the SP list is shared. Currently I have created a group for users gave them a permission level of 'Contribute' in our Sharepoint. Was that enough or are we missing something that causes these data missed?

Appreciate the help here! 🙂 

[mcin9781]

From a permission perspective you will need to give the user "Contribute" access which you have already done in SharePoint.  If you are using a Canvas App, the app will need to be Shared with the users that are expected to use the app.  Also the individuals using the app will need access to the data sources tied to the app as seen below.  I have attached a couple of articles to show how to connect the App to SharePoint Online so the form will be automatically created, and how to effectively share the canvas app to end users.  I hope this helps resolve your issue.  If so please mark the post as the suggested answer.  Thanks!

https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/connections/connection-sharepoint-onlin...

https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/share-app

[Krix]

Hi @mcin9781, thank you so much for the reply.

In sharing part we already did that. Canvass App is already shared to respective users, as well as our Sharepoint Online. The weird part is that there are times that the data entry gets recorded properly but most of the time not. Please note that all of the expected users were able to open the Canvass App and use it properly. We are at lost on what is the reason why this is not getting recorded in our Sharepoint List properly. 😞

[Krix]

Apologies for multiple replies, I checked our Canvass App and saw that the Data Souce is properly shared as well. 

[mcin9781]

I see, you may want to consider opening a support ticket for this issue.

[Drrickryp]

Hi @Krix 

I'm not sure if this is an issue but I have found that many intermittent problems with SharePoint have to do with delegation. You may want to check to make sure that the formulas you are using to display and enter your data are not being limited by the data row limit in Advanced settings. 

[Krix]

Hi @Drrickryp,

I checked the Data Row Limit and it was set to 500. What is the advisable row limit that I should use here?

My App has:

• 51 text box that the users fill in, most of the times they are not really using it all
• 1 calendar box
• 1 dropdown list
• Once they fill in they click on submit. The formula that I'm using into it is:

Clear(EmpData);
ForAll(RenameColumns(Gallery2.AllItems,"Title5","Title5_1"),Collect(EmpData,{Title: email.Text, employee_type: emptype_2.Text, date_: DateValue(Text(date_2.Text,"[$-en-GB]mm/dd/yyyy")), expected_hrs: exphrs_1.Text, onsite_hrs: onsite_3.Text, wfh_hrs: wfhhrs_2.Text, task_proj: projname.Text, volume_completed: completed_work.Text, processing_time: timetaken.Text}));
Collect('Site - Per Employee Data',Filter(EmpData,IsBlank(completed_work)=false && IsBlank(processing_time)=false));
Set(ResetGalleryText,false);
Set(ResetGalleryText,true);
UpdateContext({ResetCheckbox:true});
UpdateContext({ResetCheckbox:false});
Reset(emptype);
Reset(exphrs);
Reset(onsite);
Reset(wfhhrs);
Reset(_date);
Set(test,1)

I'm thinking that maybe this is the reason of it? or because I am using gallery?

[Drrickryp]

Hi @Krix 

Increase the data row limit to 2000 and see if it solves the problem.  There should be no negative effect of increasing the limit to 2k.

[Krix]

I'm still having issues 😞

[WarrenBelz]

Hi @Krix ,

In the code below

Clear(EmpData);
ForAll(
   RenameColumns(
      Gallery2.AllItems,
      "Title5","Title5_1"
   ),
   Collect(
      EmpData,
      {
         Title: email.Text, 
         employee_type: emptype_2.Text, 
         date_: 
         DateValue(
            Text(
               date_2.Text,
               "[$-en-GB]mm/dd/yyyy"
            )
         ), 
         expected_hrs: exphrs_1.Text, 
         onsite_hrs: onsite_3.Text, 
         wfh_hrs: wfhhrs_2.Text, 
         task_proj: projname.Text, 
         volume_completed: completed_work.Text, 
         processing_time: timetaken.Text
      }
   )
);
Collect(
   'Site - Per Employee Data',
   Filter(
      EmpData,
      !IsBlank(completed_work) && 
      !IsBlank(processing_time)
   )
);
Set(ResetGalleryText,false);
Set(ResetGalleryText,true);
UpdateContext({ResetCheckbox:true});
UpdateContext({ResetCheckbox:false});
Reset(emptype);
Reset(exphrs);
Reset(onsite);
Reset(wfhhrs);
Reset(_date);
Set(test,1)

You end up with the Collection 'Site - Per Employee Data' OR is this the SharePoint list name and your photo did not show the top of the name? If the second (and I suspect it is), try this for last bit in Collect

ClearCollect(
   colFiltered,
   Filter(
      EmpData,
      !IsBlank(completed_work) && 
      !IsBlank(processing_time)
   )
);
Collect(
   'Site - Per Employee Data',
   colFiltered,  
);

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.