Hello Team,
I have one requirement, which is something like that, suppose you have 3 projects under your name and for one of those three project you want to edit something may be role, skill or bandwidth of the resources, suppose from my list you have selected that project and then you'll be navigated to the screen where resource details are available, so in that for A resource you want to edit the availability or bandwidth of the resource, for example for the month of april 24 you need resource 100% but after some days may be you only need the resource bandwidth for 80% only. So you'll go to my list and will click on the project and the you can change. I have added two buttons, one for edit and one for update. I am pasting the code for better understanding for everyone,
On Edit button - (On select)
Set(
Var_Emp_Role,
(Gal_Emp_Details.Selected.Role)
);
Set(
Var_Emp_Skill,
(Gal_Emp_Details.Selected.Skill)
);
Set(
Var_Apr_24,
Text(Gal_Emp_Details.Selected.'Apr-24')
);
Set(
Var_Jan_24,
Text(Gal_Emp_Details.Selected.'Jan-24')
);
Set(
Var_Feb_24,
Text(Gal_Emp_Details.Selected.'Feb-24')
);
Set(
Var_Mar_24,
Text(Gal_Emp_Details.Selected.'Mar-24')
);
Set(
Var_May_24,
Text(Gal_Emp_Details.Selected.'May-24')
);
Set(
Var_Jun_24,
Text(Gal_Emp_Details.Selected.'Jun-24')
);
Set(
Var_Jul_24,
Text(Gal_Emp_Details.Selected.'Jul-24')
);
Set(
Var_Aug_24,
Text(Gal_Emp_Details.Selected.'Aug-24')
);
Set(
Var_Sep_24,
Text(Gal_Emp_Details.Selected.'Sep-24')
);
Set(
Var_Oct_24,
Text(Gal_Emp_Details.Selected.'Oct-24')
);
Set(
Var_Nov_24,
Text(Gal_Emp_Details.Selected.'Nov-24')
);
Set(
Var_Dec_24,
Text(Gal_Emp_Details.Selected.'Dec-24'))
On Update button (on Select)
If(
Var_Edit_Col,
Patch(
Col_Emp_Details,
LookUp(
Col_Emp_Details,
Sl_No = Gal_Emp_Details.Selected.Sl_No
),
{
'Resource Name': 'Employee Name_Combo'.Selected.Name,
'Employee ID': 'Employee_Id Card'.Text,
'Line Manager': Manager_Combo.Selected.Value,
Role: Var_Emp_Role,
Skill: Var_Emp_Skill,
'Start Date': 'Start Date'.SelectedDate,
'End Date': 'End Date'.SelectedDate,
'Jan-24': Var_Jan_24,
'Feb-24': Var_Feb_24,
'Mar-24': Var_Mar_24,
'Apr-24': Var_apr_24,
'May-24': Var_May_24,
'Jun-24': Var_Jun_24,
'Jul-24': Var_Jul_24,
'Aug-24': Var_Aug_24,
'Sep-24': Var_Sep_24,
'Oct-24': Var_Oct_24,
'Nov-24': Var_Nov_24,
'Dec-24': Var_Dec_24
This col_Empl_Details is to store the employee details in the gallery.
Please let me know what to modify in these codes to start working this functionality, its urgent please help.
Thanks in advance everyone!!
