Видео

I believe that all the actions are available in the standard Power Automate license. Many of the items are variables to keep track of all the logic.

It sounds like your logic to compare the current date/time with the last time the notification was sent is not working. I would go to around 17 minutes into the video and make sure your varTicksLastNotified variable is being set correctly. You can check the values and do the math yourself to see what might be going wrong. Hope this helps.

@@jeffrhodes Thanks for your quick response. Currently, while setting the varTicksLastNotified variable I did faced a issue which is - While typing values, I selected function and typed ticks () then when I tried to search for Date Last Notified from Dynamic content, it was not present in the drop down to select from as it was only showing body & Value under Get files( properties only) ....Using Get files( properties only) because I am creating flow for library. If I do not type ticks() under function, then Date Last Notified is displayed in drop down under Get files (properties only).... Hence I typed manually" ticks(items('Loop_Through_Items')?['Date_Last_Notified']) and it's saving the flow without error If I try to type ticks(items('Apply_to_each')?['Date_Last_Notified']) , then flow is showing error stating - "Flow save failed with code"Invalid Template " and message ' The template validation failed: the repetition action(s)' Apply_to_each ' referenced by' inputs' in action ' Set_varTicksNotified' are not defined in the template'... Please help as unable to proceed 😭

@@jeffrhodes Thanks for your quick response. I tried to check the values but unable to help myself resolving the same Would like to share that while typing values in varTicksLastNotified variable I did faced a issue which is- While typing ticks () in function and then tried to select Date Last Notified from Dynamic content, couldn't find in the drop down as it only showing body and Values under Get files (properties only).... Get files (properties only) because I am creating flow for a library. If I remove ticks() from function then can find Date Last Notified under Get files ( properties only) drop down. Hence I typed manually in the function- ticks (items ('Loop_Through_Items')?['Date_Last_Notified']) and flow is getting saved without any error. But if I try typing ticks(items('Apply_to_each')?['Date_Last_Notified']) then it's showing the error while saving which is Flow save failed with code 'Invalid Template ' and message ' The template validation failed: ' The repetition action(s) 'Apply_to_each' referenced by 'inputs' in action ' Set_varTicksLastNotified' are not defined in the template'... Please help me to achieve the same

@jeffrhodes Thanks for your quick response. I tried to check the values but unable to help myself resolving the same Would like to share that while typing values in varTicksLastNotified variable I did faced a issue which is- While typing ticks () in function and then tried to select Date Last Notified from Dynamic content, couldn't find in the drop down as it only showing body and Values under Get files (properties only).... Get files (properties only) because I am creating flow for a library. If I remove ticks() from function then can find Date Last Notified under Get files ( properties only) drop down. Hence I typed manually in the function- ticks (items ('Loop_Through_Items')?['Date_Last_Notified']) and flow is getting saved without any error. But if I try typing ticks(items('Apply_to_each')?['Date_Last_Notified']) then it's showing the error while saving which is Flow save failed with code 'Invalid Template ' and message ' The template validation failed: ' The repetition action(s) 'Apply_to_each' referenced by 'inputs' in action ' Set_varTicksLastNotified' are not defined in the template'... Please help me to achieve the same

@@subhadas9852 - I've run into issues like that with formulas. You might try creating a new variable for the Date Last Notified and then use that variable in the formula. I've had that work before.

I actually cover that part within this video. Go to around the 14 minute mark for DocuSign and the 41 minute mark for Adobe Sign. Both are similar in that you create a flow for listening for the signing and other events. You then grab the ID and use that to look up the correct SharePoint list row. Then update it with the signed form, status, etc. Hope this helps.

I would look closely at your Condition statement. Something like being case sensitive (Completed vs. completed) or not getting the Value of a SharePoint choice column could cause a message like this. Hope this helps a bit.

@JamesFerguson-gc8je - this example assumes a spreadsheet from a learning management system or other source. But a form to update status would work with Power Apps but not Microsoft Forms, since only Power Apps can update an existing record. I will put this on my "to do" list for videos.

I've added a video that will hopefully help with how to add a form to edit the status: ruclips.net/video/hGE6LNPOadk/видео.htmlsi=Qx8U6BQC9qUkLI4E

Thanks for the kind words. I haven't done this but it looks quite possible in both DocuSign and Adobe. This link for DocuSign might be helpful: support.docusign.com/s/document-item?language=en_US&rsc_301=&bundleId=ulp1643236876813&topicId=kcb1578456479440.html&_LANG=enus. For Adobe, I think you would do this right within Adobe Acrobat Pro and select as a Signature 2 field. This link about the Adobe Portal might be usefu: helpx.adobe.com/sign/using/send-document-for-signature.html#:~:text=Adobe%20Acrobat%20Sign%20makes%20it,to%20multiple%20people%20to%20sign.

