Saving and Loading Data from Collection

[MH3]

Hello,

I have an application which stores attendance of employees, I have two buttons Check in and Check Out

if a user clicks on Check In, and then he closes the app and re opens it again then when he check out the data is not saved in the SP Lists, as I have created a collection and saved my Check In SPList record in a collection by using Saved Function.

  Button
Check in Code:

ClearCollect(                                /* <-- Save Check In record into a Collection */
     CurrentCheckedInRecord,
     Patch(
       Attendance,    /*my SP List*/
        Defaults(Attendance),
        {
          Title: "Check In&Out Test",
          User: MyUser,
          'User Email': User().Email,
          Check_x0020_In: Now(),
          Staus: "IN"
        
        }
    )
);
SaveData(CurrentCheckedInRecord, "CachedData")   
Navigate(CheckInSuccessScreen,ScreenTransition.Cover)

Button Check Out

Refresh(Attendance);
If(
    !IsBlank(CurrentCheckedInRecord),
    Patch(
      Attendance,
       CurrentCheckedInRecord,
       {
         Check_x0020_Out: Now(),
         Status: "OUT"
       }
     )
);
Navigate(CheckOutSuccessScreen,ScreenTransition.Cover)

There are some errors in Checkout Button, in if function that, expected a record value instead of a (Table).

 Loaded the Data from Collection
App OnStart Code:

LoadData(CurrentCheckedInRecord, "CachedData")

Any Help to fix my app, if someone checks in and then come back, he should be able to check out, and then he/she can check in again after that.

[UdayAdhikari]

I would try building the collection outside of Patch function and then finally Patch. Also, please note that you have "Status" column misspelled in Check In button/code :). Confirm the Status column name.

Refresh(Attendance);
If(
    !IsBlank(CurrentCheckedInRecord),
    AddColumns(CurrentCheckedInRecord, "Check_x0020_Out", Now(), "Status", "OUT");
    Patch(
      Attendance,
       CurrentCheckedInRecord,       
     )
);
Navigate(CheckOutSuccessScreen,ScreenTransition.Cover)

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.

[MH3]

Hi @UdayAdhikari ,

your code shows some error:



My issue is, If someone checks in at first and then someone closes the app and re open it again, they should check out and then they can check in again.

Any Help!!

[v-bofeng-msft]

Hi @MH3 :

First,let me explain why you encount this problem.

According to your description, your goal is to update a specified record.So the second parameter of the Patch function must be a record,but CurrentCheckedInRecord is a table(Even if it contains only 1 record, it is also a table).

Second,please try this code,and try again(Get the records in the table through the first function😞

Refresh(Attendance);
If(
    !IsBlank(CurrentCheckedInRecord),
    Patch(
      Attendance,
       First(CurrentCheckedInRecord),
       {
         Check_x0020_Out: Now(),
         Status: "OUT"
       }
     )
);
Navigate(CheckOutSuccessScreen,ScreenTransition.Cover)

Best Regards,

Bof

[MH3]

Hi @v-bofeng-msft ,

Your formula worked!, but only for the current session, like If someone checks in and then close the app and re opens it and then select that record from the gallery and then try to check out that, the button is not working the entry is not inserting in SP List (for the Check Out).

Please See the Video:


I refreshed the page, (if the user re-opened the app), I want to fix this any help? 

@UdayAdhikari @v-bofeng-msft 

[v-bofeng-msft]

Hi @MH3 :

Probably because the collection was not saved locally when the app was closed the second time.

Because your data source is SP list, I suggest you to use modified field instead of collection:

  Button
Check in Code:

  Patch(
       Attendance,    /*my SP List*/
        Defaults(Attendance),
        {
          Title: "Check In&Out Test",
          User: MyUser,
          'User Email': User().Email,
          Check_x0020_In: Now(),
          Staus: "IN"
        }
    ); 
Navigate(CheckInSuccessScreen,ScreenTransition.Cover)

Button Check Out

Refresh(Attendance);
If(
    Fitst(Sort(Attendance,Modified,Descending)).Status="IN",
    Patch(
      Attendance,
       Fitst(Sort(Attendance,Modified,Descending)),
       {
         Check_x0020_Out: Now(),
         Status: "OUT"
       }
     )
);
Navigate(CheckOutSuccessScreen,ScreenTransition.Cover)

Best Regards,

Bof

[MH3]

Hi @v-bofeng-msft ,

There are some errors in your code of Check Out


I'm really stuck in this application, help please!

[v-bofeng-msft · Accepted solution]

Hi @MH3 :

Sorry, I seem to have misspelled "first":

Refresh(Attendance);
If(
    First(Sort(Attendance,Modified,Descending)).Status="IN",
    Patch(
      Attendance,
       First(Sort(Attendance,Modified,Descending)),
       {
         Check_x0020_Out: Now(),
         Status: "OUT"
       }
     )
);
Navigate(CheckOutSuccessScreen,ScreenTransition.Cover)

Best Regards,

Bof

[MH3]

Hi @v-bofeng-msft ,

Thankyou very much, you saved my life. 

I was stuck for couple of days, and you solved my app issue!! I have no words to thank you Sir @v-bofeng-msft.

May GOD Bless You!

and you can explain the code in the checkout button? please

[MH3]

Hi @v-bofeng-msft ,

I have one more issue, if someone checks in and forgot to check out in that day, and on the next day, he/she opens the application again, they will still see the checkout button to checkout first, (which is generally not good) they should see check in on next day,

is there any condition, like if the forgets to check out the, the check out button should refresh at 12:00 AM, like on 2nd day a new entry should be inserted rather than the previous one.

can you help in this?