Unanswered

Leave Request Template Not Working

(1) Share

Report

Posted on by MattBowman

Hi,

PowerApps newbie here. I've been investigating PowerApps as a cleaner alternative to just using Sharepoint / Power Automate / Forms to manage annual leave requests.

Using the Leave Request template, turning it into my own app and checking the data connections (O365 Users, O365 Outlook) are functioning, saving and attempting to run the app gives a very broken experience.

All the navigation options to the left are missing, buttons to create new requests do not do anything and other screens are only accessible if the app is started on that particular screen.

The app checker shows 180+ errors:

I have tried saving and reloading the app, re-adding the data connections etc and nothing seems to be working.

Does anyone have any advice or solutions for this?

Categories:

Building Power Apps

I have the same question (0)

All responses (12)

Answers (0)

TheRobRush 11,128 Moderator on at

Like (2)

Report

we will need to see the errors to be able to help you resolve them.

Was this reply helpful? Yes No
MattBowman 11 on at

Like (1)

Report

Apologies, I thought I had uploaded an image containing details of some of the errors. Please see examples below.

These errors all appear immediately after doing the 'make your own version of this app' step and selecting OneDrive for Business and the appropriate data connectors. So I'm sure I'm doing something very basic or fundamentally wrong here.

Was this reply helpful? Yes No
TheRobRush 11,128 Moderator on at

Like (1)

Report

check whatever the Items property of the gallery - GalleryRequest & GalleryRequestDetails are. These sources either do not yet exist, or have not been properly added to the data sources of the app yet

Was this reply helpful? Yes No
MattBowman 11 on at

Like (1)

Report

Thanks, I'll look into that but I am a bit confused as none of the step-by-step guides that reference this template seem to encounter any of these errors.

I don't understand how 180+ things can break like that including all the in-app navigation.

Is this expected behavior for this Template immediately after going through the 'make your own version of this app' step? Every other thread or tutorial for this I see doesn't mention going through and correcting all these errors.

Was this reply helpful? Yes No
TheRobRush 11,128 Moderator on at

Like (1)

Report

Try removing these two connectors and readding them. Upon doing some reading through past issues on these forums it seems they may sometimes not set up properly in the initial setup. /Can/ result in the issue you are describing

Was this reply helpful? Yes No
cdrom1019 on at

Like (2)

Report

I've been trying to make and modify this app for my department and I am having the EXACT same set of issues. I have literally begged people on support forms to do what you did just to see if they could re-create this and confirm I'm not insane. Thank you so much for documenting this. I feel a little better knowing that I can probably remedy a lot of this by re-adding the data connectors, but I'm having my own set of internal company problems with those that we're working to correct.

Have you made any progress correcting the formulaic errors since this thread?

Was this reply helpful? Yes No
cdrom1019 on at

Like (3)

Report

Update 1. So I managed to brute force my way through a bunch of errors. I've got more but this is progress. I noticed when I was working on this template that I was missing a data sources button. Turns out, power apps depreciated some features a while back, so now I'm curious if the template was dependent on these being enabled.
But I enabled Improved Data Source Experience and Relational Data in advanced settings. Then I removed the sharepoint lists I was working with and relinked the data excel spreadsheet that came with the template via one drive. That knocked out over 100 formulaic errors. Going to see if I can brute force the rest of these.
Keep me up to speed with anything you find out please.

Update 2: Hey! I think I figured it all out. I managed to clear all the formula errors and got the thing working like I needed it to. I'm flat amazed. So take my advice and open 2 versions of this app, the power apps template and in another window, open the version you're modifying. This way you can compare your apples to apples and find changes in the code that don't make sense. After the nonsense with the data sources were figured out, I eventually realized a lot of the formula errors were caused by some small changes in the code. A lot of the datasets it was trying to pull from were suddenly showing as ICON.value instead of just value. Like ICON.Leave or ICON.balance.
If you remove ICON. from each of these, and use the app checker to point you to each one, the errors should clear up. Refresh the page when you've got all the formula errors cleared and the navigation options should show back up.

Was this reply helpful? Yes No
MattBowman 11 on at

Like (1)

Report

Outstanding effort! I'm going to give this a go as soon as I get the time to work on this again!
(also relieved to know that it wasn't just me doing something very fundamentally wrong and that the code for the template is in fact borked).

Was this reply helpful? Yes No
kyonettech 4 on at

Like (1)

Report

Thank you for your hard work with this! This resolved the issue for me. I also struggled to find documentation regarding this template so I was happy to come across this post. I'm curious to find out if you developed any further with this, perhaps including hours/half days as an option for requesters?

Was this reply helpful? Yes No
cdrom1019 on at

Like (2)

Report

I've dabbled with modifications to the template to meet some organizational needs, but haven't made any usable progress with them. I once thought I had the template converted to hours, and in a sense I did with the way PTO was being displayed and requested, but the math conversion wasn't correct, and I eventually realized that it would require an entire re-write of the formula the app is using to subtract days from the pool. I've also played with a few half day solutions but haven't gotten one properly implemented yet. I'm still working against some organizational traffic blocks with the connectors that I'm trying to get fixed internally, and then I can look into modifications again. Also need to figure out why my manager will get the emails but won't get any usable data when logging into the app as a manager.

Was this reply helpful? Yes No