Share
Report
364Hi All,
I have an app that manages goals set by employees and allows their manager to conduct a review for those goals. One column that gets looked at when a review happens is a choice column from Dataverse, called 'Achieved?'
Each employee has a maximum of 7 goals, and I am using the following code to bring the proper goal into the app:
If(goalFirst= true,
LookUp('Goal Managements',Goal=_goal1).Goal,
If(goalSecond= true,
LookUp('Goal Managements',Goal=_goal2).Goal,
If(goalThird= true,
LookUp('Goal Managements',Goal=_goal3).Goal,
If(goalFourth= true,
LookUp('Goal Managements',Goal=_goal4).Goal,
If(goalFifth= true,
LookUp('Goal Managements',Goal=_goal5).Goal,
If(goalGG1 = true,
LookUp('Group Goals', ID = _GGID1).Goal,
If(goalGG2 =true,
LookUp('Group Goals', ID = _GGID2).Goal)))))))'
This code brings in the title for the goal. I use it multiple times to grab other items like the goal description and the due date.
Each goal has a button next to it, which is what changes values like goalFirst and _goal1. Does anyone know how I can lookup the specific value for a choice-based column? I'd like the status of the goal to appear when a review is being conducted, so that a manager can mark it as completed if it has been. I will include an image of the code as well as the screen in my app.
After all goal items are verified, I collect the values from each field on the screen with collect, and then patch any changes to the original data source. I would like to do this with the choice column as well.
Does anyone have any suggestions for how I can achieve this?
All responses (
Answers (
