Hi all,
I have created an app and version 1.0 is almost ready. But ... some small issue has to be solved, one of them is the functionality of a drop down box. This box is populated with data in an Exel sheet with transactional data. For example, someone is entering data in the Excel sheet, based on this data the drop down box is populated. In the drop down box the following syntax is used:
Concatenate(Source.Field1, " / ", Source.Field2)
But, not all unique combinations in this sheets needs to be part of data in the dropdown box, some of them are obsolete. This can be filtered by using Field3. Can this be combined? For example:
Filter(Concatenate(Source.Field1, " / ", Source.Field2), Source.Field3 <> "Yes")
Looking forward for a good trick.
Thanks in advance,
Gert
