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! 🙂 

[Krix]

Thank you @WarrenBelz. I will try this today and yes that is my Sharepoint list.

Can you please enlighten me with the code you have added? Just wanna know the cause of the error 😞

[WarrenBelz]

Thanks @Krix ,

Instead of

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

I have separated the Filter and the Collect to the list

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

If code is working some times and not others, it could be that you are using a function in a different way to what it was designed for and get inconsistent results.

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.

[Krix]

@WarrenBelz 

It's throwing an error, is this correct way to do it?

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
      }
   )
);
ClearCollect(
   colFiltered,
   Filter(
      EmpData,
      !IsBlank(completed_work) && 
      !IsBlank(processing_time)
   )
);
Collect(
   'Site - Per Employee Data',
   colFiltered,  
);
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)

[WarrenBelz]

@Krix ,

What and where is the error?

[Krix]

Found it, please disregard. Thank you!

[WarrenBelz]

Thanks @Krix ,

If this is solved, please click Accept as solution as it will help others find it more readily. It also closes the item. 

[Krix]

Hi @WarrenBelz, im still experiencing some issues. is there any other reason why this is happening?

[WarrenBelz]

Hi @Krix ,

Without seeing the result, it is a bit hard to say, but if you use my code excluding the last Collect, and do some testing on what is in colFiltered (or whatever you want to call it), you will see the data that is about to be written to SharePoint and maybe determine what the issue might be on different scenarios. Intermittent problems are always the hardest to find as you have to reproduce them to fi them.

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.

[Krix]

Hi @WarrenBelz 

I might got your instruction wrong. You mean to remove this? 

Collect(
   'Site - Per Employee Data',
   colFiltered,  
);

My current formula is like this:

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
      }
   )
);
ClearCollect(
   colFiltered,
   Filter(
      EmpData,
      !IsBlank(completed_work) && 
      !IsBlank(processing_time)
   )
);
Collect(
   'Site - Per Employee Data',
   colFiltered
);
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)

[WarrenBelz]

@Krix ,

Yes - everything below the colFiltered collection code. All I am trying to do is get the data you are wanting to write into a collection so you can look at it each time rather than having to test on on a data source.

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.