Announcements
I am trying to display all the users in O365 AD without having Surname or "" or empty string
Only active users with First name only
How to do that using power automate
in your filter query use
Surname eq null
Hello,
Already tried this equation like surname is equal to null but still keep showing the users without surname/empty string after generate the file into excel
Please help if any need to add or condition to fix my issue
I try to run again and the output still the same
It should be not display the users without surname or blank
I would just like to note that your question is related to cloud flows, but you posted it in the forum for desktop flows. Those are two different things. The correct forum to post questions like this is here: https://powerusers.microsoft.com/t5/Building-Flows/bd-p/BuildingFlows
Thanks I will repost it on the right forum
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
David_MA 258 Super User 2026 Season 2
trice602 198 Super User 2026 Season 2
11manish 136 Super User 2026 Season 2
