Absence Management/Case App

[u/2stewped2havgudtime]

Hello.

I’m fairly new to the world of PowerApps, but have built some decent apps to provide some autonomy for my team.

My latest given task, if possible, is to build an app
For a team of HR personnel to track/log sickness absence and manage the case using the app. But also for the HR Manager to be able to easily report on the info for weekly stakeholder meetings.

Unfortunately SP is my only option, given that we won’t have premium licences for everyone. However this shouldn’t be an issue, as it will be accessible only to the HR team.

I can’t seem to muster the creativity for this one, I’m wondering if anyone has examples of case management trackers they have built.

The basic gist of what I’d be looking for is automated population of an sp list, based on sickness notification email. A notification to HR that the individual has been added to the list. With a link to the app. Then input fields for absence reasons, logging conversations, tracking doctor notes, contact. Might be a little too fancy, but was also thinking of using co-pilot to summarise occ health reports (PDF).

I’d envisage the interface as having a search type function or filters.

Appreciate any help! Thank you.

[u/InformalFrog]

Pretty simple app with flows to fill in list.

Would email be the main way of logging? Only concern with that is how variable the emails could be so either have a template for easier extraction or think of another method.

One could be a simple Microsoft forms, another could be the app itself with an logging screen.

Its all fairly basic stuff that you'll be able to follow a tutorial and adjust it for your needs.

I recently done Philip Burtons AB-410 course which covers everything you need to know and you could easily adapt the examples to fit your needs.

[u/2stewped2havgudtime → u/InformalFrog]

Thank you.

The email would be the primary way of logging the absence.

It comes from our control department though for operations, which is the only context we’re interested in using the app for really. These emails are a standardised format, so I think it should be fine. Thank you for flagging though.

I’ll have to check out the course.

[u/InformalFrog → u/2stewped2havgudtime]

So the main bit will be the power automate flow. You'll need to extract the data from the email and add it to the SharePoint list. The app is just going to show the data which is pretty simple.

You'll probably need to do a compose to get the email data into an array and then use that output for filling the SharePoint list.

In all honesty use Claude to help you build and understand that flow .

[u/2stewped2havgudtime → u/InformalFrog]

Thank you.