Share
ReportHi,
I have two sahrepoint list,
Employee_PF_Form and
Account_Office_Form, and I have also two forms on powerapp, Employee submits his request from emp form and it is saved emppf form list. When we process request from account office form the employee information is gathered from emppf list by using lookup function. the gathered information is from employee_PF form (
LookUp(Employee_PF_Form, Emp_Name=DataCardValue2.Selected.Emp_Name && Status.Value="New",Designation)), when we submit account form it should make record to account office form, and it should also set status to in-progress from new. We are using following formula in onselect property of submit(
SubmitForm(AccForm);
Notify("Form has been submitted successfully.", NotificationType.Success);
Patch(Employee_PF_Form, {ID: EmpForm.LastSubmit.ID}, {Status: {Value:"In-Progress"}});
//Patch(
// Account_Office_Form,
//{'Employee Name': DataCardValue2.SelectedText.Emp_Name}
//);
Notify(DataCardValue2.SelectedText.Emp_Name, NotificationType.Information);
//Patch(Employee_PF_Form, EmpForm.LastSubmit, {Status: {Value:"In-Progress"}});
NewForm(AccForm)
Categories:
I have the same question (0)
All responses (
Answers (
427
