Lookup columns not updating when submitting form

[Anonymous]

I'm following Reza's instructions here --> https://www.youtube.com/watch?v=IWEQwGLcW7Q&t=190s , but having all sorts of trouble.

I have two LOOKUP columns in a Sharepoint list called Master List, one named Functional Area and one called Sub-Functional Area. The source for the Functional Area and Sub-Functional Area columns is named Cascading List. In the Cascading List, Functional Area is named Title, and Sub-Functional is called Sub-Functional Area.

The names of the dropdowns on my form are FunctionalAreaDropDown and SubFunctionalAreaDropDown.

The Items property for FunctionalAreaDropDown is Choices([@''Master List'].FunctionalArea)

The Items property for SubFunctionalAreaDropDown is Filter('Cascading List', Title = FunctionalAreaDropDown.Selected.Value)

The Update property for SubFunctionalDataCard is SubFunctionalAreaDropDown.Selected.'Sub-Functional Area'

In Reza's video for SubFunctionalAreaDropDown item properties he uses VALUE after Title. For example, Filter('Cascading List', Title.Value = FunctionalAreaDropDown.Selected.Value) but if I add Value after Title, I get an error. I'm not sure if that's related or not. As is, the dropdowns work, but when I submit the form my Sharepoint list doesn't update their values.

Also, I'm really confused by the fact that there are two lookup columns in the Master List, yet for FunctionalAreaDropDown's Item properties it points to the Master List while the SubFunctionalAreaDropDown points to the Cascading List. It seems like either both of them would point to the Master List or Cascading List. Either way, I've tried both ways to no avail. Any help would be greatly appreciated.

[WarrenBelz · Accepted solution]

Hi @Anonymous ,

One of the many issues with SharePoint Lookup columns is when you start changing the Items of a control writing back to it, you lose the Id table field (which is the ID of the record being looked up in the other list. You will have other restrictions with this field type (for instance you cannot sort by them in a Delegable manner) and I have never found the need to use them at all. But back to your issue - the Update of the Data Card

{
   Value: SubFunctionalAreaDropDown.Selected.'Sub-Functional Area',
   Id: 
   Lookup(
      YourLookedUpList,
      YourLookedUpField = SubFunctionalAreaDropDown.Selected.'Sub-Functional Area'
   ).ID
}

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

MVP (Business Applications)   Visit my blog Practical Power Apps

[Anonymous]

I appreciate the quick response! Unfortunately, I can't get it working. I'm confused by what the Lookup function is doing. The code is fine until the comma. I get to --> Lookup('Cascading List', <-- it doesn't find any column. I tried a different datasource as well. I'm confused about what the Lookup function is doing so I'm not sure where to start troubleshooting.

EDIT: To clarify a little bit, I assume by "YourLookedUpList" you're referring to the "Cascading List" in Sharepoint and "YourLookedUpField" you're referring to the column name in said Sharepoint List.

[WarrenBelz]

@Anonymous ,

You need to look at the List Settings of 'Master List' in SharePoint and see what list and field it is looking up. I do not know your list names, but if you are looking up 'Cascading List' then yes - that is exactly what you need to do. If you have not already, you need to add 'Cascading List' to your data sources.

[CarlosGarciaM]

Hi, your solution worked perfect for me, putting in the Update Field your formula addapted to my needs, but I just realized later that my Datacard Required Field that is True is not working properly as it allows to submit the form even if it's empty, any suggestion ?, I assume that I need to add a statement in my Required or Update Field !?