Microsoft Planner @Mention and Comment Notification in Microsoft Teams - NEW VERSION
Hi Planner Community, Thank you for the overwhelming support for my original post last year on how to @mention someone within the Microsoft Planner community and have a message automatically emailed to them. I'm excited to share that I've completely redesigned and updated the solution to now support the new Microsoft Teams Planner and remove the issues some users found with setting up the solution. Additionally, the notification is now an adaptive card within the Microsoft Teams chat to the user you @mentioned in the Microsoft Planner comment. Screenshot example above shows a comment posted by me in a Microsoft Planner task where I’ve @mentioned David at the end of the message. Screenshot example above shows the comment posted by me in Planner being automatically sent to David (thanks to the @mention in the comment) on Microsoft Teams. Allowing David to reply in either the traditional Planner or new Teams Planner. Attached is a zip file containing the Microsoft Power Automate solution, along with a detailed walkthrough to help you set it up. Enjoy! If you download the solution, all I ask is that you please give this post a thumbs up. Thanks, everyone! Matthew Davis No More Bad MondayAutomate your tasks with the Automate tab—now in Excel for Windows and Mac
The Automate tab is growing beyond your web browser and onto your desktop! Starting today, the Automate tab is now available for all eligible users in Excel for Windows and Mac. Previously, this tab was only available in Excel on the web.
Excel Does Not Sync Until Opened
I created a form linked to an Excel spreadsheet in SharePoint as well as a Power Automate approval flow triggered on submission. In addition to sending out confirmation/approval emails, the flow also updates the associated Excel spreadsheet with the approval/denial. The flow was working fine until last week but since then has failed 2 consecutive times. The failures appear to be related to the flow unable to find the automatically generated submission ID in the Excel spreadsheet. When I open the linked spreadsheet, the submission is not immediately present at first but the file does sync at that point and the entry appears. When re-triggered after the sync, the flow completes successfully. Not sure if it is related, but MS form/linked spreadsheets have been updated by Microsoft recently and I was prompted to go through an update process for synced Excel spreadsheets. I completed the update with this specific form last week after the flow failed for the first time. TLDR - my form only syncs with the spreadsheet once opened. Any ideas how to get MS Forms to update the spreadsheet in real-time as opposed to when it is opened?
Conditional Form Questions - For multiple answers in a "choice" question type
Hi I've been trying to find a way to have nested conditional questions in a form so only appropriate questions are being asked based on previous responses. (It doesn't look like branching is the answer to this situation) I have the following question in a form; What I'm trying to achieve here is when a responder selects option 1, a new section of questions appears for them to fill out. If more than 1 option is selected, then a set of questions should appear for each response (but should not be shown if the option is not selected). For example, in the image below, this section should only show up if option 1 in the above question is true/selected, then questions 6&7 should only appear if their respective response in question 5 is selected. The output from this form will be piped into a power automate flow and therefore we want finer granularity in the questions. If this is currently doable, can someone please enlighten me? If this isn't currently doable, can someone please tell me a good way of submitting this as a feature request as I think it would make Forms a much more powerful tool?
