You can follow this variant of the last video you watched which talks about when there are multiple attachments. You'll get them all linked in 1 task! kzbin.info/www/bejne/e2GUfGqArL6cbs0

Yes, I believe if you use a slightly different trigger - When an email arrives in a shared mailbox (v2). You will need permissions on that mailbox but should work for you in the same manner.

Glad it was helpful!

To save the email itself would require interaction with the Outlook application which a cloud flow cant do natively. However, that said, Power Automate Desktop can interact with your apps and can also be called to take action from a Cloud flow. So its potentially feasible. Licences would be needed for that as it is what's called RPA (Robotic Process Automation). There are potentially also other solutions to automatically save emails to a location now we have Agents within Microsoft 365 so that's one I might explore in a future video. Will tag you in as and when I get to that one.

I'll have a look into that. Seems to happen for some. Really odd. As an alternative, if there are subjects that indicate an email for planner ..that's easy to grab direct from the inbox. Will do a video of I can see what's happening for you.

Doing some research, apparently the trigger is a little unreliable - this is what one post said "However, it doesn’t seem to be reliable. You might need to write a trigger that runs on a timer instead and just accept that there will be lag." The idea of a scheduled flow that reads a folder might be a good option then. Using Get Emails instead would allow you to target the folder. You would need to then cycle through each using an Apply to each. I'll do a video for this if you like as it's a little different.

Also, Would this only work if the app is left open? What would happen if the app was closed once the timer has started?

Absolutely. It's rely just about connecting to date wherever it is. The syntax for Dataverse work is slightly different but its not too hard to figure out.

There is an issue with knowing about the times when opened and closed when the app is effectively killed off in memory. There are workarounds but we haven't got a video on those yet.

@@Collab365 I'd be first inline for that one. My alternative is to have a two separate forms, one to start and one to finish linked by the primary key (A scanned QR code in my case) and then i plan to use a roll up column to calculate them, referencing the user email and qr code.

@TimRiley-m5w new video incoming on Sunday evening for one solution we have found to the problem. Interested in your thoughts and whether you'd want to see how we've done parts of this. Nothing too complex, just a rudimentary 'state' saved to the SharePoint list so it knows if the app has crashed or been closed during a time recording activity.

Glad you liked it!

thats right. Its updating where you want an update. If a value existed in a field, it would still overwrite if that's what you instructed the action to do. However if you don't add a new value, what's there remains.

Yes I wanted to show a few angles on this same use case. Hope they both helped!

Sounds like I need to add that tip on. Somewhere. Thanks James !!

Hope its helped. Lots more to learn in PAD but its a great tool

Glad it helped!

Glad it helps. You can do something after you first of all run the 'create a task' if you dont mind whether there is an attachment or not (to avoid all those attachment tasks). What you can do is place a condition as the 2nd step in the flow. In that condition you will want to test whether there are attachments or not in the email that just arrived. So to set this up, your condition has to have a new test to look for ANY attachments. Set it up with the left hand side containing the 'Has Attachments' Dynamic content from the 'When A New Email Arrives (v3) trigger'. Have the test set to equals and the right hand value equal to 'true'. You are saying 'are there any attachments on the email yes or no?' Now with this in place, move the whole of the next Apply to each into the true leg. Setting up what to do if it finds any and also to decide what kind. This will now read, if an email has ANY attachment, what sort is it? If its a genuine one, apply the steps to get them and add them to the task. Otherwise, don't. Back in the false leg of the first Condition check (are there any attachments) you can simply have update task details as all you want is to add information to the existing planner task. If you also want to update the task details when there are attachments but they are just inline images (catering for all scenarios) then you can also add the update task details to the True leg of your original Apply to each loop - which is now inside the one where you test for Has Attachments. There are other ways but if this makes sense to you, have a go and let me know how you get on? Good luck :)

@Collab365 thank you unfortunately I couldn't get this working based on my understanding of your response, but that is probably more down to my technical ability. Maybe a topic for a future video 🤔😁

@wildo809 I'll add to the list for sure. Removing manual steps is one of the super powers for Power Automate so anything I can do to help, happy to :)

