Forum Discussion
Emails with attachments getting numbers add to the attachment
- Instead of utilizing the email function to Teams, I would setup a Power Automate Flow that has a trigger that monitors an inbox, and a step that posts / uploads the file in it's place. Then you can name the file on the step you use to upload the file from the inbox trigger to the Team and utilize a date expression in the save to sharepoint (team) step..
Again thanks for the help on this!
Youtube search for flow stuff, Laura Rogers Flow should net a ton of content, she does a good job of explaining. Here is a quick mock example of how I would do it, it's just a few steps, when a file in a folder is created, you add your SharePoint URL and folder the channel stores it's files and it will trigger. Then a condition to check if the file name starts with Reporting Schedules_, and if so, then you do an http sharepoint request to rename the file, I tried putting where you would put your document library names in, and at the end, I messed up the screenshot, but you would static in whatever you want the file name then the "formatdatetime(utcnow(),'MM-dd-YYYY') expression would append the date you want, I don't know what you want here, but you would have to mess with expressions to get the name how you want, that example is to just name the file by the current date it runs.
Hope this helps!
ChrisWebbTech I hate to bug you but I think i messed something up here. Below is my flow. However when testing or running it, it wont work i get the second image below. It shows it was successful but doesnt seem to be based off the message on the Yes Condition.
- Your condition is not being met, so the begins with isn't matching or going true to run the HTTP request. Need to click on the trigger action there at the top and see what the filename is returning as for that flow, you might need to adjust that logic.
ChrisWebbTech Thanks for taking more time to help with this. So I'm checking it but the file name it returns is UmVwb3J0IFN1YnNjcmlwdGlvbnNfMTA5NDY1MjEzNS54bHN4 and the file identifier is showing %252fShared%2bDocuments%252fNEST%2bSubcription%2bReport%252fEmail%2bMessages%252fReport%2bSubscriptions_1094652135.xlsx. Unfortunately I'm not sure what would need to be adjusted.