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

Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Difinity Conference 2022

Difinity Conference 2022

Register today for two amazing days of learning, featuring intensive learning sessions across multiple tracks, led by engaging and dynamic experts.

European SharePoint Conference

European SharePoint Conference

The European SharePoint Conference returns live and in-person November 28-December 1 with 4 Microsoft Keynotes, 9 Tutorials, and 120 Sessions.

Power Apps Ideas

Changes to Ideas Coming

We are excited to announce a new way to share your ideas for Power Apps!

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