Using Sharepoint List for Leave Request Template

[kdougherty]

Hi All

Very  green here so go easy on me.

I am using the Leave Request template and trying to convert it over to using sharepoint lists, rather than one drive excel file. Maybe I am missing something, but it seems without loading the data necessary to track these values over time is useless since they are gone after app is closed. 

I have connected a sharepoint list with all of the necessary columns. I want to edit the "On Start" so that the ClearCollect loads data from the sharepoint list rather than inserting values manually. How do I accomplish this. See attached as reference. 

OnStartBalance

Instead of the numbers and text manually inserted here how do I insert the values from my sharepoint list that is tracking this data. FYI I already have most of the patching functions working so the data is posted to the list on approving. But I haven't figured out loading it on app start. Thank you!

[WarrenBelz · Accepted solution]

Hi @kdougherty ,

That is why the columns are not lining up. SharePoint retains the original column names when they are referenced from Power Apps.
I would suspect Employee_Name actually should be Title. If you go back to the SharePoint List Settings and hover over the field name, the original name is at the end of the string at the bottom of the screen.

Once you have dealt with these we will see if any other errors need attention.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up

[kdougherty]

I figured that was the reason but just wanted some proof. Thanks for that tip on how to check the original names! I should be good to go, thanks for all your help.