Hello,
Scenario:
- 2 Sharepoint lists: "MAINLIST" and "PICKLISTS"
- They have columns in common ("Description" and "Test")
- Gallery Items set to "MAINLIST"
- Dropdown control within Gallery
- Dropdown Items set to:
Filter(
PICKLISTS,
And(
Description = ThisItem.desc,
Test <> ThisItem.test
)
)
- Works like a champ!
Need:
- To add a blank option to the Dropdown Items
Do NOT need:
- The Default property to be blank (I already know how to do that with "AllowEmptySelection")
- I need the blank option so user can revert their selection
Any ideas?
Thank you

Report
All responses (
Answers (