cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Radhika2020
Regular Visitor

Deleting record in dynamics using flows

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

1 ACCEPTED SOLUTION

Accepted Solutions
abm
Super User
Super User

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



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blogPower Automate Video Tutorials

View solution in original post

5 REPLIES 5
ManishJain
Solution Sage
Solution Sage

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

 

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



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blogPower Automate Video Tutorials

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.

 

 

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



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blogPower Automate Video Tutorials
abm
Super User
Super User

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



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blogPower Automate Video Tutorials

View solution in original post

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Users online (2,224)