Sharepoint list column not updated from filtered combobox

[fransk]

Good Day,

I will appreciate any help on this as I have really tried all combinations. I have 2 lists, Leave Application and TestEmployees

I have a Card called Plant with DataCardValue18

DefaultSelectItems = Filter(TestEmployees, 'Employee Number'= DataCardValue2.Text).'Personnel subarea'

Default = ""

Items = ""

Update = DataCardValue18.Selected

The value in Plant is populated when an Employee number (DataCardValue2) is filled in but the value is not saved back to my Sharepoint List (Leave Application). My Sharepoint where I want the value saved is a lookup column.

Looking forward to any response.

Regards

[RandyHayes]

@fransk 

You are going to need something for your Items property on the DataCardValue18.

Based on your DefaultSelectedItems, I would assume it should be TestEmployees.

Once you have that, set the Update property of your DataCard to the following formula:

{
     Value: DataCardValue18.Selected.Title,
     Id: DataCardValue18.Selected.ID,
     '@odata.type': "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference"
}

That should give you updates to the SharePoint list if your column is a Lookup Column.

I hope this is helpful for you.

[fransk]

Hi @RandyHayes 

Thanks for your replay

I have done what you have suggested but then my Plant Datacard displays all whole lot of values. I just want one to show. And it still does not save the Plant info into the SP column field.  See screenshot.

Regards

[RandyHayes]

@fransk 

Can you explain more about why you would have a ComboBox then for your value if you only want one item to show?  Is there not a "New" record point at which someone needs to Choose the value that then becomes associated with the record? Or is it simply that once someone selects a value in DataCardValue2 that whatever the lookup is from TestEmployees then becomes the subarea value?

Sorry to not understand completely, but whatever context there is for what you are trying to do would be helpful in determining the solution. 

And to be clear - your Plant info column in SharePoint IS a Lookup?  And it is a Lookup to the TestEmployees list?  And that the "in this column" defined in the lookup is "Title"?

Please clarify anything that is incorrect.

[fransk]

hi @RandyHayes 

Or is it simply that once someone selects a value in DataCardValue2 that whatever the lookup is from TestEmployees then becomes the subarea value? - Correct

And to be clear - your Plant info column in SharePoint IS a Lookup? - Correct, see screenshot

And it is a Lookup to the TestEmployees list? - This column was created before the TestEmployee list came into play. Where would I see where the lookup is done to. We want to update the Plant column in the Leave List from the DataCardValue18.

And that the "in this column" defined in the lookup is "Title"? - Correct

[RandyHayes]

@fransk 

Go into the SharePoint list and then go into the List Settings.

Click on the Lookup Column you have and then send a screenshot of the definition. Specifically the List it does the lookup on and the "in this column" definition. 

[fransk]

@RandyHayes 

I see it the "Get information from" is set to another list called Plants. Screenshot attached.

The Data for DataCardValue18 is set to ["Plant"]. 

[RandyHayes]

@fransk 

Okay...so then we need to derive from Plants not TestEmployees for the value.

BUT...before we get to that, let's revisit your use of a ComboBox for this.  Do you ultimately even need to display this DataCard to your users?  If the value is only one and only dependent on the Value that is entered in DataCardValue2...is there any need to display it?

Next, The "Personnel subarea" column in the TestEmployees list...does that value that is in that column Match the values that are in the Plants list Title column?

We need to derive a path back to the Plants list from your LeaveApplication (I assume that is the primary list that we are working with - and I assume that the Lookup Column in the list is from LeaveApplication - please clarify if not correct)

[fransk]

Hi @RandyHayes 

BUT...before we get to that, let's revisit your use of a ComboBox for this.  Do you ultimately even need to display this DataCard to your users?  If the value is only one and only dependent on the Value that is entered in DataCardValue2...is there any need to display it? - Yes they would like to see it on the Powerapps form

Next, The "Personnel subarea" column in the TestEmployees list...does that value that is in that column Match the values that are in the Plants list Title column? - No they are different

We need to derive a path back to the Plants list from your LeaveApplication (I assume that is the primary list that we are working with  and I assume that the Lookup Column in the list is from LeaveApplication - please clarify if not correct) - Correct

[RandyHayes]

@fransk 

Yes they would like to see it on the Powerapps form 

But do they need to see it in a one value Combobox?  Or can you just add a Label that would display the Value?

No they are different

So then I need to understand more about your lists - as I see it you have 3 lists - LeaveApplication (I assume this is the primary list that we are trying to add records to), TestEmployees (not really sure how this fits in), and Plants (which has the value we want to put into the primary list column.

The question will be - what in the record being added to the LeaveApplication would indicate what Plant to look up?