Great video as always Damien. Just to share that I do format the HTML table for MS Teams, I use the replace function to modify the string to add a border and a second replace to add the style attribute. In this example, I have created a HTML table, then used a compose to get rid of some unwanted characters from SharePoint and then this compose to provide a table using the output of the last compose - replace(replace(outputs('Compose'),'','
Great video, do you have videos when an email in a shared mailbox is being worked on by a colleague it creates a card in planner? This would be really helpful.
Howdy! I got this working fairly well except I can't get the hoverable table to work. I followed the instructions and verified I've copied the code for the hoverable table. It comes out formatted, but the hover doesn't work. Also, any thoughts to how to sort the date in ascending order from oldest to newest? Thanks!
Thank you for the guide on this! I have been looking for a way to do this for a few weeks with no luck. I am new to automation so this seems great to use. Unfortunately, each of my iterations always returns a "0" emails found in the response email. I have made sure to try this on a shared inbox and and my own work inbox but with no luck. I made certain I have at least 2-3 unread emails for the automation to find. Do you have any ideas on troubleshooting that I could follow?
First stop is the history of the get emails action. Is there something in the output? If not, check your settings for this action. Are you looking in the right mailbox, is it specifically unread emails? Let me know how you get on.
@DamoBird365 I am not seeing anything in the output, unfortunately. The value just contains an open and closed bracket. I'll run through my actions in some more detail. I haven't found a way to include images so this is my next best idea. *Only items with content are listed, all others are blank. Get Emails (V3) - Folder = Inbox - Fetch Only Unread Messages = Yes - Original Mailbox Address = Email is correct, and has been checked multiple times for certainty. - Include Attachments = No - Search Query = Received - Top = 25 - Importance = Any -Only with Attachments = No Create HTML table - From = Microsoft Outlook Value or **outputs('Get_emails_(V3)')?['body/value']** - Columns = Custom - Table created as shown Send an email (V2) - To = My email - Subject = Daily Email Alert - **length(outputs('Get_emails_(V3)')?['body/value'])** Let me know if you see something here that I can correct and thank you so much for your time in looking this over.@@DamoBird365
Could this be done to count the amount of emails in a specified category? For example: in a shared inbox there may be 1000 emails with 50 in category red for priority, 500 yellow for pending, etc etc.
Ooooh that sounds cool 😎 I believe get emails v3 is limited to 25 at a time but graph api might support this learn.microsoft.com/en-us/graph/api/user-list-messages?view=graph-rest-1.0&tabs=http and then you can use this video to sum/group etc ua-cam.com/video/z5MxbwURV68/v-deo.html
is there a way to do this flow with a shared inbox but for it to send an email with a count of total emails received or moved into a specific folder in the last 7 days?
This is really handy. I have set this up to monitor all of my shared mailboxes and my mailboxes at client Tenants. For every mailbox I created an Get Emails and Create HTML table action so mails from each mailbox gets presented in their own table. But with over 10 mailboxes to monitor this gets a bit messy. Is there a way to do a sort of for-each loop through all of the mailboxes and still present a resulttable for each mailbox?
Is it messy because you repeat the logic 10 times? If you created a data source of mailboxes to monitor, you could apply to each with the same logic and output the html tables as an array and then join() on br tags?
thanks, I'm going to try this out but I need to monitor for emails based on subject, say something like a daily check for emails with subjects that start with "Daily report" but with a wildcard after that. think that's possible?
Hi Damien Great video I do have a question though. I am trying to monitor a shared mailbox and emails need to be responded to asap. I have been using "When a new email arrives in a shared mailbox" However it gives me a 5 min recurrence limit, I cannot find a way around it as of yet Any advice?
Hi Damian - I always find your explanations really great and have already adopted a lot of them. Your example shows how to use one shared mailbox. Is it also possible for me to monitor several shared mailboxes and combine the mails from the respective mailboxes into one message? So not one message per mailbox but one for all mails from all mailboxes?
Hi, Thank you for this wonderful video. I need some modification as my requirement is a bit different. I tried different places, but it didn't work. I have a shared mailbox which is shared by 4 people. I have the following scenarios: 1) Whenever I sent an email related to the topic, I copy to this shared email address so that others can see it. 2) Sometimes users send emails to our individual emails and also to this shared mailbox 3) Sometimes users send emails to this shared mailbox only I want to get a notification / forward the email if the mail is sent to this shared mailbox and not sent /copied to my personal address. I tried the "When mail arrives in shared mailbox trigger" and add the condition TO - does not contain - FROM - does not contain - CC - does not contain - But it threw an error at this condition. Could you please guide me how can i get it done. Thank you!
Hey Binu, thanks for stopping by. I’ve not done what you’ve asked for before but maybe you need to try a filter array to create a trigger condition. ua-cam.com/video/tlS6pSAx-GY/v-deo.html otherwise post your question on the forum powerusers.microsoft.com/
Great Video DamoBird365. Very informative and easy to follow. One thing I noticed .. the time listed when the email was received in your(my) inbox does not match the times listed in the HTML table. Where/What do I need to change so the times in the HTML table are actually the time the email was recieved?
@@DamoBird365 Thats what I was thinking. In the steps to set up the schedule, I followed your steps but used Central Time zone. But the times are times are off by like 6 hrs. Actual emai received: 3:02 pm, reported in HTML Table/Email: 09:01 ... I assume this is 24 hr time. Time Zone: (UTC-06:00) Central Time (US & Canada) Start Time: 2023-11-21T10:01:00Z
Thank you! This is going to save one of our managers a lot of manual work!
Great video as always Damien. Just to share that I do format the HTML table for MS Teams, I use the replace function to modify the string to add a border and a second replace to add the style attribute. In this example, I have created a HTML table, then used a compose to get rid of some unwanted characters from SharePoint and then this compose to provide a table using the output of the last compose - replace(replace(outputs('Compose'),'','
I like it - keep sharing those ideas 👍
Very informative video Damien. Keep it up.
Great video, do you have videos when an email in a shared mailbox is being worked on by a colleague it creates a card in planner? This would be really helpful.
I don’t but will have a think about it.
Howdy! I got this working fairly well except I can't get the hoverable table to work. I followed the instructions and verified I've copied the code for the hoverable table. It comes out formatted, but the hover doesn't work. Also, any thoughts to how to sort the date in ascending order from oldest to newest? Thanks!
Not sure about the formatting. Is it the client or code? Test the code in an editor wysiwyg? There is a sort and reverse expression.
Thank you for the guide on this! I have been looking for a way to do this for a few weeks with no luck. I am new to automation so this seems great to use. Unfortunately, each of my iterations always returns a "0" emails found in the response email. I have made sure to try this on a shared inbox and and my own work inbox but with no luck. I made certain I have at least 2-3 unread emails for the automation to find.
Do you have any ideas on troubleshooting that I could follow?
First stop is the history of the get emails action. Is there something in the output? If not, check your settings for this action. Are you looking in the right mailbox, is it specifically unread emails? Let me know how you get on.
@DamoBird365 I am not seeing anything in the output, unfortunately. The value just contains an open and closed bracket.
I'll run through my actions in some more detail. I haven't found a way to include images so this is my next best idea.
*Only items with content are listed, all others are blank.
Get Emails (V3)
- Folder = Inbox
- Fetch Only Unread Messages = Yes
- Original Mailbox Address = Email is correct, and has been checked multiple times for certainty.
- Include Attachments = No
- Search Query = Received
- Top = 25
- Importance = Any
-Only with Attachments = No
Create HTML table
- From = Microsoft Outlook Value or **outputs('Get_emails_(V3)')?['body/value']**
- Columns = Custom
- Table created as shown
Send an email (V2)
- To = My email
- Subject = Daily Email Alert - **length(outputs('Get_emails_(V3)')?['body/value'])**
Let me know if you see something here that I can correct and thank you so much for your time in looking this over.@@DamoBird365
I located the issue. I wasn't using the "Search Query" correctly. Searching for "received" in this way would always return a "0".
@@jameswood487 thanks for updating me, glad you got it sorted
Could this be done to count the amount of emails in a specified category? For example: in a shared inbox there may be 1000 emails with 50 in category red for priority, 500 yellow for pending, etc etc.
Ooooh that sounds cool 😎 I believe get emails v3 is limited to 25 at a time but graph api might support this learn.microsoft.com/en-us/graph/api/user-list-messages?view=graph-rest-1.0&tabs=http and then you can use this video to sum/group etc ua-cam.com/video/z5MxbwURV68/v-deo.html
@@DamoBird365 you're the man!
is there a way to do this flow with a shared inbox but for it to send an email with a count of total emails received or moved into a specific folder in the last 7 days?
This does provide a total number of emails using length. You would want to get the emails from your chosen location and do similar.
great video, thank you Dan. Is there a way that you can scan a mailbox with all questions and search for all the answers through Sharepoint?
I wouldn’t think it would be the easiest thing to achieve but Copilot for Microsoft 365 can do this sort of thing.
Should the shared mailbox be on Office 365 exchange server? Or can do this on older versions of exchange server
It would need to be office 365.
This is really handy. I have set this up to monitor all of my shared mailboxes and my mailboxes at client Tenants. For every mailbox I created an Get Emails and Create HTML table action so mails from each mailbox gets presented in their own table.
But with over 10 mailboxes to monitor this gets a bit messy. Is there a way to do a sort of for-each loop through all of the mailboxes and still present a resulttable for each mailbox?
Is it messy because you repeat the logic 10 times? If you created a data source of mailboxes to monitor, you could apply to each with the same logic and output the html tables as an array and then join() on br tags?
thanks, I'm going to try this out but I need to monitor for emails based on subject, say something like a daily check for emails with subjects that start with "Daily report" but with a wildcard after that. think that's possible?
There is indeed a startswith expression learn.microsoft.com/en-us/azure/logic-apps/workflow-definition-language-functions-reference#startswith
Hi Damien
Great video
I do have a question though. I am trying to monitor a shared mailbox and emails need to be responded to asap.
I have been using "When a new email arrives in a shared mailbox" However it gives me a 5 min recurrence limit, I cannot find a way around it as of yet
Any advice?
try creating the flow via the new designer, there is a new setting for the polling period - I haven't explored the limits. Please report back 👍
Brilliant and something I am going to work on, I assume it would work for an actual plain mailbox
Oh, absolutely 👍
Hi Damian - I always find your explanations really great and have already adopted a lot of them. Your example shows how to use one shared mailbox. Is it also possible for me to monitor several shared mailboxes and combine the mails from the respective mailboxes into one message? So not one message per mailbox but one for all mails from all mailboxes?
I believe you could. If the trigger is based on a schedule, you could check several mailboxes and then amalgamate the results into one html table.
Hi, Thank you for this wonderful video.
I need some modification as my requirement is a bit different. I tried different places, but it didn't work.
I have a shared mailbox which is shared by 4 people. I have the following scenarios:
1) Whenever I sent an email related to the topic, I copy to this shared email address so that others can see it.
2) Sometimes users send emails to our individual emails and also to this shared mailbox
3) Sometimes users send emails to this shared mailbox only
I want to get a notification / forward the email if the mail is sent to this shared mailbox and not sent /copied to my personal address.
I tried the "When mail arrives in shared mailbox trigger" and add the condition
TO - does not contain -
FROM - does not contain -
CC - does not contain -
But it threw an error at this condition. Could you please guide me how can i get it done.
Thank you!
Hey Binu, thanks for stopping by. I’ve not done what you’ve asked for before but maybe you need to try a filter array to create a trigger condition.
ua-cam.com/video/tlS6pSAx-GY/v-deo.html otherwise post your question on the forum powerusers.microsoft.com/
@@DamoBird365 thank you for the quick response. i will try.
Please create a video on Adaptive Cards.
That would be good.
Great Video DamoBird365. Very informative and easy to follow.
One thing I noticed .. the time listed when the email was received in your(my) inbox does not match the times listed in the HTML table. Where/What do I need to change so the times in the HTML table are actually the time the email was recieved?
Is that a timezone thing? learn.microsoft.com/en-us/troubleshoot/power-platform/power-automate/converting-time-zone-power-automate
@@DamoBird365 Thats what I was thinking. In the steps to set up the schedule, I followed your steps but used Central Time zone. But the times are times are off by like 6 hrs. Actual emai received: 3:02 pm, reported in HTML Table/Email: 09:01 ... I assume this is 24 hr time.
Time Zone: (UTC-06:00) Central Time (US & Canada)
Start Time: 2023-11-21T10:01:00Z
@@DamoBird365 Also noticed in your video, your actual email and report times were off by 1 hr.