I have 3 lists
Goals - (Id, Title) - just a long list of goals Employees can select from
Employee Goals - (Id, Title (flow sets this value to the Name of the Employee - Title of the goal), Goal (Linked to Goals List), Employee (people picker)
Project - (Id, Title, (bunch of other fields), Employee Goal (Linked to Employee Goal).
For the drop down field (Goal) in the Power App I have this set to the items -
Sort(Distinct(Filter([@'Employee - Goals'],Employee.Email = User().Email),Title),Value,SortOrder.Ascending)
It displays the correct information, but does not save it when submitted.
I have the following set in the Update Property of the Card: "Goal.Selected"
For the OnSubmit I have SubmitForm(SharePointForm1).
The value of the selected Goal is not stored in the Project List when saved.
This seems too simple, what am I overlooking?
If I change the items to (Choices([@'Progress tracker list'].'Goal_x0020__x002d__x0020_Focus')) - I get the full list of Employee - Goals without a filter and it saves fine without any other changes.