Answered

Filtered lookup field in PowerApps not saved to SharePoint list

(0) Share

Report

Posted on by Jette

Have a SharePoint list named "NewHire", with a dropdown column "EmployeeType" and a lookup column connected to a list named "NewHireSchedule".

NewHireschedule have a "Title" and EmployeeType column.

In PowerApps when selecting "Onshore" in the "Employee type" (datacardvalue18) a filter is added to the "Schedule" field which filtering the NewHireSchedule list to only show the the title depending on the selection for the "Employee type". This it is working fine.

Filter(NewHireSchedule,DataCardValue18.Selected.Value = EmployeeType).Title

My problem is that the selected data will not be saved in the NewHire list. So when opening the form after saving field is

What to do to get the data saved?

Categories:

Building Power Apps

All responses (4)

Answers (1)

Sort by

Verified answer

mmbr1606 14,629 Super User 2026 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!
how do you save the data?

you can try something like this:

Patch( NewHire, Defaults(NewHire), // Use for creating a new item, or specify an existing item to update { Title: TextInputTitle.Text, // Assuming you have a title field EmployeeType: DataCardValue18.Selected.Value, NewHireSchedule: { '@odata.type': "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference", Id: DropdownSchedule.Selected.ID, // Assuming your dropdown is named DropdownSchedule and it has the ID of the selected schedule Value: DropdownSchedule.Selected.Title // This line might not be necessary depending on how your list is set up } } );

you would need to rename a few things here

Let me know if my answer helped solving your issue.

If it did please accept as solution and give it a thumbs up so we can help others in the community.

Greetings
Jette 15 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @mmbr1606, thanks for quick response

I am not using the Title
Below my settings for saving the form
Patch(
NewHire,varformdata,
UserInfo_Form.Updates,
Employment_form.Updates,
HRdata_form.Updates,
Hardware_form.Updates,
AccessComment_form.Updates
);

It is on the employmen_forms i have the Lookupfiels
Jette 15 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @mmbr1606
Solved my issue using you suggestion
Thanks for your support 👍
mmbr1606 14,629 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

great,

make sure to mark an answer as solution so others know its solved and people with similar issues can find the right solution 😉