Answered

Deleting record in dynamics using flows

(0) Share

Report

Posted on by Radhika Thadivaka

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.JPG Flow 2.JPG

Categories:

Using flows

I have the same question (0)

All responses (5)

Answers (1)

Sort by

MJain 2,450 on at

Like (1)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
abm abm 32,985 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi @Radhika2020

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

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

Was this reply helpful? Yes No
Radhika Thadivaka 5 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
abm abm 32,985 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi @Radhika2020

Thanks for your reply.

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

Was this reply helpful? Yes No
Verified answer

abm abm 32,985 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No