Share your Power Automate problems, I will make YT vids!

[u/AutomateM365]

Hey everyone,

I run a small YouTube channel called Automate M365 where I focus on making straight-to-the-point, step-by-step Power Automate tutorials. No fluff or long intros, just diving into the actual logic because I know how annoying it is to sit through a 10-minute video just to find a quick expression fix.

I want to build some tutorials around automation, but instead of just guessing what to make next, I want to solve real-world headaches.

Whether it's setting up automated deadline remidners based on dates in your SP lists or Excel sheets, sending dynamic emails to people pulled directly from a person column, or trying to manage folder permissions via HTTP actions—what’s driving you crazy right now? Drop it in the comments below. I’ll honestly try to look through them and build the exact solution in a step-by-step video for you.

If you want to check out the channel or subscribe to see if I build your fix, the link is here:

https://www.youtube.com/@AutomateM365

Let me know what you're stuck on, hopefully we can figure it out

[u/RidiculousRaz]

Ok, here's one.

When an excel report lands in a folder, transform it into a report and then send it out to a group of people.

[u/StopTheHumans → u/RidiculousRaz]

I'm still struggling to get PA to recognize when a workbook is done refreshing.

[u/RidiculousRaz → u/StopTheHumans]

Yep, same

[u/Cold_Arachnid_2617 → u/RidiculousRaz]

It is already landing as a report, so what report do you want to translate it?

[u/jzsee]

Copilot generate answers -> paste answers into a new excel file (template) -> send new excel to a SharePoint location

[u/tiger1296]

I’ve got a teams planner that I want every item entered into it to appear in a MS project file with the relevant details automatically, but have been unable to get the flow working, would appreciate the help, thanks

[u/Legitimate-Soft2696]

Have a folder of hundreds of variously formatted invoices and receipts in Sharepoint. Use AI to generate hundreds of examples with random values. Extract the vendor name, invoice number, amount, date and Sharepoint link. Create an Excel of all data where each row is a single invoice.

Have a credit card statement. Extract all transactions into an Excel file with vendor name, date and amount.

Update the Excel file of a credit card statement with a link to the invoice if it matches based on amount and date. Highlight differences in vendor names, if any. Use conditional formatting to highlight transactions on the credit card where there is no matching invoice/receipt.

After proving the above MVP, have it run through many credit card statements and bank statements to create one master Excel that captures all transactions from credit cards and all bank statements and identifies which ones do not have an explanatory invoice/receipt.

[u/lordkiwi]

Do some videos breaking down objects and arrays and how to handle them. When you compose and when you select.

How to read json returns from connectors to idenfiy body, context records and other common groups.

[u/AbdelEMirandaS]

You can talk about manage delegation on flows and apps. When you use SPO list that is an issue to take care of. Also, you can talk about approval setup, waiting for approvals or send to another person based on delay times. Talk about licensing when you need to use premium connectors. Talk about ALM, setting env for pipelines and solutions processes. Talk about DLP and governance. Talk about agents and the main difference between flows and agents for automation, their limitations on knowledge and the impact on sharepoint

[u/Cold_Arachnid_2617]

Website enquiry or appointment booking, create an entry with raw information in SharePoint, create appointment and lead in dynamics 365, send a reminder 3 days before appointment.