Hi @joef ,
Do you want different users get different fields in form?
1)Manager: "X", "Y", "Z" columns (New Item)
2)IT member: "A", "B" columns (Edit Item)
3) Sales Audit :"C", "D" columns (Edit Item)
Could you tell me
1)if the user is not a manager, what will happen when he opens a new form?
2)if the user is a manager, what will happen when he opens an edit form?
I assume that in these two situations, he would not be able to open the form.
I've made a similar test for your reference:
1)create a list with people information data (listA)
position(text type) employee(single person field)
2)customize your SPO list's form (listB):
connect this form with listA and listB
insert three screens(Screen1,Screen2,Screen3)
In screen1, insert an edit form(Form1), set its data source to this list, choose "X", "Y", "Z" columns in this form.
In screen2, insert an edit form(Form2), set its data source to this list, choose "A", "B" columns in this form.
set form2's Item:
SharePointIntegration.Selected
In screen3, insert an edit form(Form3), set its data source to this list, choose "C", "D" columns in this form.
set form3's Item:
SharePointIntegration.Selected
3)set SharePointIntegration
OnNew:
If(User().Email in Filter(listA,position="Manager",employee).Email,
Navigate(Screen1);NewForm(Form1)
)
OnEdit:
If(User().Email in Filter(listA,position="IT member",employee).Email,
Navigate(Screen2);EditForm(Form2),
User().Email in Filter(listA,position="Sales Audit",employee).Email,
Navigate(Screen3);EditForm(Form3)
)
OnSave:
If(User().Email in Filter(listA,position="Manager",employee).Email,
SubmitForm(Form1),
User().Email in Filter(listA,position="IT member",employee).Email,
SubmitForm(Form2),
User().Email in Filter(listA,position="Sales Audit",employee).Email,
SubmitForm(Form3)
)
OnCancel:
ResetForm(Form1);ResetForm(Form2);ResetForm(Form3)
Then different users will open different forms.
Best regards,
