Forum Discussion
Emails with attachments getting numbers add to the attachment
- Jul 27, 2020Instead 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..
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.
- Richard_MalteseAug 12, 2020Copper Contributor
Tried that with the with and with out the get file properties and still go the same result.
- Aug 12, 2020
It says Name in the condition, run it and see what Get File Properties is returning for those fields. (filename with extension)
- Richard_MalteseAug 12, 2020Copper Contributor
ChrisWebbTech
Creating a new one fixed that one message however still looks like its failing.I added back in the get file properties under the trigger as well and that still failed. I tried with Name and file name with extension.
- Aug 12, 2020I don't know how you went about replacing the trigger, but it should work fine, you might just create a new flow? That trigger is the one you need to use thou it should be under the sharepoint connector when selecting your trigger.
- Richard_MalteseAug 12, 2020Copper Contributor
If I run the test it give me the following snip at the top.
- Richard_MalteseAug 12, 2020Copper Contributor
ChrisWebbTech That doesnt let me get past the trigger it give me the enter a sharepoint message i posted above.
- Aug 12, 2020Actually, replace your trigger with "When a file is created (properties only)" you don't need the entire file since you are using an http trigger to rename and you aren't doing anything with the binary bits. That one will supply the proper file name.
- Richard_MalteseAug 12, 2020Copper Contributor
Okay trying what you recommended however it requires and ID under the get file properties so when digging into that one thing I found said to get the metadata file before the get file properties but that then wants map to a specific file in the folder. Maybe there is something I'm over looking at this step. And every time I add that in I get the last screen shot here. From what i read that means somethings is broken in the process from the trigger to that next step.