cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Frequent Visitor

Replacing subject and part of the body based on the month

Hi,

 

Good day.

 

Can you help me on how to create this flow? I already tried to send an email thru MS Flow (reocurrence flow) and get data from sharepoint, but Im left on having problem in naming the subject and part of the body email. I want these to align based on the previous month's and year (format: MMMM-YYYY) but im sending this email today (current month). Example: Current month - October; Previous month - September

 

""""""

Subject: Action Required submitted on September 2020

 

Body:

Sending you copy of our audit for the month September 2020.

 

"""""

Above is the example outcome Im trying to create. Kindly help me on this?

 

Thanks and regards,

Echo

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted

VictorIvanidze_0-1601544693266.png

 

Expresssion:  

formatDateTime(body('Add_to_time_2'),'MMMM-yyyy')

View solution in original post

5 REPLIES 5
Highlighted
Impactful Individual
Impactful Individual

Could you please show your flow?

Highlighted

Hi @VictorIvanidze ,

 

Good day.

 

See image below. The yellow highlighted one is the part where should the previous month be shown. (I cover some confidential sites per our company's policy)

 

Flow_1.PNG

 

Hope I provided what you need 🙂 Thanks a lot,

 

Regards,

Echo

 

 

Highlighted

VictorIvanidze_0-1601544693266.png

 

Expresssion:  

formatDateTime(body('Add_to_time_2'),'MMMM-yyyy')

View solution in original post

Highlighted

Hi @VictorIvanidze 

 

Follow up question: Where will I insert this command/expression on my submitted flow? Which part of it?

 

Thanks

Highlighted

Before sending an email, naturally.

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Power Platform ISV Studio

Power Platform ISV Studio

ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.

Top Solution Authors
Top Kudoed Authors
Users online (7,835)