cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Taylor28
Helper I
Helper I

Employee Check In/Out

Hi,

My team has been tasked with creating a Check In/Out app for employees entering the building. So far I have created an app that data source is a SharePoint list. There is two buttons(Check In/Out). We would like the user to be able to check in and out multiple times throughout the day if they leave the building.Also if the user closes the app they can still check out when the app is launched again.The Check In button works as expected,the issue that I am having is the Check Out button. I receive the error message "Invalid Argument Type(Table).Expecting a Record value instead". Not sure how to fix this error code,any help would be greatly appreciated.

 

To give some background on the formulas used are the following:

On Start:LoadData(CurrentCheckedInRecord,"CachedData")

Check In Button: ClearCollect(CurrentCheckedInRecord,Patch('Employee Check In/Out',Defaults('Employee Check In/Out'),{Title:"CheckIn/Out",pbsi:User().Email,Employee_x0020_Name:User().FullName,cj8t:Now()}));SaveData(CurrentCheckedInRecord,"Catched Data");Navigate('Check In Success',ScreenTransition.Cover)

Check Out Button: Refresh('Employee Check In/Out');If(!IsBlank(CurrentCheckedInRecord),Patch('Employee Check In/Out',CurrentCheckedInRecord,{t74w:Now()}));Navigate('Check Out Success',ScreenTransition.Cover)

 

Thank You.

 

 

2 REPLIES 2
Jeff_Thorpe
Super User
Super User

Try replacing IsBlank(CurrentCheckedInRecord) with IsEmpty(CurrentCheckedInRecord) or if you want to use IsBlank then try getting a value from the record like this: IsBlank(First(CurrentCheckedInRecord).Title)



--------------------------------------------------------------------------------
If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.

Thank you for the quick reply!

Now I get this error message when using the IsEmpty function."Unexpected Characters.Characters are used in an unexpected way".

I attached the formula I entered and the error message.

 

Helpful resources

Announcements
Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (4,698)