These get really tricky. Since you are don't have to look up the value in another list, you should be able to just stick with the Concat() function. This works for me: Concat(ThisItem.'Assigned To', DisplayName, ", "). Hope this helps.

Yes. That makes good sense. I'll put a video on the "to do" list. In the meantime, this video shows the basic concept: ruclips.net/video/6qdqlcmV5sA/видео.htmlsi=2Z60QD1xYbdhEj6U. Rather than sending the email right away, you want to capture all teams missing the deadline and append it to a variable. Then send the email whenever the manager changes in the loop (e.g., you get to the next manager or end the loop). That in turn means that you will want to sort in the Get Items action by the manager email so that all of a manager's tasks sequential.

Sure , i ll definitely watch this. The challenge i am facing , each manager is leading 3 to 5 teams total 30 teams. First reminders ll go the Level 2 manager for each line in the table( each team represents one line in the table ) . I have done flow up to this step My challenge starts from here >>> If Level 2 manager doesn’t update the task status than it ll escalate to Level 1’s manager. (There are four level 1 managers oversee 10 level one managers and their teams ) I am attempting to send one consolidated email to level 1 manager for only those teams which he/she oversees and they did not update the task status after first reminder to level 2 manager. Many Thanks for all the support n guidance

There are two Case 5's in the Adobe Acrobat Status flow. The first is "AGREEMENT_ACTION_COMPLETED". It then has a case for SIGNER, APPROVER, ACCEPTOR, FORM_FILLER, and CERTIFIED_RECIPIENT. For all of these, I just update the Message variable to log the agreement name and participant. For example, here is the value for CERTIFIED_RECIPIENT (case 5): Notification from Microsoft Power Automate The receipt of the Adobe Sign agreement @{triggerBody()?['agreement']?['name']} has been acknowledged by @{triggerBody()?['participantUserEmail']}. Hope this helps.

Thank you @@jeffrhodes 👍

Glad this was helpful!!

Great question. You could do it a few ways, but I'd add columns for the manager email (possibly name as well if you wanted to address the email to the manager) and then the date sent to the manager. I would then edit the logic within the loop where there is already a "Date Last Notified." After checking if a week has gone by, I would check if the "Manager Date Last Notified" is blank. If so, I would send the email to both and then update both dates. If the "Manager Date Last Notified" is not blank, it should be the same date as the "Date Last Notified" and thus you would keep sending to both from then on. Hope this helps.

