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

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

May UG Leader Call Carousel 768x460.png

June User Group Leader Call

Join us on June 28 for our monthly User Group leader call!

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.


New Release Planning Portal (Preview)

Check out our new release planning portal, an interactive way to plan and prepare for upcoming features in Power Platform.

Top Solution Authors
Users online (1,359)