Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Power Automate - Using Flows
Answered

Deleting record in dynamics using flows

(0) ShareShare
ReportReport
Posted on by 5

Hi All,

I am very new flows and got a requirement to delete the record in dynamics based on the condition taken on Yes/NO field is NO and look up field contains data.

Here I am explaining in detail.

Based on the trigger when a record(parent record) is updated then i have to verify the condition on yes /no field and look up field on  Parent entity and then delete the child record.

Here I am troubling to assign the look up  value doest contain data and boolean filed should be equal to NO in conditon.

Please help me to solve this.flow 1.JPGFlow 2.JPG

  • Verified answer
    abm abm Profile Picture
    32,464 Most Valuable Professional on at
    Re: Deleting record in dynamics using flows

    Hi @Radhika2020 

     

    Thanks for the discussion.

     

    Setting the correct lookup id and boolean value check will determine the conditions and finally passing the id will delete the record. This is already described in my earlier screenshot. If your lookup is M:M relationship this technique won't work. 

     

    Thanks

  • abm abm Profile Picture
    32,464 Most Valuable Professional on at
    Re: Deleting record in dynamics using flows

    Hi @Radhika2020 

     

    Thanks for your reply. 

     

    Here it is. Here I mapped the accountid (Value) which is my lookup field value.

     

    image.png

     

    image.png

  • Radhika Thadivaka Profile Picture
    5 on at
    Re: Deleting record in dynamics using flows

    Thanks for the reply.

    So you mean that I have to take schema name for look up field instead of field name(Dynamics content) and should be referred to "Null" could you please mention the format with an image.

     

     

  • abm abm Profile Picture
    32,464 Most Valuable Professional on at
    Re: Deleting record in dynamics using flows

    Hi @Radhika2020 

     

    Like @ManishJain mentioned make sure you set the value for checking the null.

     

    image.png

     

    Also you mentioned the Yes/No and if its a boolean value then most likely default value will be false. So make sure check false instead of null. If the Yes/No is an optionset values then ofcourse you can check null against it.

     

    If you have anymore questions please let me know.

     

    Thanks

  • MJain Profile Picture
    2,450 on at
    Re: Deleting record in dynamics using flows

    Hi @Radhika2020 ,

     

    In order to check for lookup condition you need to use following format (field refers to schema name of field you are using )

     

    _field_value 

     

     

    Thanks

     

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

🌸 Community Spring Festival 2025 Challenge 🌸

WIN Power Platform Community Conference 2025 tickets!

Markus Franz – Community Spotlight

We are honored to recognize Markus Franz as our April 2025 Community…

Kudos to the March Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 146,524 Most Valuable Professional

#2
RandyHayes Profile Picture

RandyHayes 76,287 Super User 2024 Season 1

#3
Pstork1 Profile Picture

Pstork1 65,906 Most Valuable Professional

Leaderboard

Featured topics

Restore a deleted flow