
Announcements
Hello,
I have the following Dropdown list from a Lookup Column, and I want to filter it based on the 'cr78b_PM'.Firma.Name = "Text12".
Hello,
Can you try something like that ?
Distinct(
Filter(
[@Projects],
cr78b_PM.Firma.Name = "Text12"
),
cr78b_PM
)
This formula will provide you with the choices for your dropdown list where the related record's Firma.Name field is equal to "Text12". Adjust the table and column names according to your data model.