Unanswered

Instant flows fail when you don't fill out all fields including Optional fields. Why?

(0) Share

Report

Posted on by SharonS

164

I created an instant flow on a SharePoint list. I made some fields not mandatory. The flow failed when a user did not fill out ALL fields. What is going wrong? I intentionally did not fill out the column called "Number" that's why the data in that field doesn't exist. Its not a mandatory field.

When all fields are filled out, then the flow runs successfully.

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (0)

WillPage 2,307 Super User 2025 Season 2 on at

Like (0)

Report

Put a question mark in your expression to make it nullable e.g triggerBody()?['number']

When a property is null it's often omitted from the JSON object so doing this will make the value null whether it exists with a null value or it's simply not there.

Was this reply helpful? Yes No
SharonS 164 on at

Like (0)

Report

Here is the expression that I am using for a text field.

if(empty(triggerBody()['text'],'',triggerBody()['text']))

Its an if then statement.

Do I put the question mark here (see below)?
if(empty(triggerBody()?['text'],'',triggerBody()['text']))

Was this reply helpful? Yes No
WillPage 2,307 Super User 2025 Season 2 on at

Like (0)

Report

Yes, but you can refine the expression using the coalese() function:
coalesce(triggerBody()?['text'],'')
This will convert the null value of triggerBody()?['text'] to an empty string otherwise leave triggerBody()?['text'] as is if it's not null

Was this reply helpful? Yes No
SharonS 164 on at

Like (0)

Report

@WillPage Thank you. I will try that.

Was this reply helpful? Yes No