Hi Community,
I have a strange issue maybe someone can assist me.I have below part of a flow
The two variable are used to set the day and year that the email has arrived as below
@creativeopinion Thanks for the tutorial it has been really helpful especially with stuff i am doing now.Also the compose actions has the correct output at last !! Thanks for all the help
@creativeopinion Thanks for the tutorial it has been really helpful especially with stuff i am doing now.Also the compose actions has the correct output at last !! Thanks for all the help
@Mikellas No worries. Because you are creating year/month folders, you might find this YT Tutorial helpful: Streamline 2024: Automate Monthly Folders & Files in Minutes
In this Microsoft Power Automate tutorial, I’m going to show you how to create an Automated Cloud flow that runs on the first day of a new year. We’ll go over how to use the Convert Time Zone action as well as how to use an expression to return the months in a year. I’ll cover three different scenarios on how you can use these actions in various flows:
1️⃣ Create a new folder for the new year for a selected folder. This folder will contain subfolders for each month of the new year.
2️⃣ Create a file for each month of the new year from a template.
3️⃣ Create a new notebook section in OneNote for the new year with a page for each month in the year.
---
IN THIS VIDEO:
✅ How to trigger a flow from a selected folder
✅ How to create a file from a template
✅ How to create a new notebook section in OneNote for the new year with a page for each month in the year
✅ How to use the Recurrence trigger
✅ How to create dynamic dates
✅ How to use a date input in a manual flow trigger
✅ How to use the Convert Time Zone action
✅ How to use the range() function
✅ How to use the concat() function
✅ How to use the formatDateTime() function
✅ How to group Power Automate actions together
✅ How to use the Recurrence trigger
✅ How to customize a OneNote Page Name in Power Automate
Hope this helps!
Hi @creativeopinion and thanks for taking the time to help me .I will make 2 compose actions and run it .I will let you know if all is good.Thank you so much!!
@Mikellas Sorry about that. Use two Compose actions instead.
formatDateTime(outputs('Get_email_(V2)')?['body/receivedDateTime'], 'yyyy')
formatDateTime(outputs('Get_email_(V2)')?['body/receivedDateTime'], 'MM')
If you'd like to level up your Power Automate skills check out this video: Power Automate Beginner Tips and Tricks | 5 Things You Need to Know – Part 1
I cover the following in this video tutorial:
✅ Power Automate Beginner Tips and Tricks
✅ Why use the Manual Trigger instead of an Automated Trigger
✅ 3 Ways a Compose Action can help you build better flows
✅ How to Manually Trigger a flow with a specific Date and Time
✅ How to return a count of items
✅ How to use the top count
✅ How to send test emails
Hope this helps!
Hi @creativeopinion and thanks for the help.Wont the compose produce just one output?How would i be able to build the path for the file as i need 2 outputs/variables for day and year?
@Mikellas That's really odd behaviour. In your flow, you can use a single Compose action instead. Initializing and setting variables to store a date isn't necessary in your case.
formatDateTime(outputs('Get_email_(V2)')?['body/receivedDateTime'], 'yyyy/MM')
Hope this helps!
For more flow troubleshooting tips—check out this YT Tutorial: 5 Power Automate Troubleshooting FAQs and Helpful Tips for Creating Better Flows
In this tutorial I cover:
✅ How to troubleshoot a false Condition action result
✅ How to get dynamic content when it isn’t selectable from the list of dynamic content
✅ How to troubleshoot an Apply to Each action that isn’t looping through
✅ How to troubleshoot a skipped Apply to Each action
✅ How to troubleshoot a Filter Query
✅ How to use a SharePoint yes/no column in a Filter Query
✅ How to use Compose actions to troubleshoot a Power Automate flow
✅ How to troubleshoot multiple emails being sent
✅ How to troubleshoot multiple Teams messages being sent
Hope this helps!
Michael E. Gernaey
497
Super User 2025 Season 2
David_MA
436
Super User 2025 Season 2
Riyaz_riz11
244
Super User 2025 Season 2