web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Leave request template...
Power Apps
Unanswered

Leave request template using a sharepoint list as a data source

(0) ShareShare
ReportReport
Posted on by

Hi!

 

Is it possible to link the Leave Request template to a Sharepoint list for the data source? 

 

If so what would be the type of column be for each column heading? 

 

Thanks in advance 

Categories:
I have the same question (0)
  • v-xida-msft Profile Picture
    Microsoft Employee on at

    Hi @AB21 ,

    Could you please share a bit more about your scenario?

    Do you want to connect the Leave Request template app to your own SP List data source rather than the built-in collection data?

     

    The user @Dee1 has faced similar issue with you, please check my response within the following thread:

    https://powerusers.microsoft.com/t5/Power-Apps-Portals/Leave-Request-PowerApp-no-Option-to-Create-Excel-Data-Sheet-in/m-p/413954

     

    On your side, you should create corresponding SP List for the related collection data source. Then add these SP Lists as data source into your app. Within your SP List, for the date column header, you should create a Date type column to store its value, for other column headers, you could create a Single Text type column to store value.

     

    Please consider take a try with above solution, check if the issue is solved.

     

    Best regards,

  • AB21 Profile Picture
    on at

    Hi Kris, 

     

    So this is what I have done so far. 

     

    I have created the SP list Screenshot. 

     

    I have added it as a data source. 

     

    I have changed the confirmation screen OnVisible to link to the SP list. The name of the list is LeaveRequest 

     

    I have added the screenshots for these as attachments. Can you check that I'm going in the correct direction. 

     

    I cant actually test the leave request app as when Im creating a new request I cant seem to click on a name in the GalleryChangeApprover when selecting a user to "submit a request" The name will highlight but not actually select 

     

    Gallery name select.png

     

    Screenshot 2020-02-07 at 7.26.36 AM.png

     

     

     

     

     

     

     

    Data source.png
    SP list.png
    Confirmation screen - OnVisble.png

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Congratulations to the March Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
11manish Profile Picture

11manish 505

#2
WarrenBelz Profile Picture

WarrenBelz 502 Most Valuable Professional

#3
Haque Profile Picture

Haque 324

Last 30 days Overall leaderboard