
Announcements
Hi,
I am building a canvas app. I have a "final total" field that is a choice column (1,2,3,4,5,etc) in my SharePoint list. I am trying to get the default selected items of this field at the very end of the process to populate based upon several managers responses. For example, if the first manager concurs with the employees point value they have entered and then the next manager up also concurs with the employee then the default result of the field/combo box should be the employees value. So, say an employee goes in and says they want 3 points, manager A says yes, I concur with that, manager B also says yes, I concur with that, but manager C says no I only want them to have 2 points, then the final point value would be 2, not 3. I am trying to write up an if statement for this as each manager has the ability to concur with the employee or to only partially concur and enter their own value.
This is the code I have currently in the default selected items -
hey @kat7777777
can u try this in your combobox defaultselecteditems property please:
DefaultSelectedItems property of your 'final total' ComboBox:
If(
DeptManagerApprove.Text = "Concur with Division Manager",
DivisionManagerPoints,
If(
DivisionManagerApprove.Text = "Concur with Branch Manager",
BranchManagerPoints,
If(
BranchManagerApprove.Text = "Concur with Employee",
EmployeePoints,
BranchManagerPoints
)
)
)
Let me know if my answer helped solving your issue.
If it did please accept as solution and give it a thumbs up so we can help others in the community.
Greetings