Delete reports from the sharepoint site that are older than 7 days | ExpressionEvaluationFail

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hey folks,

I'm very new to power automate and I use it in my company to accomplish two things:

Transfer Salesforce reports that are mail attachments to a sharepoint site
Delete reports from the sharepoint site that are older than 7 days

First task works like a charm but deleting the older files throws an error.

I did hack together this flow using tutorials online, so there is a very high chance that I copy/pasted something wrong.

I can interpret what the expressions mean that I pasted, I'm just not practised enough to write them.

Fehler beim Ausführen der Vorlagenaktion "Auf_alle_anwenden". Das Ergebnis der Auswertung des foreach-Ausdrucks "@items('Auf_alle_anwenden_2')?['Modified']" weist den Typ "String" auf. Das Ergebnis muss ein gültiges Array sein.

Sorry for the error messages in German.

The expressions that I'm using are

utcNow('yyyyMMdd')

formatDateTime(adddays(item()?['Created'], 7), 'yyyyMMdd')

May someone has an idea.

Thank you!

Categories:

Building flows

I have the same question (0)

All responses (5)

Answers (1)

abm abm 32,985 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

Hi @Anonymous

I can see you have two loops in your screenshot you provided. Are you sure you mapping the right values? Only one loop is needed. First the Get Items and iterating the records for the filter.

Watch my tutorial video about filter dates in SharePoint.

https://www.youtube.com/watch?v=FRKtB37hJ4g&t=103s

Thanks

Was this reply helpful? Yes No
KvB1 1,596 on at

Like (1)

Report
Copy link

Link copied!

You would make your life a lot easier if you just compared

Created gt addDays(utcNow(),-7)

as an odata filter query in the get files properties action

You would get the files where the created date is bigger than 7 days before today

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

If I do that, I get a "Bad request" Sorry If I set it up wrong

Was this reply helpful? Yes No
Verified answer

KvB1 1,596 on at

Like (1)

Report
Copy link

Link copied!

Yeah, have to add some fluff so PA can understand the filter

Created gt '@{addDays(utcNow(),-7)}'

Was this reply helpful? Yes No
abm abm 32,985 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

Hi @Anonymous

If you are a beginner in PowerAutomate I would say see my video and try the same example. Once you understood you can change the filter accordingly.

Thanks

Was this reply helpful? Yes No