You’re offline. This is a read only version of the page.
Hey everybody
I have a sharepoint list with a few columns:
I have a form that is connected to another list where i use this in my Items property:
Share
Report
13,477Distinct(
Filter(
MyCollection,
Value(currentEditRole) = 1 ||
HeadofEntityEmail = User().Email
),
LegalEntity
)
There are also some entries where the Legal Entity is empty/blank.
Can i somehow exclude the blank option from my dropdown choices?
In this screenshot you see, that the second option is the blank value i want to remove:
Thanks in advance
Hi @mmbr1606
Adjust your filter to only get records where LegalEntity is not Blank:
All responses (
Answers (
Distinct(
Filter(
MyCollection,
(Value(currentEditRole) = 1 || HeadofEntityEmail = User().Email) && LegalEntity <> Blank()
),
LegalEntity
)If you have any questions or feedback, please let me know. Have a great day! 😊
-----------------------
PowerYsa Power Platform Enthusiast [LinkedIn] | [Youtube]
I love to share my knowledge and learn from others. If you find my posts helpful, please give them a thumbs up 👍 or mark them as a solution ✔️. You can also check out my [@PowerYSA] for some cool solutions and insights. Feel free to connect with me on any of the platforms above. Cheers! 🍻
Try adding this to the filter query:
!IsBlank(YOURVALUEHERE)
