I have two SharePoint lists:
| List | Column | Type |
| Tax Codes | Country/Region | Lookup |
| Name/Value | Value Type | Choice |
| Name/Value | Key | Text |
| Name/Value | Value | Text |
The Tax Codes-Country/Region column is a Lookup to the Name/Value list. This list has various entries used for lookups to other lists. SharePoint allows the selection of the list for the lookup but not specify a filter. Not a problem, I am building a custom Power App to handle data entry into the Tax Codes list.
Here's my problem. For the Country/Region column I am trying to change the Items property from the default of:
Choices([@'Tax Codes'].Country_x002f_Region)
to the following:
Filter( 'Name/Value', 'Value Type'.Value = "Country/Region" )
The Value Type column is a Choice column so it should understand the '.Value' property, but I am getting a 'Name isn't valid' error for the '.Value'. What am I doing wrong? I have done this hundreds of times before with no issues. Why is this a problem now?
Thanks.
