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
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

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

MayPowerBICarousel

Power BI Monthly Update - May 2024

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