I am currently trying to build a SharePoint Form in PowerApps to populate a SharePoint list.
For that I need a dropdown box which is dependent on another one to filter the items.
The first dropdown chooses the department and the second one is supposed to show you the rooms related to the selected department. So I created a master list with all needed columns and a second sharepoint list with two columns (department and room) to define which room is used by the departments. I also connected both SP lists in PowerApps.
To filter the second dropdown I am using this formula in the Item property:
Filter(roomslist; department = DataCardValue1.Selected.Value)
As Value property I picked 'room' and the dropdown menu works in PowerApps as I intended it to do.
After submitting the form I get a new entry in my sharepoint list and every field gets submitted correctly except the 'room' field which is empty.
It appears to me that even the form is filtering the dropdown correctly, I failed to make it submit to the sharepoint list...
I am quite new to PowerApps and would appreciate any kind of help.
