Unanswered

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

I have the same question (0)

All responses (4)

Answers (1)

Verified answer

mmbr1606 14,605 Super User 2025 Season 2 on at

Like (1)

Report
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

Was this reply helpful? Yes No
Jette 15 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Jette 15 on at

Like (0)

Report

Hi @mmbr1606
Solved my issue using you suggestion
Thanks for your support 👍

Was this reply helpful? Yes No
mmbr1606 14,605 Super User 2025 Season 2 on at

Like (0)

Report

great,

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

Was this reply helpful? Yes No