@@jeffrhodes I have tried but looks like my logic is not working. The first time when notification is supposed to go only to team members but it is also going to to manager's as well. I am not sure where my logic is wrong. I would appreciate it if you could provide more guidance or do a small vided to add an escalation process. I am attempting a flow where we have various teams under different manager's and if a team lead doesn't update the status then in the next reminder a cc email should go to their manager as well. Thank you very much in advance I am following the model of your other video here ruclips.net/video/YYOcPrgAAyg/видео.html I have columns in this sequence. ID First Name Last Name Email First Name 1 (For Managers) Last Name 1 (For Managers) Email1 (For Manager's) Status DateLastNotified Notes M_DateLastNotified (For Managers) M_Notes (For Manager's)

@@nomirehman - I will put this on my "to do" list for a video on this. Hopefully this upcoming weekend.

@@jeffrhodes Great !! I ll be looking forward to it. I appreciate all the support. Thank You

Great to hear! Thanks for taking the time to leave a comment.

Thanks for the kind words and for checking out the video!

Thanks for taking a look and for the feedback. I'll see if I can create a scaled back example targeted at beginners. Thanks again.

Good to hear!!

Your comment made my day. Thanks for the kind words!

I haven't tried it, but I would think that Power Automate would interpret the value as text even if it is generated via a formula. Come back and comment if you have time when you try it.

Glad this was helpful. Thanks for leaving a comment!

​@@jeffrhodesi'm having this issue where in if the value has period(.) in between (ex.jessa.p.p) it's not shown in the email :(

Glad it was helpful!

Great to hear and thanks for the comment!

I think I understand. The challenging part is making sure you don't inadvertently send too many emails. If the statuses are pretty well defined, I would go with a separate date column for each one. Is if one of the statuses is Update, I would have an UpdateNotificationDate column. So if the flow sees and Update status and now UpdateNotificationDate value, it sends an email and writes that date/time. The next time around, the flow looks at the UpdateNotificationDate and compares to the current date to see if the required time has gone by. If not, it skips the notification. If so, it sends another email and writes the new date to the column. The similar things happen for the other statuses. Hope this helps!

You can do it via the tags like I did in the video, but better looks to be to use Adobe Acrobat DC to configure the form template itself (and use a PDF rather than a Word document).

@@jeffrhodes thank you for your help

Thanks for the kind words and for taking a look!

Thanks for the note. Power Automate typically puts in an 'apply to each' loop if it thinks the result of the previous step could have more than one value. I would try just moving the 'Send an email' option outside the 'apply to each' loop if possible. If not, keeping it there shouldn't cause a problem if you indeed only have one value. Hope that helps a bit.

Great to hear. Thanks for taking a look at the video!

I don't share the SharePoint list unfortunately, but here is a link to a screen capture that shows the SharePoint list settings: plattecanyon-my.sharepoint.com/:i:/g/personal/jeffrey_plattecanyon_onmicrosoft_com/EUIOox2bPnxLmPno1Ru7lC4B4GbA7ItaUVHs2VabkesAQQ?e=9H03e2. Hope this helps.

Glad this was helpful!

Thanks for the kind comment. If you are using a personal form, then the original attachment will still be in OneDrive. If you are using a group form, the attachment will be in the default document library for the SharePoint site associated with that team. So it doesn't move the file but rather copy it to the SharePoint list item. Hope this helps.

@@jeffrhodes yes. Thank you very much.

I had not heard that. Thanks for letting everyone know.

I'm not using that FindMeetingTimesV2() action, so I'm not sure what the problem is. Looking at the documentation of that action, it looks to me like it would do the time zone translation for you. So if I am U.S. Central Time and you are U.S. Eastern time and my calendar is open at 10 AM and yours is open at 11 AM, that should match.

Glad the video was helpful to you!

All I can think of is some sort of client-side setting. Have you tested by sending to yourself like I did in the video. Downloading and signing it pretty much defeats the purpose of course:).

I can take a look. What is your use case?

@@jeffrhodes How to build a power automate flow that finds available meeting times and locations for a set of individuals within the organization. The flow should utilize Microsoft Graph. The flow should take as an input the individuals and the date(s) they wish to meet. The output should be a list of available times and locations.

@@jeffrhodes it's almost same what you have done but I need this type of scenario

@@jeffrhodes hey Jeff...did you checked my use case.

@@KSRDA - I haven't done much yet with Microsoft Graph. So I'm not much help on this use case at the moment.

Glad this was helpful! One approach if you need to email out a link to the attachments is to use the URL to the attachment(s) where Forms stored them. You would need to open up that folder so that the user has access. I prefer that to giving a link to the attachment within the SharePoint list item, as I typically don't want to give the email recipient access to that.

Glad it was helpful!

I didn't have much luck comparing date/times, which is where ticks() comes in handy. I looked at my Flow again and I am using a Power Apps parameter that is formatted as a date already. I didn't have to put it into ISO 8601 format. I did manipulate it with the addHours(0) and addMinutes() functions. My guess is that you may have a string rather than an actual date. Maybe try formatDateTime() and perhaps Compose() to make into a valid datetime? Hope this helps.

Hard to say I would debug the flow and look closely at the address to make sure there are no stray characters. Either of these should send to any email address.

Great question. The first thing you would need is to have access to the calendars for each colleague, preferably to see the actual appointment titles so that you can look for planning time. I'd probably loop through your calendar and then check each of their calendars for every open spot on your. If a time is open for all three, then you add it to the open list. Hope this helps.

​@@jeffrhodes I think this should help, I was thinking in the same lines aswell, I would try it out today it self. Thank you so much on your quick reply. It was very urgent for me. I mean it.🙂

Glad it was helpful!

@@jeffrhodes 100%. It works perfectly!

That's a good question. I don't know the answer but it seems likely that copying it to the new list and deleting from the original list would lose the version history, If anyone knows or has a suggestion, please jump in.

Thanks for the nice feedback. I would think you would just repeat the steps for each upload question (e.g., do them sequentially). But I don't have a video for this. Let us know what you figure out!

Your comment made MY day. Glad the video was helpful to you!

Thanks for the kind words and the book purchase! If the user doesn't need to edit the information after submitting, then a Microsoft Forms - Power Automate - SharePoint list solution should work well. You can use Power Automate to copy each form response to SharePoint as in this video: ruclips.net/video/Lb2pLnL7Uu4/видео.html. The hardest part will be getting the attachments (training certificates). Do that in the same Power Automate flow right after you create the item. This video should help with that: ruclips.net/video/5IyCVHqvIXA/видео.html. Hope this is helpful.