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?
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.
You could try an if expression, something in the lines
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?
Keep up to date with current events and community announcements in the Power Automate community.
Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.
Check out the latest Community Blog from the community!