Showing results for 
Search instead for 
Did you mean: 
Helper IV
Helper IV

Update Leave balance - Leave Request App


I am working on a leave request app, data source is sharepoint. I have two two data source Leave request and BalanceLeave. 



In the app on New Request Form i would like to show the user their Current Balance, New Balance, Leave Applied.


I have a screen My Leave Balance Which is connected to BalanceLeave SP, I do not know how to achieve this, Please help me display Current Balance, New Balance and Leave Applied for logged in user and update the values in My Leave Balance screen. Thank you.

Super User
Super User


@VikasNagaraj wrote:


I have a screen My Leave Balance Which is connected to BalanceLeave SP

A data source is not connected to a Screen. All Screens have access to all data sources.


@VikasNagaraj wrote:

update the values in My Leave Balance screen. Thank you.

You would not update the values of a Screen. Instead, from any screen, you can access either data source from any control. 


For your scenario, it is either the data source itself (Patch and/or SubmitForm), or even just a Variable (Set) that you might really need to be updating. 


What i actually ment was My Leave Balance screen has a gallery, which is displaying information from a sharepoint called BalanceLeave.


and i want to display Current Balance, New Balance and Leave Applied to users on new request screen. how do i do this ?


I do not know how to achieve this, also after they submit request, i want to display their new balance on My Leave Balance screen, is there a way to do this? if so please help. Thank you.

@VikasNagaraj From any control on My Leave Balance Screen - (for now you can test it with just a simple Label and the Text property of this Label, for instance) - just do something like this:








For YourGallery put your Gallery's name.

For YourColumnName put the name of your column.


Check if above helps as a starting point.


I tried it and i have this error. 






Does above work instead?


No, it does not work.





LeaveType is a Choices field, so 




 should be working.


1. Are you trying this formula on the Text property of a Label, or on something else?

2. Is there an item selected right now from that Gallery?

3. If you are trying to select it from the other Data Source, you need to make sure the other Data Source has the corresponding Record selected first, such as by a Lookup or some other means.


I was using label before as well, I deleted the label, placed it again and it is displaying properly now.






I think it is because the Label you were changing was inside of a Gallery and when you placed it again, you placed it outside of the Gallery - so that might be why you had the issue you were facing before. 

Helpful resources

PA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.

Microsoft Build 768x460.png

Microsoft Build is May 24-26. Have you registered yet?

Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.

May UG Leader Call Carousel 768x460.png

What difference can a User Group make for you?

At the monthly call, connect with other leaders and find out how community makes your experience even better.

Top Solution Authors
Top Kudoed Authors
Users online (1,595)