This worked fantastically for my test case. However, the client that's emailing me sends an xlsx attachment (which I want), plus another random attachment with no discernable file type (that I don't want). How could I capture only the Excel file and not any other file types? Great video, very helpful!
@MattLisikiewicz thanks for the thumbs up :) To answer your question, what you could do, is either replace the "IsFolder" condition with a condition to test the file extension (and ignore anything that isnt .xslx). To do this you have a few options. You can do a bit of work before the condition to set these up. Use a compose and hook into and store the "Filename with Extension" property from the "When a File is Created (Properties only)" action. Using a little string manipulation you can slice off the .xlsx part and test only for that or use a "contains" when you test that piece of data in your condition. Either way could work. If you need a little more help and are an Academy member, pop me a DM and I would be happy to schedule a quick chat to help if needed.
Thanks for this! Is there a way to have the flow save all attachments and have them stored under one single planner task? At present mine is creating separate planner tasks for each email attachment.
It looks like every time, if we want to add email attachments in the Planner, we need to put email attachments in the SharePoint first, then we can add to the Planner.
Yes that's correct in this video. I could not find a planner action (even via the API) which will add files directly - they had to be done using a link (which could be any location that is accessible with a URL) However, there may be a way to do it directly using the JSON and file content. We just haven't tried to go that deep yet.
Hello thank you for awesome video :-). Pleace can you give me advice? I would like to also for each e-mail create a folder named as subject of the e-mail, so I can keep the files organized and not on one hoard :-).
that would be absolutely possible. Its just a case of choosing the correct action to do that within the loop. There is a "Create new folder" action which you can use and then using the Subject from the email, pop that in as the folder name :)
Hey :) Awesome video. But I have a question: If I try to follow your steps, I´m not able to create the task like you do it. I receive an error saying: Im missing some connection. SO I cant find my groups and plans. But outside of the condition it works. Do you have a hint?
Yes. that will be to do with the connection to planner service most likely. Are you able to navigate to any plans outside of power automate? When you first set up a planner task, it may ask you to set up permissions to planner. I'll see if I can replicate how that will work for you and give some advice.
This worked fantastically for my test case. However, the client that's emailing me sends an xlsx attachment (which I want), plus another random attachment with no discernable file type (that I don't want). How could I capture only the Excel file and not any other file types? Great video, very helpful!
@MattLisikiewicz thanks for the thumbs up :) To answer your question, what you could do, is either replace the "IsFolder" condition with a condition to test the file extension (and ignore anything that isnt .xslx).
To do this you have a few options. You can do a bit of work before the condition to set these up.
Use a compose and hook into and store the "Filename with Extension" property from the "When a File is Created (Properties only)" action.
Using a little string manipulation you can slice off the .xlsx part and test only for that or use a "contains" when you test that piece of data in your condition. Either way could work.
If you need a little more help and are an Academy member, pop me a DM and I would be happy to schedule a quick chat to help if needed.
Thank you for the video, it's awesome.
Glad you liked it!
Thanks for this! Is there a way to have the flow save all attachments and have them stored under one single planner task? At present mine is creating separate planner tasks for each email attachment.
Yes, I think that would just need to be a slight restructure of the flow. I'll have a look and pop you some ideas.
I am also wondering how to do this. Interested in if you find a solution.
Yep, I found a neat way to do it without much restructuring. I'll do a video and post it for you in the next week.
@@Collab365 super, thanks!
It looks like every time, if we want to add email attachments in the Planner, we need to put email attachments in the SharePoint first, then we can add to the Planner.
Yes that's correct in this video. I could not find a planner action (even via the API) which will add files directly - they had to be done using a link (which could be any location that is accessible with a URL)
However, there may be a way to do it directly using the JSON and file content. We just haven't tried to go that deep yet.
Hello thank you for awesome video :-). Pleace can you give me advice? I would like to also for each e-mail create a folder named as subject of the e-mail, so I can keep the files organized and not on one hoard :-).
that would be absolutely possible. Its just a case of choosing the correct action to do that within the loop. There is a "Create new folder" action which you can use and then using the Subject from the email, pop that in as the folder name :)
Hey :)
Awesome video. But I have a question: If I try to follow your steps, I´m not able to create the task like you do it. I receive an error saying: Im missing some connection. SO I cant find my groups and plans. But outside of the condition it works. Do you have a hint?
Yes. that will be to do with the connection to planner service most likely. Are you able to navigate to any plans outside of power automate? When you first set up a planner task, it may ask you to set up permissions to planner. I'll see if I can replicate how that will work for you and give some advice.