Mohammed Brueckner, passionate Leader, Advisor and IT Architect

Results-oriented tech leader driving innovation and transformative growth through strategic alignment of business objectives with cutting-edge cloud (Azure/AWS), AI/IoT/Data solutions. Specializes in practical AI (GenAI/MLOps) implementation for Azure-driven strategic advantage. Empowers high-performing teams, communicates complex concepts effectively, and adapts quickly to dynamic environments to deliver exceptional outcomes.

Mohammed Brueckner

Clean out tasks marked done

Power Automate is just great for managing inbound messages and events - be it lists or, like in this case, mails. inbound invoice e-mails

In my case I am checking for taxi receipts coming in via e-mail attachments. Make sure “Include attachments” is turned on.

Beyond some boiler plate details like initiating variables I am checking here for the type of ride service and do add some prefix/suffix based on that, together with the time of the day (using Convert To TimeZone). switch clause in Power Automate

What you basically want to make sure is that you end up with a unique file name for your attachment because sooner or later those files could end up in the same directory somehwere. (In my case I am stashing them all into the same OneDrive folder, in fact. Good practice? Well I am not talking about hundres of thousands of files there so I am not worried.) switch clause in Power Automate

For generating unique file names you can always take advantage of the unique attachment IDs for example, like I do in this example: slice(outputs('Get_Attachment_(V2)')?['body/id'], -6)

What I would like to do is create an attachment in my personal OneDrive and a new Todo together with it. Why? Simply that will make using it later on for uploading a receipt to the Expense management system so much easier - just follow the link to the file, upload it, done. (Yes, this part would get a lot more complex and eventually would come down to having a very good understanding of the Finance Management solution used including APIs.) store attachments on OneDrive and create link shares And some tweaking and creating the Todo: switch clause in Power Automate

And that’s it. Now I can safely delete the mail, the attachment is stored and linked to. I could in addition create a OneNote entry, if I wanted.

Want to learn more? Check out my many other articles:

Advanced Automation using Azure & serverless services

And even more:

LinkedIn > LinkedIn Articles about Business & Tech

Medium > Articles about detailed topics around Cloud Computing and more

DevTo > Even more detailed articles on topics like using AI Services

Cheers! Mo