If field doesn't exist, continue flow

(0) Share

Report

Posted on by _sourcecod3_

407

Hi all,

I'm kinda hitting a roadblock here, I have a query to SQL (Get rows v2) and sometimes there is an additional field returned, but when this particular field is not returned I need my flow to ignore that and finish adding those accounts to dataverse.

[

{

"field 1": "data",

"field 2":"data"

"field 3":"data" (sometimes this field is not in the query results)

}

]

Any help is appreciated.

Thanks

Categories:

General topics

I have the same question (0)

All responses (5)

Answers (1)

Hardesh15 7,087 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@_sourcecod3_ Pls share your flow. Run after activity can help you here.

Please 'Thumbs Up' the posts that helped you and 'Accept as Solution' if my post answered your question.

@Hardesh /Gopenly.in

Was this reply helpful? Yes No
Verified answer

Chriddle 8,513 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Assuming that you access "field 3" like this: item()['field 3'] and therefore your flow crashes if this field doesn't exist, use item()?['field 3'] which returns null if the field dos not exist.

Was this reply helpful? Yes No
_sourcecod3_ 407 on at

Like (0)

Report
Copy link

Link copied!

Thanks @Chriddle this worked, I just added a condition once this returned a 'null' value

Was this reply helpful? Yes No
hssh 5 on at

Like (0)

Report
Copy link

Link copied!

adding ? works...Thanks

Was this reply helpful? Yes No
hssh 5 on at

Like (0)

Report
Copy link

Link copied!

adding ? works...Thanks

Was this reply helpful? Yes No