I have a flow that adds data to a table in the dataverse.
There was an internal outage this week that affected this (internal to Microsoft).
My flow failed a few times and after rerunning it a few times, I now have duplicate rows in the table from specific days this week.
When trying to figure this out, I was going to build a flow that will look for these and then remove them.
I found articles on how to setup Detection Rules and Jobs.
Here is the problem. I setup a rule to check for assignmenttime is the same, and case number is the same.
Once I setup the rule, I could not find where to view the results and take action.
I created a job, that I THOUGHT would point to that rule, but I never could get the job to key off the rule.
Maybe I missed something in the documentation, but I could never find where to look at this data.
Could someone please walk me through this step by step? I am missing something somewhere and I dont know where.
I want to look at my table, and pull all results where Assignmenttime (date and time) is exactly the same along with case number being exactly the same.
