You’re offline. This is a read only version of the page.
Announcements
9
Hi,
After getting good help from a YouTube video I managed to make cascading dropdowns in 3 levels. This is for registration of products and in my SharePoint list "Produkter" I have Title (Kategori), 'Produsent' and 'Modell'.
I'm now adding a new column in my SharePoint list 'Produkter' - new field called 'Active' with true/false. The purpose is obviously to set old products to 'inactive'/false and filter them out to make the dropdown list shorter.
This is the Items code for the first dropdown as is;
Ungroup(
Table(
{Value: Blank()};
{Value: Distinct(Produkter;Title)}
);
"Value"
)
How can I incorporate filter that is not showing items in SharePoint list 'Produkter' where Active=false?
I hope any of you clever minds out there can help. Thanks in advance!
Hi @Trema99 ,
As you mentioned the Active column are with true/false values, I assume it is a Choices column. So you can modify the Items formula to:
Share
Report
All responses (
Answers (
Ungroup(
Table(
{Value: Blank()};
{Value: Distinct(Filter(Produkter;Active.Value = "true");Title)}
);
"Value"
)
But if the Active column is Yes/No type, formula should be:
Ungroup(
Table(
{Value: Blank()};
{Value: Distinct(Filter(Produkter;Active = true);Title)}
);
"Value"
)
Hope this helps.
Best regards,
Community Support Team _ Jeffer Ni
If this post helps, then please consider Accept it as the solution to help the other members find it.
