Power Automate email notification
Hello, I have an automated email when certain fields meet "Completed" I also have a flow that updates the a date field at midnight to ensure the calculated fields I have are updated, however when this flow runs it also sends out the emails for the completed flow. Can I stop this from happening?
Check on double entries in Sharepoint list
Hello I'm looking for a way to prevent double entries in a Sharepoint list. I have 3 lists: One list with names and addresses of Students. (called students), one with names of courses they can subscribe for (called courses) and another called subscriptions, used when a student subscribes for a course. A student can subscribe for multiple courses. I want to prevent that when subscribing a student for a course, the student allready has a subscription for this course. Sometimes it happens that a student does a subscription and has to wait for the course to start (sometimes more than one year). In that case they sometimes come back a few months after the first subscription and want to subscribe again for the same course. To prevent double entries, I want sharepoint to do a checkup before subscribing the same student for the same course again. If the check is positive, I want the user to be prompted that the student allready has a subscription for this course. When the check is negative, I want the data entered in the subscription form to be saved in the sharepoint list. Because the subscription list uses lookup fields from both the courses and students list, sharepoint doesn't let me combine values from those fields in a calculated column to make sure these values are unique entries. I read that to solve this problem, I need to use Power automate to do the check-up. Is that correct, and is it the simplest solution? How do I get started? Thanks!
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.
Microsoft 365 & Power Platform Conference
365 EduCon Chicago, a Microsoft 365 & Power Platform Conference will have workshops and sessions focused on Power Platform, Power Automate, Power Apps and more, taught by the Top Experts! October 30 - Nov 3, 2023. McCormick Place South. https://365educon.com/Chicago
Run a MANUAL Automation from within a list item
Many times I search for an item in a list and when I am inside the item no menus appear at the top of the screen. How can I run a manual automation for the specific item I'm currently viewing? It would be very handy if the below menu appeared inside the list item. Not only at the default view
Sending individual emails based on a multiple selection person/group column
Hi, I'm trying to isolate the individual email addresses based on a multiple selection person/group column and then send the individual an email rather than all email addresses in the column. Is there a solution for this through Power Automate?
https://collabtools.sharepoint.com/:u:/r/sites/ITSS-SharePointWorkshop/SitePages/Home.aspx?csf=1&web
The action for Microsoft Forms is limited to the Q and A results. It needs to mimic and include the data columns created when "Export to Excel" link is used in the survey or quiz. Especially in the quiz, the additional fields pertaining to submitter info and Total Points is a must. I am completely crippled by the action only containing the test question data elements. Does anyone else agree?
Webhook dynamic content turns to null
I have created a flow in power automate that triggers when data is recieved via a http request (webhook). When I recieve a request the data looks very good, but when I try to use the data it turns this data into null. Example: Json schema input: { "schema": { "type": "object", "properties": { "headers": { "type": "object", "properties": { **header properties** }, "body": { "type": "object", "properties": { "id": { "type": "integer" }, **Rest of the body** This is how the data is received, as a nice dataset: { "headers": { not relevant }, "body": { "id": 5704, etc. When using this id from the body to search for example in an excel sheet. It does this: { "host": { "connectionReferenceName": "shared_excelonlinebusiness", "operationId": "GetItem" }, "parameters": { "source": "not relevant", "drive": "not relevant", "file": "not relevant", "table": "not relevant", "idColumn": "ID", "id": null } } Can someone please help me with this problem, I have tried a lot of things, but can't get it to work. Thanks in advance
