Answered

Issues with request leave power app

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hi,

When I load the app it asks me to make the app my own, I then accept the app permissions and then link it to One drive for business, I have given permissions to everyone on the folder and data file for this app but I get the following error messages ( see attached photo). I have not changed any of the code from the orignal template.

I have tried deleting the data source and readding the data source.

Categories:

Building Power Apps

All responses (5)

Answers (1)

Sort by

Pstork1 69,665 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!

Look at the errors in the App checker. As I remember when creating an App from this template it doesn't create a connection to the Office365Users connector. That is required by a lot of the code in the app. If you didn't add a DataSource for Office365Users then that is your first issue. As I remember that takes care of about 78 of the 80+ errors. Work through fixing all those errors and it should work.
Verified answer

v-xida-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Anonymous ,

It is an known issue with the Leave Request Template app in PowerApps. The user @LKinsman has faced same issue with you, please check my response within the following thread:

https://powerusers.microsoft.com/t5/Creating-Apps/OnStart-not-firing-Leave-Request-template/m-p/289088

When you create your own app based on the "Leave Request" template app via clicking the "Make my own app" button, the Office 365 Users data source and Office 365 Outlook data source would be missing/lost from your app after you re-load your app.

On your side, you need to re-add your Office 365 Users connection and Office 365 Outlook connection as data source within your app, then re-publish your app, re-load it, check if the issue is solved.

Best regards,
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi,

This resolved some of the errors.

Thanks

Ashley
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

@v-xida-msft wrote:
Hi @Anonymous ,
It is an known issue with the Leave Request Template app in PowerApps. The user @LKinsman has faced same issue with you, please check my response within the following thread:
https://powerusers.microsoft.com/t5/Creating-Apps/OnStart-not-firing-Leave-Request-template/m-p/289088

When you create your own app based on the "Leave Request" template app via clicking the "Make my own app" button, the Office 365 Users data source and Office 365 Outlook data source would be missing/lost from your app after you re-load your app.
On your side, you need to re-add your Office 365 Users connection and Office 365 Outlook connection as data source within your app, then re-publish your app, re-load it, check if the issue is solved.

Best regards,

Hi,

Thank you, this solved the issue with the manager issue and the email sending issue.
I am looking on how to link up the app to the excel sheet it creates. As I have published the app but requests are not saving in the excel sheet, i have been trying to find the setup steps needed to do this but i can not find anything that helps/works, can you help with that @v-xida-msft ?

Thanks

Ashley
v-xida-msft Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @Anonymous ,

Actually, the Leave request you submitted through this template app is not stored within the Excel table in your OneDrive folder. Instead, the Leave request you submitted would be saved into the LeaveCollection collection within this app.

If you want to save your Leave request into a Excel table instead of the collection, you need to create your own Excel table in your cloud service (e.g. OneDrive), and your Excel table must contain the following columns:

Title Detail StartDate EndDate LeaveType Approver Status Requester LeaveID

then within your app, create a connection to the new created Excel table.

Please check the solution I provided within the following thread for more details:

https://powerusers.microsoft.com/t5/General-Discussion/Power-App-Template-Leave-Request-integration-into-Excel-OneDrive/m-p/266637

Please take a try with above solution, then check if the issue is solved. If you have solved your problem, please go ahead to click "Accept as Solution" to identify this thread has been solved.

Best regards,