Skip to main content
Microsoft logo
Power Apps
    • AI Builder
    • Automate processes
    • Azure + Power Apps
    • Build apps
    • Connect data
    • Portals
  • Pricing
    • Overview
    • Become a Partner
    • Find a Partner
    • Find partner offers
    • Partner GTM Resources
    • Blog
    • Customer stories
    • Developer Plan
    • Documentation
    • For IT Leaders
    • Roadmap
    • Self-paced learning
    • Webinars
    • App development topics
    • Overview
    • Issues
    • Give feedback
    • Overview
    • Forums
    • Galleries
    • Submit ideas
    • User groups
    • Register
    • ·
    • Sign in
    • ·
    • Help
    Go To
    • Power Apps Community
    • Welcome to the Community!
    • News & Announcements
    • Get Help with Power Apps
    • Building Power Apps
    • Microsoft Dataverse
    • AI Builder
    • Power Apps Governance and Administering
    • Power Apps Pro Dev & ISV
    • Power Apps Portals
    • Connector Development
    • Power Query
    • Power Platform Integration - Better Together!
    • Power Platform Integrations
    • Power Platform and Dynamics 365 Integrations
    • Community Blog
    • Power Apps Community Blog
    • Galleries
    • Community Connections & How-To Videos
    • Community App Samples
    • Webinars and Video Gallery
    • Canvas Apps Components Samples
    • Kid Zone
    • Business Value Webinars and Video Gallery
    • Emergency Response Gallery
    • Events
    • 2021 MSBizAppsSummit Gallery
    • 2020 MSBizAppsSummit Gallery
    • 2019 MSBizAppsSummit Gallery
    • Ideas
    • Power Apps Ideas
    • Community Engagement
    • Demo Extravaganza 2021
    • Demo Extravaganza - Components 2021
    • Power Apps Community Demo Extravaganza 2020
    • Experimental
    • Error Handling
    • Power Apps Experimental Features
    • Community Support
    • Community Accounts & Registration
    • Using the Community
    • Community Feedback
    cancel
    Turn on suggestions
    Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
    Showing results for 
    Search instead for 
    Did you mean: 
    • Power Apps Community
    • Galleries
    • Community App Samples
    • Leave Request Power App - SharePoint

    Leave Request Power App - SharePoint

    06-02-2021 13:06 PM - last edited 06-02-2021 13:08 PM

    Dual Super User RezaDorrani
    Dual Super User
    5029 Views
    LinkedIn LinkedIn Facebook Facebook Twitter Twitter
    RezaDorrani
    Dual Super User RezaDorrani
    Dual Super User
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Email to a Friend
    • Report Inappropriate Content

    Leave Request Power App - SharePoint

    ‎06-02-2021 01:06 PM

    Leave Request App Template

    Step 1

    Create a SP list with the following name: Leave Request

     

    Column Name

    Column Type

    Comments

    Title

    Single line of Text

    This will be the default column that gets created in a SharePoint list

    Detail

    Multiple Lines of Text

     

    From

    Date and Time

     

    To

    Date and Time

     

    Leave Type

    Choice

    Choice values:

    ⛱️ Vacation

    🤒 Sick Leave

    🎈 Floating Holiday

    ⚖️ Jury Duty

    💔 Bereavement

    Status

    Choice

    Choice values:

    Declined

    Approved

    Pending Manager Approval

    Pending HR Approval

    Manager

    Person or Group

     

    HR

    Person or Group

     

    Approval Comments

    Multiple Lines of Text

     

    Approval Link

    Single Line of Text

     

     

    RezaDorrani_0-1622664441781.png

     

    Step 2

    Import App zip file in Power Apps.
    Imported zip file will contain both the App & the flow.

    Step 3

    Edit the App.
    On App OnStart function, Set the HR Admin details as follows: Set(HRManagerEmail, "place email of HR Admin here")
    Remove the SharePoint data source from the App & add a new SharePoint data source connection with your newly created “Leave Request” list.

    Step 4

    Go to flow.microsoft.com
    Turn on the “Leave Request Approval Process flow”
    Edit the flow and update the SiteURL action to point to your SharePoint site where the new “Leave Request” list has been created.


    Thanks,
    Reza Dorrani, MVP
    YouTube
    Twitter

    watch?v=0U5jax-zMIc

    LeaveRequestApp_20210602180703.zip
    Labels:
    • Labels:
    • Galleries and Forms
    • Workflow and Process Automation
    Message 1 of 5
    5,029 Views
    8 Kudos
    Reply
    • All posts
    • Previous Topic
    • Next Topic
    Fred_Francois
    Fred_Francois
    New Member
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Email to a Friend
    • Report Inappropriate Content

    ‎10-26-2021 08:37 AM

    Thank you for yours explain.

    Message 2 of 5
    3,449 Views
    0 Kudos
    Reply
    jeffhhs
    jeffhhs
    Frequent Visitor
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Email to a Friend
    • Report Inappropriate Content

    ‎01-31-2022 07:27 AM

    @RezaDorrani Thank you for this app.  Please help as i'm almost there with this app in our organization.

     

    I'm getting a error when Submitting from App - list records are written but Flow does not run.  Error: WorkflowTriggerIsNotEnabled...  I have manually turned on Flow but still receive error.  When i manually run flow I get inputs....if I put in a known list record ID, the flow runs then fails on "the passed in field "approval link" could not be found.

    Manually trigger flow:

    jeffhhs_1-1643809363968.png

    Manually trigger flow

    jeffhhs_2-1643809441855.png

     

     

     

    When app triggers flow:

    jeffhhs_0-1643807063157.png

     

     

    Can you help?  And thank you!

    Message 3 of 5
    2,520 Views
    0 Kudos
    Reply
    ChaseWills
    ChaseWills
    Regular Visitor
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Email to a Friend
    • Report Inappropriate Content

    ‎04-07-2022 09:06 PM

    Hi there, 

     

    Do you know if there is a way that it will detect the direct supervisor in the org taxonomy and email that person based on the requestor?

     

    Thank you!

     

    CW

    Message 4 of 5
    1,613 Views
    0 Kudos
    Reply
    PowerAppChris
    PowerAppChris
    Frequent Visitor
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Email to a Friend
    • Report Inappropriate Content

    ‎04-27-2022 11:19 AM

    Hello to everyone.

     

    Thank you Reza to share this template. 

    I am facing two issues regarding the PowerApp part.

     

     

    First Issue : The App can´t retrieve the manager of the user

     

    It says "UserManager" is unknown. So I guess that I need to see with the IT admin of my company (I don´t have the rights to access to the Active Advisory) how to link employees to their manager right ?

    Or I guess I need to modify the way the code is writing to make it match with the current organization.

     

    PowerAppChris_3-1651082989696.png

     

    Second Issue : HR and Manager are not updated in my SharePoint List

     

    I put my own mail adress as HRManagerEmail as suggested in the tutorial. But my "HR" field is still empty when I create a leave request. 

    I guess that when Submitting the form, it should update this field in SharePoint right?

     

     

     PowerAppChris_2-1651082954157.png

    My Sharepoint list : 

     PowerAppChris_1-1651082902815.png

     

    Same issue for Managers : but maybe because of the first issue...

    Can I find a way to ALWAYS fill HR field with the same e-mail adress ? (it will never change) 

     

     

    Last issue (But not that big) : 

     

    I dont´t know why when I submit the form, the title will go within "delete" column randomly. 

    I was not able to find the link between where each field of the form should populate which column. 

     

    PowerAppChris_4-1651083254199.png

     

     

    Thank you for your precious help! I don´t usually code, so I hope that my questions won´t be too obvious.

     

    Christophe from France

     

     

     

     

     

    Message 5 of 5
    1,331 Views
    0 Kudos
    Reply

    Power Platform

    • Overview
    • Power BI
    • Power Apps
    • Power Automate
    • Power Virtual Agents

    Power Apps

    • Sign in
    • Sign up

    Browse

    • Sample apps
    • Services

    Downloads

    • Windows
    • iOS
    • Android

    Learn

    • Documentation
    • Support
    • Community
    • Give feedback
    • Blog
    • Partners

    • © 2022 Microsoft
    • Follow Power Apps
    • Privacy & cookies
    • Manage cookies
    • Terms of use
    • Trademarks