Overview:
The user picks say "IT" from the "Departments" dropdown then the next dropbox only shows the relevant "Job Titles" (based on the previous selection).
Then the "submit" button patches the data to the "main" SPList.
What I've got so far:
I have a “Patch” function that updates a Sharepoint List, which works (firstname, lastname etc up until "Department and Job Title)
AccountMaintenance-01-StaffOnboarding-Main_v2
Departments and Job Titles are taken for this 2nd SPList:
AccountMaintenance-01-StaffOnboarding-JobTitleSupport
So here is my "Patch" funtion currently, its on the OnSelect property of a button (I commented out Department as throws up an error but thats what I'm working with)
Patch(
'AccountMaintenance-01-StaffOnboarding-Main_v2',
Defaults('AccountMaintenance-01-StaffOnboarding-Main_v2'),
{
RequestID: txtRequestID.Value,
'First Name': txtFirstName.Value,
'Last Name': txtLastName.Value,
'Personal email address': txtPersonalEmail.Value,
'User Role':dropUserRole.Selected
//Department: Text(dropDepartment.Selected.Value)
}
)
Department does appear in the powerapp dropdown by using the following in the "Item" property but "JobTitles" isnt smart/dynamic
'AccountMaintenance-01-StaffOnboarding-JobTitleSupport'.Departments
Any ideas?
- I was also hoping that if the user picks say IT from the "Departments" dropdown then it then only shows the "Job Titles" relevant to that previous selection.
- Then the "submit" button patches the data from the 2nd list to the "main" SPList.
I'm pretty new to powerapps, when googling this problem I can only see writing data to two or more SPLists not take data from two and write to one.
Thanks for any advice or suggestions.
(I'm using the modern controls, not sure if that makes a difference or not)
