Answered

Fire Attendance register

(0) Share

Report

Posted on by Jim

I have been asked by my manger to come up with a smart way for employees can show attendance, It is record who is on site, and act as a fire register.

I had used excel it a drop down for in and out. However we are experiencing sync issues when using mobile phones to log attendance. see below

Column 2 is just to show how many first aid and emergency response we have on site.

We have never used power apps at our factory before, Is this something that can be transferred to powerapps and easily setup?

There is no real need to log date and times. it is just for an instant view of who is on site.

Thanks

Name
Shift A		IN/OUT
Employee 1	IRT/FA	OUT
Employee 2	IRT/FA	OUT
Employee 3	FA	OUT
Employee 4		OUT
Employee 5	FA	OUT
Employee 6	IRT/FA	OUT
Employee 7	IRT	IN
Shift B		IN/OUT
Employee 8	IRT	IN
Employee 9	IRT/FA	IN
Employee 10	IRT/FA	IN
Employee 11	FA	IN
Employee 12	FA	IN
Employee 13	IRT	OUT
Dayshift		IN/OUT
Employee 14		OUT
Employee 15		IN
Employee 16	IRT/FA	IN
Employee 17	FA	OUT
Employee 18		OUT
Employee 19	IRT/FA	IN
Employee 20		OUT
Employee 21		IN

	Total IN	10

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Sort by

eka24 20,925 on at

Like
a
(1)

Report
Copy link

Link copied!

Yes you can use Powerapps Gallery to display the Information in the table from Excel.
You will create a table in excel and connect it to powerapps.

Kindly follow this video:
https://youtu.be/-Z_13J02RPU?t=191

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

Was this reply helpful? Yes No
Verified answer

v-yutliu-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Jim ，

Do you want to filter data based on in/out status?

Firstly, I suggest you upload your excel file to one drive.

Format your data in excel as a table.

Then connect your app with this excel table.

Secondly, in powerapps, you could use a gallery to check Attendance's register.

You could also only check Attendance that status is in.

For example, set the gallery's Items to :

Filter(exceltablename,IN/OUT="IN")

Thirdly, you could also use edit form to create records or edit records for this excel table.

Here's a doc about the integration of gallery,edit form, display form for your reference:

https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/working-with-forms

Best regards,

Was this reply helpful? Yes No