r/PowerAutomate

I have a Test folder in sharepoint called XYZ.
Everytime I create a new folder inside test folder, i want power automate to create a current year folder,eg 2026 and inside 2026 three folders inside it: Sales,Tech and HR.
How to achieve this?

XYZ SharePoint
|
2026
|
Sales, Tech, HR

What to use?
When a file is created in a folder, then site address, folder ID, and create folder and name it and how to make aure the flow keeps running since automatic isnt an option.

Everytime i cant run the flow to create these folders inside 2026

Everytime I launch Excel thru power automate, the Ychart tab dissapears. New File or existing… still no Ycharts.

I open excel manually and Ycharts appears. My add in shows it is installed on the files Ycharts dissapears.

Actualmente me llegan correos todos los días con PDF en Outlook y tengo que traducirlos a español, y quiero que genere un resumen general y envie el correo. Como podría hacerlo de forma rápida? ¿Se podría conectar con copilot? Quiero automatizarlo con Power Automate.

Hey everyone!

If this isn't the right place for this post, please let me know which is the right place, and I'll move it to the right community. Thanks!

A bit about me
I'm a business consultant from a non-technical background, and I want to make the move into a slightly more technical role. Automation (especially with AI in the loop) is something I've been curious about for a while, so I'm upskilling in it to help land my next job (while dabbling in personal automation projects on the side)

What I'm learning

• Power Automate Desktop (free version). I don't have access to the enterprise/cloud version.
• n8n - through a structured course I'm starting soon.

My understanding is that these two aren't completely separate tracks. The core logic (triggers, conditions, loops, variables) seems to carry over, so getting better at one should help with the other. Is that right, or am I oversimplifying?

I'm doing Power Automate first. My first project is a small bot that screens job ads in Excel against a list of keywords.

Where I'm stuck

• Microsoft Learn doesn't stick for me. It's mostly reading, and I learn best by actually clicking around in the tool.
• Udemy courses I've found usually assume an enterprise/cloud account, which I don't have.

What I'd love some help/advice in:

1. What's the best hands-on way to learn Power Automate Desktop specifically? Any YouTube channels, practice projects, or follow-along resources that work with the free version?
2. What beginner projects helped things click for you, or which ones are worth showing in a portfolio?
3. For those hiring or working in automation: does experience with the free Desktop version count, or do employers mostly want cloud flows?
4. If the logic does carry over, what's the best way to learn the two together? For example, should I build the same small project in both tools to compare? Are there integrations with Power Automate for LLMs, or is n8n the "go to" if I want to automate with AI?
5. How long did it take you to go from "following tutorials" to "building things on my own"?
6. If you came from a non-technical background, what do you wish you'd known at the start?

Thanks in advance. Any tips, even small ones, are really appreciated! 🙏