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.
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).
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.)
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.)
And some tweaking and creating the Todo:
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