Answered

Automate Sharepoint to Outlook. Adding extra layer to pick files from different folders monthly

(0) Share

Report

Posted on by Ahmedz

139

Automated flow from Sharepoint to Outlook every week with changing file names already created. I want to add an extra layer where this flow can also pick up changing folders every month.

The flow that is already created is as follows:

This community rocks and your help is much appreciated.

Categories:

General topics

I have the same question (0)

All responses (17)

Answers (3)

Ahmedz 139 on at

Like (1)

Report
Copy link

Link copied!

trice602

Was this reply helpful? Yes No
trice602 15,890 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi @Ahmedz ,

Are you saying that when a new email arrives with your CSAT attachment you want to dynamically save it to the appropriate month/year folder and rename it as something else?

Was this reply helpful? Yes No
Ahmedz 139 on at

Like (1)

Report
Copy link

Link copied!

Thanks for your response. No . So I want the flow to detect the month change and automatically switch to the next month and fetch the file for that week from the new folder and send it to the customer. For example. The code that I have will fetch the file for this month , approximately 4 files but as soon as we move in October then this code will break. So I want to add additional layer so that the code fetches the file from the new folder next month and sends it out.

Was this reply helpful? Yes No
Verified answer

trice602 15,890 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Hi @Ahmedz ,

Ok, so here's a new compose 3 to make the dynamic folder path, you many need to tweak the hard-coded part

The additional compose 3 looks like this:

concat(formatDateTime(outputs('Compose'),'yyyy'),' - ',formatDateTime(outputs('Compose'),'MM'))

And essentially returns 2023 - 09 right now, will return 2023 - 10 next month, etc, etc

If I helped you solve this today, please mark as a solution so others can find the formula for dynamic folder paths too!

Was this reply helpful? Yes No
Ahmedz 139 on at

Like (1)

Report
Copy link

Link copied!

Do I need to add the compose 3 outputs anywhere else other than the path you shared ? Like the email or somewhere else ?

Was this reply helpful? Yes No
Verified answer

trice602 15,890 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

No, works as is.

Was this reply helpful? Yes No
Ahmedz 139 on at

Like (1)

Report
Copy link

Link copied!

Thank you so much! I haven't tried it but I know it will work. I will accept this solution and you are a true champ 🙂

Was this reply helpful? Yes No
trice602 15,890 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Thank you for the kinds works; I enjoy volunteering and helping!

Was this reply helpful? Yes No
Ahmedz 139 on at

Like (0)

Report
Copy link

Link copied!

Hello! So I tried and I am having these issues. Maybe you can direct in where I am going wrong.

Was this reply helpful? Yes No
Ahmedz 139 on at

Like (1)

Report
Copy link

Link copied!

The code I used was this for Compose 3 :

concat(formatDateTime(outputs('Compose'),'yyyy'),' - ',formatDateTime(outputs('Compose'),'MM'))

Was this reply helpful? Yes No