Answered

Combine Filter Array outputs into a single email

(0) Share

Report

Posted on by webdude_guy10

Hello,

I have a workflow where I'm trying to find all files within a folder older than 360 days and then list them all collectively into a single email. I'm running into an issue where my Filter Array outputs each file individually and then proceeds to sends out a separate email for each file found.

This is my Filter Array step which appears correct.

I then tried adding a Compose step using the "join" function pictured below.

But then in the final step where the email is sent, it's still sending each file as a separate email.

Categories:

General topics

I have the same question (0)

All responses (13)

Answers (1)

v-yetonggu-msft on at

Like (0)

Report
Hi @webdude_guy10 ,
Do you want to find files in a specific folder that are older than 360 days and send those file names as an email?
If so, I did a test for your reference.
In my scenario:

addDays(utcNow(), -360, 'yyyy-MM-dd')

item()?['{FilenameWithExtension}']

My Outlook Inbox:
Best Regards,
Sunshine Gu

Was this reply helpful? Yes No
webdude_guy10 28 on at

Like (0)

Report

Let me try this and get back to you. To answer your initial question, yes, I'm looking to generate a list of all files older than 360 days in a specific SharePoint folder. Instead of the "Created" filter query, I was planning to use "Modified" instead which should work the same.

Was this reply helpful? Yes No
webdude_guy10 28 on at

Like (0)

Report

My Select step requires another value here. Without anything there, the workflow fails at this step.

Was this reply helpful? Yes No
webdude_guy10 28 on at

Like (0)

Report

Here's the specific error if that helps.

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

Like (0)

Report
Hi @webdude_guy10 ,
Please clear the content in the Map, click on the place I circled, and convert it to a different format.
This is not dynamic content, it is a written formula.
I gave you the formula, please check it carefully.

item()?['{FilenameWithExtension}']

No need for 'Apply to each' loop, just put the output of the 'join' action into the email body.
Best Regards,
Sunshine Gu

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

Like (0)

Report

Hi @webdude_guy10 ，
1)First fill in the dynamic content of 'value'. then fill in the dynamic content of 'Created', select 'is less than', and then write the formula to avoid unnecessary loops.
2)Fill in the "Modified" dynamic content and select "is less than".
3)Write a formula.
4)Clear the content in the 'Select' control Map, click on the place I circled, convert the format, and then write the formula.
Best Regards,
Sunshine Gu

Was this reply helpful? Yes No
webdude_guy10 28 on at

Like (0)

Report

I got this working by switching back to the classic UI and following your instructions. The Select step wasn't picking up the map field as a function in the new UI. Thank you!

Is there a way to list each file per line instead of side by side with a comma? The output from this workflow ends up just dumping everything into an ugly block of text. I can probably parse it out with Excel using the comma as the separator but it would be slightly more convenient just having it listed in the email body from top to bottom.

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

Like (0)

Report

Hi @webdude_guy10 ,
If I understand correctly, do you want each filename in the email to be on its own line? like this?
If so, please change the comma in the 'Join' control to <br>.
Best Regards,
Sunshine Gu

Was this reply helpful? Yes No
webdude_guy10 28 on at

Like (0)

Report

That worked thank you. Last question, how can I add the following file information to each file?

So for example, each line will list the filename, last modified date, and the name of the user who last modified that file. I attempted to use the concat function but it didn't do anything different.

Was this reply helpful? Yes No
Verified answer

v-yetonggu-msft on at

Like (0)

Report
Hi @webdude_guy10 ,
I created a table in html format.
My complete flow：

item()?['{FilenameWithExtension}'] item()?['Modified'] item()?['Editor/DisplayName']

My Outlook Inbox:
Best Regards,
Sunshine Gu

Was this reply helpful? Yes No