Form dropdown not passing value to lookup column

(0) Share

Report

Posted on by MateiC

On a SharePoint site I have several lists, below with their columns:

DEPARTMENTS

Department

ROLES

Department (lookup from DEPARTMENTS)

Role

APPROVERS

Department (lookup from DEPARTMENTS)

Role (lookup from ROLES)

Name

E-mail

For APPROVERS I edited the form, and replaced the Role default combobox with a cascading dropdown that filters ROLES by the APPROVERS.Department value and grabs ROLES.Role from the resulting table.

In the APPROVERS.Role default card I changed the Update field to Dropdown.Selected. The problem now is that when a new item is added to the APPROVERS list, the Role dropdown doesn't pass the value to the Role list column, the field stays blank.

PowerApps doesn't show any errors anywhere in the form setup, what could be stopping the Role column from accepting the Role dropdown value? Could it have anything to do with the fact that the Role column was created as a Lookup type?

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Sort by

v-micsh-msft Microsoft Employee on at

Like (2)

Report
Copy link

Link copied!
Hi @MateiC,

Yes, you are hitting the point.

The issue you encountered should be relatd to the lookup type.

Read more here:

Defining default values for Comples SHarePoint type in forms

You need to update the Update Porperty of the DataCard with the following schema, for single value DataCard, the formula under the Update property should be:

Lookup(Choices(APPROVERS.Role), Value=Dropdown.selected.Value)

For Multiple Value enabled field, the formula should be:

Filter( Choices(APPROVERS.Role), Value in Combox.SelectedItems.Value)

Let me know if this works for you.

Regards,

Michael

Was this reply helpful? Yes No
Verified answer

MateiC 48 on at

Like (0)

Report
Copy link

Link copied!
I ended up changing all lookup types to text types throughout the site, because:
As far as I've found I cannot create dependent dropdowns to be used within a list's Quick Edit mode, to mirror the dependent dropdown manually added to the new/edit form
Using Microsoft Flow with these lists, I kept having issues with OData filtering for columns that were lookup types

Thank you for confirming the issue, and your solution looks like the correct way to go. I'll come back to this in case I ever need to stick with lookup types in the future.

Was this reply helpful? Yes No