cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ericonline
Community Champion
Community Champion

Determine if ANY column in collection IsBlank

Hello,

Need some community help here...

Scenario:

- DataSource:

  - Sharepoint list

  - 60-70 columns wide

- Collection (in-app):

  - 1 record from DataSource (again, 60-70 columns wide)

- Need:

  - Without naming each of the 60-70 columns in a formula, how can I determine if any of the columns are blank?

Thank you

 

2 REPLIES 2
leyburn19
Memorable Member
Memorable Member

Is that the whole column on all records or just the new record when created?

 

I use flow for the latter to send me an email if a critical column somehow failed to get the data it should have

 

That said,   I don't know of any way to do this without lists all the columns. 

timl
Super User
Super User

Hi @ericonline 

Although this isn't the greatest of solutions, perhaps you could convert your collection to JSON and search for a null?

For example, the formula here produces the output shown in the screenshot.

 

ClearCollect(colTest, {col1:"", col2:Blank(), col3:"Tim"});
Set(jsonText,JSON(colTest))

image.png

You could then call IsMatch against ":null," to test for blanks.

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Top Solution Authors
Users online (1,380)