Skip to main content

Notifications

Power Automate - General Discussion
Answered

If field doesn't exist, continue flow

(0) ShareShare
ReportReport
Posted on by 401

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

 

  • hssh Profile Picture
    hssh 5 on at
    Re: If field doesn't exist, continue flow
    adding ? works...Thanks
  • hssh Profile Picture
    hssh 5 on at
    Re: If field doesn't exist, continue flow
    adding ? works...Thanks
  • _sourcecod3_ Profile Picture
    _sourcecod3_ 401 on at
    Re: If field doesn't exist, continue flow

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

  • Verified answer
    Chriddle Profile Picture
    Chriddle 7,371 on at
    Re: If field doesn't exist, continue flow

    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.

  • Hardesh15 Profile Picture
    Hardesh15 7,087 on at
    Re: If field doesn't exist, continue flow

    @_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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,636

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,942

Leaderboard