Skip to main content
Community site session details

Community site session details

Session Id : 6dE4uhhoyqcNkTYQnEyU4Q
Power Apps - Building Power Apps
Unanswered

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

Like (1) ShareShare
ReportReport
Posted on 8 Feb 2019 10:43:30 by

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.

  • DrCharlesDBA Profile Picture
    13 on 03 Feb 2023 at 07:45:09
    Re: Absence app: Need help creating new entry in form(sharepoint) and setting visibility on click etc.

    I am also looking for the same Absence application guidance of 500 employees using SP List and Canvas mobile app.

    May someone share some guidance.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Announcing our 2025 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for…

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 637 Most Valuable Professional

#2
stampcoin Profile Picture

stampcoin 570 Super User 2025 Season 2

#3
Power Apps 1919 Profile Picture

Power Apps 1919 473

Loading complete