cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
PowerUser0
Helper V
Helper V

Check already exiting records and only update new records in dataverse

Hi All,

 

I am trying to update two dataverse columns from the output of PARSE JSON action, as a output from my json I am getting name and Id, now using for apply to each loop, I am adding a row in dataverse table, but when the next time when I am running the flow, it will create a duplicate entries in dataverse, 

 

Any Idea, how I can check the values coming from the Parse json and check which once are already there in the table and only update the new one?

 

@ekarim2020 @abm 

4 REPLIES 4
abm
Super User
Super User

Hi @PowerUser0 

 

You need to have a unique identifier value in each record. This way you can filter using List rows action step of Dataverse connector by setting the Filter rows against the unique identifier column. Next step you can check the row could is one or not. If zero you can use the create action step else use the update action step of Dataverse.

 

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 blog
Power Automate Video Tutorials
SudeepGhatakNZ
Resident Rockstar
Resident Rockstar

You could try an if expression, something in the lines

 

  1. Get action to get the value of the field - ValueofYourFieldName
  2. if(empty(ValueofYourFieldName),YourJSONValue, ValueofYourFieldName)
If my suggestion helped you, please give it a Thumbs up and mark it as a Solution so that it can benefit others in the community.

Hi @abm , thanks for your response,

 

I am using list rows action of dataverse, I applied filter id eq '1234, but how to get the true or false value from the output?

Hi @PowerUser0 

 

 

You need to look the count items.

 

Please have a look at my tutorial video https://www.youtube.com/watch?v=mmlHXiD6G98&t=6s

 

Any 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 blog
Power Automate Video Tutorials

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Users online (3,322)