Issue with Compose Sub Folder

(0) Share

Report

Posted on by jslsmithyx

Hi guys,

New to Power Automate & the community so please let me know if I've posted this in the wrong place!

I'm attempting to follow the below guide which is for creating a flow so that tasks are created in MS Planner off the back of outlook emails (including attachments)

https://www.alanps1.io/power-platform/flow/flow-create-planner-task-and-include-attachments-from-outlook-email/

I've followed the guide to a T, however the Flow Checker is returning this error & I'm unable to work out where the issue is:

'correct to include a valid reference to 'Get_Email' for the input parameter of action 'Compose'

This is in reference to the 'Compose Sub Folder' section of the guide, where I am inputting the below code into the inputs section:

'concat(variables('TimeStamp'), '-' , body('Get_Email')?['Subject'])'

Would really like to get this Flow working & would appreciate any help on the matter.

Tagging @AlanPs1 as advised in the comments section of the guide.

Thanks in advance,

Joe

Categories:

Building flows

I have the same question (0)

All responses (20)

Answers (1)

Sort by

Verified answer

efialttes 14,756 on at

Like (1)

Report
Copy link

Link copied!

Hi

Right place to post!

Can you share a screenshot of your flow design?

Without it we are almost blind.

But just guessing... why don't you try

'concat(variables('TimeStamp'), '-' , body('Get_email')?['Subject'])'

Please note I am not using a capital letter for Email

Thanx!

Was this reply helpful? Yes No
jslsmithyx 97 on at

Like (0)

Report
Copy link

Link copied!

Thanks so much for your speedy reply.

I'd like to confirm that your suggested code seems to have resolved the issue (the difference not having a space can make, ey)! Not getting any more Flow Check errors, just need to test & make sure it works as expected.

Once again thank you!

Was this reply helpful? Yes No
efialttes 14,756 on at

Like (0)

Report
Copy link

Link copied!

@jslsmithyx

Thanx for your kindness! The time spent marking this thread as solved will for sure help others in the future

Glad it worked

Was this reply helpful? Yes No
jslsmithyx 97 on at

Like (1)

Report
Copy link

Link copied!

No problem! I'm glad the community is so responsive, as I plan to do a lot more stuff with Power Automate

Was this reply helpful? Yes No
jslsmithyx 97 on at

Like (0)

Report
Copy link

Link copied!

One more thing (sorry to keep revisiting an already closed post) but I've noticed one more thing which I'm a bit confused about.
For some reason, the Flow I've built is recognizing pictures embedded in email signatures as attachments, and is provided links to these in the planner task along with the attachments themselves (the pictures are also being uploaded to the SharePoint location?). My company used about 7 images in our signatures so it means an additional 7 attachments per Planner task which is looking a bit messy. Please see attached - any ideas? Happy to provide my full flow if that'd help.

Embedded pictures as attachment being uploaded to chosen sharepoint locationembedded pictures as attachments being uploaded to planner task

Thanks so much again

Was this reply helpful? Yes No
efialttes 14,756 on at

Like (1)

Report
Copy link

Link copied!

"For some reason, the Flow I've built is recognizing pictures embedded in email signatures as attachments"

Hi!

As far as I remember this is a Power Automate old limitation. THere are several threads discussing worarounds, one of the most populars is to add some sort of condition/filter array to removes the files whose extension is of type image, ... or the opposite, if you expect pdf attachments olny, just get the ones ending with .pdf

https://www.c5insight.com/Resources/Blog/tabid/148/entryid/871/video-how-to-filter-email-attachments-with-microsoft-flow.aspx

Hope this helps

Was this reply helpful? Yes No
jslsmithyx 97 on at

Like (0)

Report
Copy link

Link copied!

Thank you for your reply - again 🙂

I had a tinker around on the weekend, reviewing threads & trying to set up a filter to exclude .gifs from being uploaded to Sharepoint & linked to the Planner task but so far no luck 😞

Above is a capture of the 'if' condition I believe is responsible for identifying whether there are attachments included on the email & whether these would be uploaded. The code for the 'Equals to' function is:

equals(body('Get_email')?['HasAttachment'], true)

If its not too much trouble, do you think you may be able to advise what this code should be to include all attachments except .gif files?

Thanks for your help so far!

Was this reply helpful? Yes No
efialttes 14,756 on at

Like (1)

Report
Copy link

Link copied!

Hi again!

I think both not() and endsWith() can do the magic you need, so it's just a question of identifying the trigger output providing attachment name with extension

In this thread you will find the opposite approach, they iterate through all attachments, and take the ones with a specific extension.

https://powerusers.microsoft.com/t5/Using-Flows/Filtering-attachments/td-p/188539

Hope this helps

Was this reply helpful? Yes No
jslsmithyx 97 on at

Like (1)

Report
Copy link

Link copied!

Managed to get it all working with your suggestions! Annoyingly the Flow is saying its failed even though all ticks are green for all scenarios etc but this is livable as it doesn't affect the flows functionality.

Thanks very much for all your help!

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hello,

I am having issues with the expression
concat(variables(TimeStamp'),'-',body('Get_email')?['Subject'])'

It continues to give me a invalid expression, any help would be appreciated.

Was this reply helpful? Yes No