Power Platform Community Forum Thread Details

How to include the dynamic content listing current month and year in the e-mail subject line

Hi Team,

I'm using automated cloud flows and scheduling reminders tasks, below are my queries,

1-We have an monthly activity where I want to send an e-mail with the subject line Task name and the dynamic content with the month and year . For example if i'm running the flow to send an e-mail on Feb 2022 , i need the subject line to be "Task name - Feb 2022"

2. We would like to schedule the monthly activity at different date some at the begging of the month, some at the mid of the month, some at the end of the month. For example, is there any option where i need send an e-mail reminder every 20th of the month?

3. I'm trying to attach a static word file in my e-mail so i'm using the actions 'get file metadata(one drive business)' & get file content(one drive business') but not able to see all the files and folder in my one drive. Please let me know is there any option how to attach the static file in an e-mail

Many thanks in advance

Regards

Nisha

1 - Use expression formatDateTime(utcNow(),'MMM yyyy') : this will give you current abbreviated month (Feb, Jun, Jul, Aug...) and year as per UTC timezone

2 - You create a Scheduled Flow and specify on what day and at what frequency you want to run the scheduled flow.

3 - Are you able to share a screenshot? Are you able to create a folder in your OneDrive with just this static word document? In general, if I had to send all files within a static OneDrive folder; I would use below steps:

3a. Create an array variable

3b: List Files in a Folder

3c: Apply to each 'value' from List Files action, and then Get File Content. Store Name and content of file in the array created in step 3a

3d: When sending email, under the Attachment area, click the advanced mode icon and specify the array from step 3a.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If this post or my previous reply was useful in other ways, please consider giving it Thumbs Up.

Quick Links

Leaderboard