Hmm that sounds odd. I do find in the first test I did, it took a while for the Power Automate trigger to wake up from a move of an email but so long as you are connected to the correct folder, it should work. It's worth checking the connection you are using. Is it an authorised user of the outlook mailbox you are monitoring and have you selected the specific sub folder in the trigger action?

Thanks for the visit

When you create the entry in the Document Library using the 'Create File' action and store the Email 'Body' Im assuming in a column, you have the details available then in dynamic content from that action. When you get to the 'Update task details' action, the second field should be 'Description'. If you click dynamic content, you should see the 'Description' column from SharePoint (you might have to click 'See More' on the action...always catches me out). If you are stuck and also a member of the Academy, I'd be happy to pop into a quick call to help if need be. Just DM Jon Manderville in the Academy.

really glad you got it working ok. Yes the group is the important part to be able to see the Planner itself. Thanks for sharing how you got around it.

glad it helped. Always open to other videos where people get stuck - if I can figure out the answer ;)

Nvm. This randomly started working. 🤷‍♂

thats happened to me before. All these videos are solutions that will work as I'll have built them to do the recording however, we do see changes from time to time where MS have changed the way a connection works or an action...which breaks them :( glad this isn't that!

Glad it helped!

@brandoncox469 what are the symptoms for you? Can you still see and create an instant flow in your Power Apps Studio? It's working for me still so Im interested what the challenge is for you.

Similar experience here. My instance of using the Run() function in PowerApps that's associated with a related Flow will not allow the entry/passing of any arguments. I get the error, "Invalid number of arguments: received 1, expected 0."

I've seen that error myself. Let me see if I can replicate to know what might be happening for you

@@mikeontko15 I ran into this - you need to add inputs in the power automate trigger, save the flow, refresh the flow in power apps, and the .Run function will expect the number of inputs you created in power automate.

The syntax in the .Run command is slightly different now. For example, I have a flow where the power apps trigger has 4 text inputs, labelled Label1/2/3/4. To reference those inputs with the power apps button, the command looks like this: FlowName.Run(Label1.Text,Label2.Text,Label3.Text,Label4.Text)

please do :) spread the word. We have lots more vids you can enjoy we hope

@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.

Hi, we've seen a lot of change over the last year in Power Automate. We'll re-run the solution and update - hopefully answering your questions as we go! Will pop an update real soon.

I hope this version is easier to follow. Pop any questions in and we can help you get working :) kzbin.info/www/bejne/gpCsqWSMd7B3mJY

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.

you could potentially edit the JSON to include the original record author if you wanted that to be included. it will be a piece of data in the original record in the event list.

yeah I think the unavailable part is potentially the new designer. Im going to have a play and yes, agree, it makes a lot of sense to cut out un-necessary calls. Im working on a test to see if I can train an AI model to ingest Power Automate flow JSON at the moment and evaluate / provide feedback. If I can see it working even to a small degree, I'll do a quick vid to gather thoughts. Imagine everyone having a James in their pocket to lend a hand! :)

I'm about to post a replacement for this as well which simplifies the flow somewhat. I'll add the link back to this vid as well so you can find it but the new one is much more efficient at completing the task in hand. thank you to @wjameswilliams for pointing that out :)

ha. yes most likely!

will do! its now on my list :) keep watch for it popping in.

I have a question for you in your use case @davidnelson8495 For your filenames, are they all the same in terms of format i.e does every one have the same length name with the same number of characters at the end representing the date? I ask because removing say 16 chars from the end of every file is quite routine. However if there is a lot of variance to how the date is formatted, it can sometimes be more sensible to reach for a slightly different solution. Let me know and I'll share the simple and then a more complex option if you are prepared to pay for what's called a premium licence in Power automate (unlocks an ability to use Power Automate Desktop where a great option called regular expressions can be used to dynamically spot and filter out dates from any string)

That field is present because I added the column into my Document library. It was my mistake that I called it 'generic across documents' because it isn't. It's only there if you add as a column in the library. Pop a video in to clarify how you set that up. Apologies for that!

I've popped a video in which I hope will help kzbin.info/www/bejne/mImviXaIZpuMoas

Yes during the demo, I had been messing with the flow :) Always good to remember you can turn off your flows though if you have finished testing and want to wait to enable them

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!

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 demo was for a Team site. The options for Communication and Team sites are different and you may not see a vertical section depending.

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 :)

Glad you liked it!