Showing results for 
Search instead for 
Did you mean: 
Frequent Visitor

Absence app: Need help creating new entry in form(sharepoint) and setting visibility on click etc.

Hi everyone,

I am creating an absence app for my department. I know there is one in the templates in PowerApps, but I decided to make my own. Now do note, I am no IT professional, just a mechanical engineer trying stuff out.


Now I got all the viewing parts of my form done, and I am trying to create the screen where people will submit new entries. The entries must be submitted to a sharepoint list, that I can then later use to generate calendars, start approval flows etc. The list has these columns:

So, a pen icon on the page before navigates to this screen:

I need a click on either of those four icon to:

- Set the "Absence Category" value for the list entry

- Hide the four icons and the "What do you want to submit?" text to reveal the rest of the form behind it


So, behind the above shown icons and text, I have put the form and added the entries that need to be added manually:

I will then need these fields to set the correct values for the new entry in the "Absence Form" list. And then the submit button to submit the entry and navigate the user back to another screen.

I need certain values of the list to be filled automatically, like requested by, approval status, icon and requester email. Those values are just based on who they are, and what they have chosen in the other boxes. And I would like the From default values to be dependant on other choices as well. So report sick for example would set todays day at 8 - 16 in from and to.

Also I need the "Absence Category" selection from the first screen to filter the "Absence Type" drop-down on this screen. So that if they pressed "Report Sick" for example, they would see only the relevant types. I have defined the relationship between the categories and types in another list called "Absence Type", which is the list that the "Absence Form" list does look-ups into:


Can anyone help me get going on this? I haven't been able to get anything working.


Helpful resources

PA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.

Microsoft Build 768x460.png

Microsoft Build is May 24-26. Have you registered yet?

Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.

May UG Leader Call Carousel 768x460.png

What difference can a User Group make for you?

At the monthly call, connect with other leaders and find out how community makes your experience even better.

Top Solution Authors
Top Kudoed Authors
Users online (1,363)