Answered

need help with deleting a row

(0) Share

Report

Posted on by 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!

Categories:

Building flows

Capture.PNG

I have the same question (0)

All responses (11)

Answers (1)

ddglass 31 on at

Like (0)

Report

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

Was this reply helpful? Yes No
NAJC 23 on at

Like (0)

Report

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? 🙂

Was this reply helpful? Yes No
ddglass 31 on at

Like (0)

Report

Was this reply helpful? Yes No
ddglass 31 on at

Like (0)

Report

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

Was this reply helpful? Yes No
NAJC 23 on at

Like (0)

Report

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?

Was this reply helpful? Yes No
ddglass 31 on at

Like (0)

Report

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

Was this reply helpful? Yes No
ddglass 31 on at

Like (0)

Report

Was this reply helpful? Yes No
Verified answer

ManishSolanki 15,091 Super User 2025 Season 2 on at

Like (2)

Report

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.

Was this reply helpful? Yes No
NAJC 23 on at

Like (0)

Report

@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.

Was this reply helpful? Yes No
ddglass 31 on at

Like (0)

Report

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.

Was this reply helpful? Yes No