Unanswered

Detect blank fieds in a list and get the column name of the blank field

(0) Share

Report

Posted on by od2023

In a list, i don't manage with power automate to find blank fields and send the title of the row and the column name of the blank field in a email.

My list has a lot of columns so i am looking for an expression or function.

currently, apply each value and condition item() equals Null always replies false so my email is never sent (condition true)

Categories:

Building flows

I have the same question (0)

All responses (8)

Answers (0)

cmht 82 on at

Like (0)

Report

Hi @od2023
You are probably running your condition against an array, which will never be empty.
This is because you are using item()
You should use item()?['value'] -> to check the column, because now you are checking if the whole "row of columns" is empty. I am sure SharePoint disallows creating such empty entires.

What is the purpose to check the blank fields and send them by email? It would be easier to make a field required to avoid them being empty?

But if you still want to do this:
You have to do a conditional check on each column.
Initialize array variable. When a column is empty, append column name value to the array -> so array will keep "Column #3 was blank; Column#6 was blank".
Later you can send your array by email.

Was this reply helpful? Yes No
fchopo 8,003 Moderator on at

Like (0)

Report

Hi @od2023

You have different options.

1) items('apply_to_each')?['Title'] is equal to string('')

2) empty (items('apply_to_each')?['Title']) is equal to true

Hope it helps!

Ferran

Was this reply helpful? Yes No
od2023 14 on at

Like (0)

Report

You are talking about the condition value ?

Was this reply helpful? Yes No
od2023 14 on at

Like (0)

Report

Hello
I have maybe 250 columns so I would like to avoid to do a conditional check on each of them
Is there another way with a function or an expression ?

Was this reply helpful? Yes No
od2023 14 on at

Like (0)

Report

I still get an expression false but I have renamed the the title to Contrat. Does it matter ?

Was this reply helpful? Yes No
cmht 82 on at

Like (0)

Report

Hi @od2023
I don't have a complete solution for you, but:
1. HTTP request to SharePoint to get all column names:
https://powerusers.microsoft.com/t5/Building-Power-Apps/How-get-columns-name-from-sharepoint-list/m-p/801015#M255709
of course skip the part with PowerApps.
You end this with an array variable containing all column names, of course as described I would select to skip default Microsoft columns.

Now apply to each column name -> check if it is empty -> and append empty value to other array. [like row#1 , Column#2 empty, Column #6 empty]

Was this reply helpful? Yes No
od2023 14 on at

Like (0)

Report

Thanks. But I would have to do an apply to each of the 250 column name ?

Was this reply helpful? Yes No
Chriddle 8,436 Super User 2025 Season 2 on at

Like (1)

Report
Add such a property "HasEmptyCols" with a Select (and filter the outcome):

addProperty( item(), 'HasEmptyCols', greater( xpath( xml(json(concat('{"Root":', item(),'}'))), 'count(/Root/*[not(text())])' ), 0 ) )

Returns

[ { "Id": "000", "Col0": "test", "Col1": "test", "Col2": "test", "HasEmptyCols": false }, { "Id": "001", "Col0": "test", "Col1": "test", "Col2": "", "HasEmptyCols": true }, { "Id": "002", "Col0": "", "Col1": "test", "Col2": "test", "HasEmptyCols": true }, { "Id": "003", "Col0": "test", "Col1": "test", "Col2": "test", "HasEmptyCols": false } ]

Was this reply helpful? Yes No