we've had Office 365 since a few years now, yesterday I started playing with the Teams Apps to see what can I do with them and I came across Power Automate. Pretty quickly I understood its potential. I'm a Civil Engineer, I design structures, so I don't do any programming at work.
So the same day I found about this tool I came up with an idea to automate one task at the office we usually have to do. When we receive e-mails with attachments for a certain project we copy the e-mail and the attachment to a project "incoming" folder for storage (an additional precaution). The folder name is usually in the format "YYYYMMDD Title_of_the_e_mail".
So now I'm trying to use Power Apps to automate this task - I got to the point where I can save an e-mail to a folder with its name as the current date, the email copies itself there with the extension *.eml along with the attachment as a separate file. I do this using my onedrive now.
I have two problems:
1.How can I name the folder in the format "current date + title of the e-mail"? I tried creating two variables set as String type and use another variable to glue them together with the function 'concatenate', as seen on the screen: https://imgur.com/hluH34n.
The version where I only had the folder name worked when I inserted the line formatDateTime(utcNow(),'yyyy-MM-dd') as a function in the action where I type in the save-file destination: https://imgur.com/iajeVk6 So I tried doing the same with the 'variable 3' - the variable where I use the function concatenate, as seen here: https://imgur.com/KRiEnVk
And it didn't work 🙂 I admit I'm wandering in the dark here, I'm not a programmer, I used to learn C++, later a bit of VBA, but that was 10+ years ago. Also I don't have a debugger here, so I can't even test the content of the variables.
2.The other problem is saving the files to our network drive. I installed the gateway, then I was trying to use the "File System" connector. At first I tried saving the files to my local HDD, but even though I correctly specified my username credentials, password and gateway name I get an error message: "Cannot create connection for the connection Identifier ...". I have no idea why, I asked our IT guy, but he's not familiar power apps. He is the admin of our Office 365, is there a setting somewhere that maybe disables this functionality? I checked the gateway, I ran the connection test, it showed that I was connected.
Can anyone help me out? If not, then I'll just try to crack this on own and probably spend a few more days on it, but I thought that it might be a lot less painful if I just asked here.
Solved! Go to Solution.
Hello, point 1 is no longer valid. Just spent 30 minutes reading and I finally used the function string() in the date variable, them for var 3 i used the function concat(variables('Data'),variables('Temat')).
I still have a problem with point 2 though..
I'm subscribed to these:
That is possible. I am lucky, where I work IT has all of this licensing stuff taken care of and it is transparent to me.
Here is a link I found to the pricing.
You need to hold your IT's feet to the fire and have them understand the infrastructure requirements. You use the tools they, own the toolshed.
Sorry wish I could be more help.
Actually, You did help me as my question was answered. So thanks 🙂 Now I just need to talk our IT guy, if he has a tool to sync between onedrive and our network drives, can we buy other software that can do that (for example AOMEI Backupper), or we just subscribe to a Power Automate plan.
Check out the new Process Advisor community forum board!
Check out new user group experience and if you are a leader please create your group
Participate in the Power Virtual Agents Community Challenge
Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.