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.
Sharepoint - Flow to reset certain items to default?
Hello, Our team uses a list to track when we receive certain files. We have a choice column titled Status with 'No Status', 'Received', and 'Complete' options and a Due Date column where we enter the date when that item is due, once received. Instead of manually going into the list and resetting the values, is there a formula/flow I can use to reset items marked 'Complete' to 'No Status' as well as resetting the due date for that row to an empty cell? I don't want to clear/reset the entire columns since certain rows have different due dates and statuses. If one row is marked 'Complete' and the 'Due Date' is today (relative), I would like for those rows to reset back to 'No Status' and due date cell as empty. I appreciate your help in advance!Need to send a Quarterly request and a weekly reminder until all request are complete.
Need to send a Quarterly request and a weekly reminder until all requests are complete. I can make the power automate to send out the email Quarterly Request ever 3 months. And I have figured out how to make the reminder sent out ever 7-days but I need the remind to start 5 days after the Quarterly request goes out and stop when all are complete and start again 5 days after the next quarterly request goes out. Any ideas?
É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 helpSend email two months in advance for people who signed up for something on Sharepoint list
Hey there, I've created a Sharepoint list for conferences in my company's field where individuals can go into the list and "sign themselves up" for a conference in a particular column of that conference's row in the list. I'd like to automatically send them an email in advance of the conference to remind them they signed up - is this possible? The date of the conference is also in the conference's row of the list. I believe Power Automate probably has some way to do this but can't figure it out quite yet. TLDR: Trying to send an email to people who signed up for a conference ahead of the conference's start date - the data for those who signed up and the start date of the conference are in the same row in a list.
