Condition: to check for null value

(2) Share

Report

Posted on by Hilda Steyn

271

In Dataverse, I have a table with a column marked as business required. Obviously when forms in apps are used to input data, that field is enforced. However, when imports are run, sometimes mistakes happen, and records are created without a value in that field.

I want to build a flow that will send an email to warn me when that happens.

I have a trigger: when a row is added or modified. But I see in the outputs of this action, that the empty field is not loaded at all; only fields that contain data is loaded for use in the rest of the flow.

How do I get past this problem? I cannot use that field in a condition to check for value as it is not loaded. I am missing something?

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (0)

stampcoin 5,058 Super User 2025 Season 2 on at

Like (0)

Report

@Hilda Steyn Hi,

When a row is added, modified or deleted, this will output the non empty value.

But you can find the all columns in other steps, unless the columns is new added.

Try to add a compose to see if you can check all the fields.

Was this reply helpful? Yes No
Suggested answer

abm abm 32,865 Most Valuable Professional on at

Like (0)

Report

Hi @Hilda Steyn
You could still check using the schema and check for empty or not after the trigger step. So that means if the value is there it will be part of the trigger response and it won't be null or empty.
Thanks

Was this reply helpful? Yes No
Suggested answer

Inogic 1,135 Super User 2025 Season 2 on at

Like (0)

Report
Hi,

I understand that when you create or update a record, you may not have all the fields available to check for null values.

You can solve this by adding a “Get row by ID” action right after the trigger. This will fetch the full record, including the missing field.
Please refer to the steps below to make changes in Power Automate Flow.

Trigger:

Use Dataverse → When a row is added or modified

Select your table.

Action: Get Full Record

Add Dataverse → Get a row by ID

Use:

Table name: same as the trigger

Row ID: Use the Row ID from the trigger

Condition to Check for Missing Value

While checking the value for a missing field, use the reference from the "Get a row by ID” step instead of the trigger.

Let me show with the example below :-

We need to add "Get a Row by Id" an action after Record is added or Modified step in the Flow as shown in below screenshot:

In this action we get the All fields. After that we need to use empty() method in expression to check the value is null or not. You can use below expression to check the value is null or not. Instead of fieldname in the expression you have to give fieldname which you wants to check.

empty(outputs('Get_a_row_by_ID')?['body/fieldname'])

If it is null or blank then it will return true otherwise it returns as a false.
Then after that using this you can validate the field is empty or not inside the condition as shown in below screenshot:

So if it is blank then it will return true and create the Email record.

Hope this helps.

Thanks!

Inogic

Was this reply helpful? Yes No