Dear All PowerApps Dev.
I am looking for someone can help me to build an attendance system using PowerApps, I'm really need help for this apps that will make all progress run smoothly.
Function Required:-
Thank You
AzzamNizam
Hi @azzamnizam,
If you want to save the Note/Remark text into your SP list, please modify the formula within the OnSelect proeprty of the "Check In" button as below:
Set( CurrentCheckedInRecord, Patch( 'YourSPList', Defaults('YourSPList'), { Title: "Check In&Out Test", StaffName: User().FullName, StaffEmail: User().Email, Check_x0020_In: Now(),
Remark: TextInput1.Text /* <-- Add formula here. Remark represents the column in your SP list to store your Notes/Remarks. TextInput1 represents the Text Input control within your app*/ } ) ); Navigate(CheckInSuccessScreen,ScreenTransition.Cover)
If you have solved your problem, please go ahead and click “Accept as Solution” so that this thread will be marked for other users to easily identify.
Best regards,
Kris
yes sure after all problem encounterd.... but the new problem I discoverd is....after I check in....I end the program task or end the task.... the check out data cannot be stored....how do I make the sessions last until I press the check out button pressed.. my concern is how if the user phone restart or no battery phone off....the cache data will lost and cant be check out
rgd
AzzamNizam
Hi @azzamnizam,
Do you want to cache your Check In record into your local device?
If you want to cache your Check In record into your local device, I think the SaveData function and LoadData function could achieve your needs.
Please check and see if the following blog would help in your scenario:
https://powerapps.microsoft.com/en-us/blog/build-offline-apps-with-new-powerapps-capabilities/
On your side, you should take a try with the following workaround:
Modify the formula within the OnSelect property of the "Check In" button to following:
ClearCollect( /* <-- Save Check In record into a Collection */ CurrentCheckedInRecord, Patch( 'YourSPList', Defaults('YourSPList'), { Title: "Check In&Out Test", StaffName: User().FullName, StaffEmail: User().Email, Check_x0020_In: Now(), Remark: TextInput1.Text /* <-- Add formula here. Remark represents the column in your SP list to store your Notes/Remarks. TextInput1 represents the Text Input control within your app*/ } ) );
SaveData(CurrentCheckedInRecord, "CachedData") /* <-- Add formula here */ Navigate(CheckInSuccessScreen,ScreenTransition.Cover)
Set the OnStart or OnVisible property of the first screen of your app to following:
LoadData(CurrentCheckedInRecord, "CachedData")
Set the OnSelect property of the "Check Out" button to following:
Refresh('YourSPList'); If( !IsBlank(CurrentCheckedInRecord), Patch( 'YourSPList', CurrentCheckedInRecord, { Check_x0020_Out: Now() } ) ); Navigate(CheckOutSuccessScreen,ScreenTransition.Cover)
Best regards,
Kris
Dear @v-xida-msft ,
Other storage than local device where else can store the cache data ?? Is there possible to store in cloud or any SP list ???
and if I store in local device means store in user phone ?? then what happen to the data after checkout button press ? the data still in the local device or has been released ?
Hi Team,
Your solution helped me a lot to create a check in and check out app.
I have created SP list and successfully passed check in time and check out time.
but I need different scenario of this.
I want to place a mobile near to entrance and need to scan the QR code. each staff member will give a unique QR code containing a unique e-mail.
when he/she is check-in, I'm going to scan his/her QR code and do the check-in. after few people check-in, how to check-out 1st or 2nd checked-in user. (any solution to track using email and check-out)
Appreciate your support...
Hi v-xida-msft
Thank you for sharing the solution.
when i am trying to implement this solution , there is no data in SP list while i click on the check in and check out button. Secondly, i am receiving an error on Check In button as shown in the image.
Please help me with this issue.
I am trying to create an app for employee daily attendance system along with PTO(Paid Time Off- where employee able to check their available leave and request a leave like Leave->Request Template available in PowerApp)Check in button error
SP list
Dear @v-xida-msft ,
hi there how are you its been awhile I'm using it, need your assistance if I want to replace the textinput box to become radio button with specific list, do I need to change the code? or just link the sharepoint storage to radio button in order the data will goes in to sharepoint ? hope for your swift response thank you 🙂
warm regard
Azzam Nizam
Hi @azzamnizam ,
The value for a radio button should be Radio1.Selected.xxxx
Where xxxx is
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.
Hi Azzam, Did you get this app working?
Can you please share your check-out "on select" code? My data can't still be stored after the first line.
Thank you,
Stay up tp date on the latest blogs and activities in the community News & Announcements.
Mark your calendars and join us for the next Power Apps Community Call on January 20th, 8a PST
Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.
User | Count |
---|---|
203 | |
175 | |
62 | |
32 | |
30 |
User | Count |
---|---|
324 | |
268 | |
104 | |
74 | |
56 |