Unanswered

Apply to Each to delete duplicates

(0) Share

Report

Posted on by DB-17060835-0

I have created a basic flow to take the response from an MS Form and create a new item in a SharePoint list.

When a new one is added I want it to go through and check each item's date and if it's more than 7 days it should be deleted. I can't seem to get this working, any help would be appreciated.

Screenshots attached

Categories:

Building flows

ss1.png

ss2.png

I have the same question (0)

All responses (13)

Answers (1)

Matthy79 4,180 Super User 2024 Season 1 on at

Like (0)

Report

Hello @DylanB02

If you want to apply to each item, you first have to get all the items. You can only use “apply to each” for arrays. Your input is a number.

Was this reply helpful? Yes No
v-yetonggu-msft on at

Like (0)

Report
Hi @DylanB02 ,
Do you want to when new items are added, go through and check the date of each item, and if it's older than 7 days, delete it?
If so, I have a test for your reference.
In my scenario:

formatDateTime(items('Apply_to_each')?['Created'],'yyyy-MM-dd')

addDays(outputs('Create_item')?['body/Created'],-7,'yyyy-MM-dd')

Best Regards,
Sunshine Gu

Was this reply helpful? Yes No
Matthy79 4,180 Super User 2024 Season 1 on at

Like (0)

Report

The solution of @v-yetonggu-msft is correct but you should filter during “get items”. That way you will loop less items and don’t need the condition inside the apply to each.

Was this reply helpful? Yes No
DB-17060835-0 on at

Like (0)

Report

Hi @v-yetonggu-msft,

Thanks for your help with this, it ran successfully.

I have tried to add an item in with the date more than 7 days ago but when I add another entry it isn't removing that submission but still showing as flow ran successfully

I'm not sure whether it is to do with the "date" column on SharePoint and the formatDate expression i have used using the same format, "dd-MM-yyyy".

Added some more screenshots.

Thanks

ss4.png

ss5.png

Was this reply helpful? Yes No
v-yetonggu-msft on at

Like (0)

Report

Hi @DylanB02 ,
Could you please set the formatDateTime on both sides of the condition action to 'yyyy-MM-dd'?
Please show your full flow.
Best Regards,
Sunshine Gu

Was this reply helpful? Yes No
DB-17060835-0 on at

Like (0)

Report
See below
formatDateTime(items('Apply_to_each')?['Created'],'yyyy-MM-dd')
addDays(outputs('Create_item')?['body/Created'],-7,'yyyy-MM-dd')

Was this reply helpful? Yes No
DB-17060835-0 on at

Like (0)

Report

And just for your reference, this is how it comes through on SharePoint

Was this reply helpful? Yes No
v-yetonggu-msft on at

Like (0)

Report

Hi @DylanB02 ,
Attention:
1)Please check in the ID is Get items Dynamic content.
2)Please check in the actual creation time of the item.
Best Regards,
Sunshine Gu

Was this reply helpful? Yes No
DB-17060835-0 on at

Like (0)

Report

Yes, the ID is set to the "Get Items" one.

As for the second step, are you asking me to create a new column called CreateDate? I have a date column already for this.

Thanks

Was this reply helpful? Yes No
v-yetonggu-msft on at

Like (0)

Report

Hi @DylanB02 ,
You do not create CreateDate columns,
Could you please show you created column.
Best Regards,
Sunshine Gu

Was this reply helpful? Yes No