If column value of one item in list 1 match column value of items in list 2, send email (how to?)
Hi all! I have two sharepoint list: List 1 is "Market Intelligence Library" and List 2 is "MI Interest" (see example screenshot attached). List 1 acts as a library to house news articles that are tagged by "Category", "#hashtag", and "Geography" related to the article. List 2 acts as an email distribution list and individual notification preference for articles that contain certain "Category", "#hashtag", and "Geography" tags. Is there a way to send an email via power automate to those in List 2 only if the value in their "Category", "#hashtag", and/or "Geography" matches an item (news article) tags in list 1? Only one column of the three need to match to be notified (contain matching values in either "category", "#hashtag", or "geography"). My trigger right now is "when an item or file is modified" from List 1. Specifically, when an item in list 1 status is moved to "released", then those in list 2 should be emailed if the value in one of the three columns match.
User to not be notified unless they are assigned an item
Thank you so much for all help and assistance as I am unable to create a part of the solution to my issue. My goal: Ensuring that a user is not notified unless they are assigned an item at least 15 minutes from the last time the flow was executed with them being the assignee Setup: Currently, I have a flow that's triggered when an item is changed in a SharePoint list. It gets the changed item and checks if the "PMAssigned" column has changed. If it has, it stops editing permissions for that item and grants access to the user assigned to the lead. If the time elapsed since the last notification is greater than 15 minutes and the user assigned to the lead has changed, it sends an email to the new user. The condition is slightly incorrect because it checks to see if the user assigned to the lead has changed since last time, but rather it needs to check if that user in the last 15 minutes, has had the flow executed with them being the assignee. Please let me know if you have any questions or concerns.How many items have been assigned to me?
Appreciate all the following help, truly. What I need to do: I have a report (SharePoint list) that managers fill out to assign employees to manage leads. I want to send out a reoccurring email, weekly, to anyone who has been assigned a lead in the last seven days (168 hours) telling them how many leads they've been assigned. How does it work? On my leads report, managers are assigning leads, via a lookup column. That lookup column is looking up a calculated column. The calculated column is on my SharePoint list of employees. The calculated column displays all users who 1. have a particular business line 2. particular word in their title And then, the column displays the users "nickname" because it cannot display a person/group column through a calculated column. To do this: I need to be able to extract the profile ID through the original list so I can enter that ID into Get_User_profile, and then from there be able to send automated emails to the dynamic "Mail" content. Please let me know if you have any questions or concerns.
Échec de l'exécution du flux. / Flow execution failed.
Bonjour, je n'arrive pas a utiliser l'envoie automatique d’e-mail avec power automate sur un compte créer il y a env 72h. (tester sur un compte de plusieurs année, pas de soucis) Hello, I can't use the automatic sending of e-mail on an account created about 72 hours ago. (test on an account of several years, no worries) voici l'erreur : / here is the error: The Mail connector is currently restricted for new tenants. Microsoft is working on enabling this connector. In the meantime, please consider using alternatives like Office 365 Outlook, Gmail, SendGrid connector instead. merci de votre aide Thank you for your help
