Check if record exist

(0) Share

Report

Posted on by varshinims08

104

Hi all,

I want build a flow to check if record is already exist in dynamics based on the field. I have entity A, which has number field, when the new record is created in entity A i want to check if record with same number already exist in entity A, if yes i want to link both the records together. How can i achieve this?

Thanks...

Categories:

Using flows

I have the same question (0)

All responses (4)

Answers (1)

varshinims08 104 on at

Like (0)

Report
Copy link

Link copied!

Thank you so much @v-duann-msft,
I achieved what i wanted.

Was this reply helpful? Yes No
varshinims08 104 on at

Like (0)

Report
Copy link

Link copied!

Hi @v-duann-msft,
I gone through the link you have provided. But i didnt understand what should i take instead of whole number.
It will helpful if you can explain about it!

Thank you...

Was this reply helpful? Yes No
varshinims08 104 on at

Like (0)

Report
Copy link

Link copied!

Hi @v-duann-msft
Thanks for reply,
I tried the flow you have attached, but i am getting result as false even when the record exist. I dont know what I am missing. Can you please help?

This is my flow

and this is result i am getting

Was this reply helpful? Yes No
Verified answer

v-duann-msft on at

Like (1)

Report
Copy link

Link copied!

Hi @varshinims08

Thank you for posting.

According to your description, you would like to use flow to update your table based on number column.

But I’m confused about your request related to link this two records which has same number value. What do you mean by link both the records together? Could you please show me an example ? Thanks in advance.

By the way, the flow you required would like as below:
length(outputs('List_records_(deprecated)_2')?['body/value'])

Following up the flow provided, when expression returns true. It means the new created record is the first record that contains this number.
When you get false from expression, it means, the record with same number already exists.

If you want to link two records, please configure link action in no branch.
https://powerusers.microsoft.com/t5/Building-Flows/How-do-I-create-a-flow-that-checks-if-a-record-already-exists-in/td-p/566110

Best regards,
Anna

Was this reply helpful? Yes No