need help with deleting a row

[ddglass]

i want to create an automatic flow that runs early Monday and Thursday morning. it will look at a dataverse table I have and look at a specific column called Child's DOB. it will automatically delete any record where the date of birth is 6 years ago or more. i have the reoccurrence set, then i did a list rows with my table, i then did an apply to each where the output was the value from the previous step, and added a condition where i have my Childs DOB column is greater then or equal to the formula addDays(utcNow(),-2192). i just chose 2192 in the formula because that's roughly 6 years with leap days in there. i then made the condition is yes to delete the row and didn't put anything for if no. I have attached a screen show of my flow. the flow fails when I test it. I am on the right path and can anyone give me some advice on fixing this? thank you! 

[ddglass]

just to clarify the child's DOB column is a date column 

[NAJC]

You seem to be on the right path to me. It might be the output of the function that's not matching with the Dataverse value. 

What does the workflow fail look like? Can you please post a screenshot?  🙂

[ddglass]

 

[ddglass]

if any other info can be helpful just let me know, thank you! 

[NAJC]

Thanks for the info! If you click on Next Fail does it provide the same error? 

What does the Delete a row action look like in the editor? 

Did you happen to copy and paste any of these actions? I've experienced workflows failing due to copied and pasted actions. 

Have/ can you try recreating the action, specifically Delete a row?

[ddglass]

yes clicking next fail same error. looks like i got the error with every entry in my dataverse table. a little concerning because right now in my table i don't have any dates of birth more than 6 years so it should delete any, I'm a little concerned that i might write it incorrectly and it deletes all my rows. i will post a pic of my delete a row action. i have not copied or pasted anything 

[ddglass]

 

[ManishSolanki · Accepted solution]

Hi @ddglass 

To resolve the error, pls pass the unique identifier from the list rows action as shown below:

If this helps & solves your problem, please remember to give a 👍 and accept my solution as it will help others in the future.

[NAJC]

@ManishSolanki 's answer looks right to me. If you should try testing the condition first with entries.

Delete the Delete a row  action and put the ID in a compose within each condition. If you can, add an entry that has a date of both of more than 6 years.

That way you can cross reference the ID's with entries that match the condition and don't. If it looks right, add back in the delete a row action.

The condition may need a bit of tinkering. You may want to check the add days output too. 

[ddglass]

Thank you I did need to change the row id to the unique identifier. I still have some more work to do though as @NAJC is correct my add days output needs work. When I tested the flow it deleted all my entries when it should not have deleted any. 

[ddglass]

the other change i needed to make was with my condition on DOB needed to be less than or equal to instead of greater than or equal to but I believe this flow is working now. @NAJC @ManishSolanki thank you for your help