Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
Anonymous
Not applicable

Data validation to flag blank rows in a column

Hi Everyone,

 

Im wanting to know if its possible to flag all the rows from a certain column that are blank and email a list of all these rows to be looked over by admin

 

Happy to incorporate power automate if its possible on there 

 

I'm quite new to powerbi but if there is a solution can i see images of how to do this 

 

Thanks !!

2 REPLIES 2
amitchandak
Super User
Super User

@Anonymous , You can create visual where you can check using visual level filter is blank and can use power automate to share result

 

if you need a column then you can create one like

COlumn 2

= if (isblank( [Column1]),1 ,0)

Anonymous
Not applicable

Hi, thanks for responding!

 

Will any visual work? How is powerautomate applied to the visual? 

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel1

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.