lookup datacards not saving on sharepoint list

[mohd1978]

I have a SPO list with several columns. in this SPO list I have a couple of columns as a lookup columns from another list

the form mode set to new. 

and I have a submit button to create new items and save it to the main SPO list. when I click submit the data doesnt save the lookup columns.

Main list called: Progression tool. 

lookup list called: progression lookup. 

the Onselect property on the button have a patch: 

Patch(
'Progression Tool',
Defaults('Progression Tool'),
{
Facility: DataCardValue1_2,
'Employee Name': DataCardValue13_1,
'PROGRESSION TYPE': DataCardValue2_2,
'Certificated Date': DataCardValue11_1,
'Employee Supervisor': DataCardValue15_1
}
);

is there anyways to make it work and save the data.

[LaurensM]

@mohd1978,

Am I correct that Progression Type in the 'Progression Tool' list is a LookUp to the Progression LookUp list?

In this case I forgot to mention 1 adjustment in the Items property (remove .'PROGRESSION TYPE':

Filter('Progression Lookup', Facility = DataCardValue1_2.Selected.Value)

The display column can be chosen via the right property panel after selecting the dropdown (in my case the column called Value):

Update property of the Datacard should then allow:

//The Value column depends on the selected column within SP (see column settings & change accordingly)
{Id: DataCardValue2_2.Selected.ID, Value: DataCardValue2_2.Selected.'PROGRESSION TYPE'}

[mohd1978]

The list saved the data as below. but it didn't show the facility.

[LaurensM]

Ok that part works, that's good! 😊

Did you also change the items property for the facility dropdown? We may have to perform a similar change if so.

[mohd1978]

I have this on it because I wanted to filter the progression type based on the facility

Distinct('Progression Lookup', Facility) 

example:

Facility xx have progression type xcn, hgf, fdg

and when I select XX i need it to show only those selection

[LaurensM]

@mohd1978,

Since Progression Type already points to a record within that list, I don't think an additional LookUp column for Facility is needed. A text field would be more beneficial if facility is only used as a display field - you could build custom dropdown logic within the form.

Should you want to keep it as a LookUp field, we will need a similar Update structure as previously. In this case the Update property of the Facility DataCard will reference the Selected values of your progression type dropdown.

Since a facility can have multiple progression types, we want to make sure we link the correct record to that Facility LookUp field:

{Id: DataCardValue2_2.Selected.ID, Value: DataCardValue2_2.Selected.Facility}

I hope this helps!

[mohd1978]

I got confused now. what should I use for the facility dropdown on its item property?

 do I use 

Filter('Progression Lookup', Facility = DataCardValue1_2.Selected.Value)

or 

Filter('Progression Lookup', Facility = DataCardValue1_2.Selected.Value)

Because if I'm using this, I get an error.

[mohd1978 · Accepted solution]

Progression Type 

Item: Filter('ATC Progression Lookup', Facility = DataCardValue1_2.Selected.Facility)

Update: {Id: DataCardValue2_2.Selected.ID, Value: DataCardValue2_2.Selected.'PROGRESSION TYPE'}

Default: ThisItem.'Progression Type'

Facility:

Item: Filter('ATC Progression Lookup', Facility = DataCardValue1_2.Selected.Value) got an error .

Update: {Id: DataCardValue2_2.Selected.ID, Value: DataCardValue2_2.Selected.Facility}

default: ThisItem.Facility

Correct me 

When Facility is chosen the progression type should show what it is related to that facility in the lookup list

[LaurensM · Accepted solution]

@mohd1978 

The Distinct function should remain as your Facility Items property. The Update property looks ok. 😊

[mohd1978]

I Appreciate your help. Thanks. It worked fine. 

Now I will be doing the flows lol