Filter a data card based off the pervious data card selection

[jjasper]

Hello, 

I am working on an app to collect number around COVID. I have a form that is attached to a SharePoint list. I have the first data card being populated based off who is signed in to enter the numbers. I am looking for a way that when the first data card (Village) is populated to a specific village the second data card will filter to only the options for that village. For more context we have many villages that have many neighbourhoods. I would like to be able to filter the neighbourhood data card to show only the neighbourhoods attached to that village as well as having the option to select non-specific neighbourhood. 

I am not even sure if this is possible but everything I have searched is giving me a hard code that if this is selected then this but I need it to have multiple options. 

E.g. If the first data card is showing Village 1 then the second data card (Neighbourhood) would show neighbourhood 1, neighbourhood 2, neighbourhood 3 etc. and non-specific neighbourhood. 

Hope this makes sense. 

TIA

[RandyHayes]

@jjasper 

Perfect!  Then by all means use that.

However...the fun is not over yet.  Since this is a Choice column in your list, you will need to make one change (didn't want to get into it before because we were just discussing a way to connect it).

You will need to set the Items property of the Dropdown to the following in order for your SubmitForm to submit the data properly back to the choice column:

ForAll(
    Filter(Neighborhoods, Village=DataCardValue14.Text),
      {
        Value: Neighborhood,
        '@odata.type': "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference"
      }
)

Change the "Neighborhood" specified above for the Value to the appropriate column name from your village/neighborhood list.  And then make sure the display field for your dropdown is set to Value (in the properties pane on the right of the designer).

This will observe the information that SharePoint needs in order to set the Choice column when you submitform.

[jjasper]

I have been working through but now I have run into an error. I am unable to put datacard.text, text is not an option. I have gone through the ones that I think it could be based on the options give but it doesn't show the second drop down. I may not be doing this right. 

Here is the code I am putting in: ForAll(
Filter('Neighbourhood List', Village = Village_DataCard9.Visible),
{
Value: Neighbourhood,
'@odata.type': "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference"
}
)

and I am putting this under the items for the neighbourhood drop down. 

There Neighbourhood List has Village, Continuum and Neighbourhood. 

[RandyHayes]

@jjasper 

You are referencing a visible property for your filter criteria - this is not going to work.

Your Formula on the Items property of the Neighborhood dropdown should be this:

ForAll(
    Filter('Neighbourhood List', Village = DataCardValue14.Text),
    {
        Value: Neighbourhood,
        '@odata.type': "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference"
    }
)

[jjasper]

When I put in text it is saying this name isn't valid. This identifier is not recognized. 

[RandyHayes]

@jjasper 

Have you changed your EditForm?  Originally you had a DataCardValue14 in your form.  That was the TextInput for the Village.

[jjasper]

Yes I changed the data card to drop down for the village. I now have Village as a drop down and Neighbourhood as a dropdown. It is better to go back to a text field? I am trying to ensure we get the most accurate data. I originally had a textbox for the Village and was auto populating that then I change it to a dropdown. 

[RandyHayes]

@jjasper 

No, that is fine.  But in the future, I would advise to simply change the control type from the Fields menu rather than pull the original out and add a dropdown separately.  PowerApps will change the control for you and avoid some of the hassle that you went through with all the errors that came up when you removed the textInput control.  And it will have set the default properties properly for what you will now have to do also.  🙂

So with that said - what is the Items property of the Village dropdown and what is the name of that control?  We need to adjust the formula to accommodate the values.

[jjasper]

The name of the control is datacardvalue132 and Village_Datacard9, and the Items is Choices([@'COVID Numbers'].Village). I do have the two tables. The Neighbourhood List list and the COVID Numbers list. 

[RandyHayes · Accepted solution]

@jjasper 

So somethings seem to have changed since the original post. 

Your Village column was originally a Text column.  Is that now a Lookup column or a Choice column in your SharePoint list?

And just to be clear - you have a DataCard called Village_Datacard9 and it has a control in it called datacardvalue132 which is a Dropdown control.

So if that is all accurate, then your Items formula for the Dropdown in the Neighborhood datacard should be: 

ForAll(
    Filter('Neighbourhood List', Village = datacardvalue132.Selected.Value),
    {
        Value: Neighbourhood,
        '@odata.type': "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference"
    }
)

[jjasper]

That worked!!! Thank you so much for your help!!!