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.
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.
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.
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.
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 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.
Join us for the next call on August 17, 2022 at 8am PDT.
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.