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
Thanks @Chriddle this worked, I just added a condition once this returned a 'null' value
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.
@_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.