web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Power Apps - Building Power Apps
Unanswered

Lookup Lists Values not Being Saved to SharePoint List

(0) ShareShare
ReportReport
Posted on by 59
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.
 
Categories:
I have the same question (0)

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Tom Macfarlan – Community Spotlight

We are honored to recognize Tom Macfarlan as our Community Spotlight for October…

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 829 Most Valuable Professional

#2
developerAJ Profile Picture

developerAJ 489

#3
Michael E. Gernaey Profile Picture

Michael E. Gernaey 395 Super User 2025 Season 2

Last 30 days Overall leaderboard