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

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.



@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

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

365 EduCon 768x460.png

Microsoft 365 EduCon

Join us for two optional days of workshops and a 3-day conference, you can choose from over 130 sessions in multiple tracks and 25 workshops.

Users online (4,535)