
Hi guys,
I've seen a couple of people post about this but no answers that work for me.
I'm making a mock up of an asset manager check in check out system. I'm using the default SharePoint asset management list as a template. I want to have Manufactures in a drop down, but it is not showing up in the available fields. Everything bar choice type columns appear fine so it seems to be an issue with only them.
I am able to get manufacture to work by setting the items to
Choices("Asset Management".Manufacturer)but then I can't filter by model.
Any work arounds would be great.
Please see this article - How to Create Filtered Relational Drop-downs with Choices in PowerApps | Timlin Enterprises - SharePoint and Office 365 Managed Services
You can use an approach like this
Distinct(Filter(Datasource, ColumnName = "text"), ChoiceColumn.Value)
Regards,
Pat