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!
Fire trigger on creation of new item regardless of user role
Hi everyone, I just created a flow in Power Automate which performs some operations on list items. I have chosen the trigger "When an item is created" which also works fine. However, it only fires when I as owner of the flow create a new item. I also added the Sharepoint as owner but if a normal user with member role creates an item the flow doesn't run. How can I ensure that the trigger does always fire and the flow runs for any user on the Sharepoint list, regardless of their role? Thanks for any hint!Sharepoint list creation from Excel breaks my dates
I am trying to create a list on Sharepoint to be used in Power Automate. My Excel list has the dates column formatted as date only and as yyyy/mm/dd: When I create a new Sharepoint list from Excel, the import screen shows the dates correctly: But when the list is created, it minuses one day from the day of each date: So when I go to column settings and change to date only, I am still missing a day on each date. Why is this happening? Even if I format my Excel dates as M/d/yyyy h:mm AM/PM which is how it appears in the sharepoint list, it still breaks and removes a day. A workaround is to create a calculated column with this formula: =DATE(YEAR(Date),MONTH(Date),DAY(Date)+1) but why should I have to do this?
Flow to send email to different individuals based off SharePoint List
Hi All! I will attempt to state the following as clearly as possible 🙂 I have a flow set up to send me a notification. It's triggered when the SharePoint List column 'Development Date' (date format) hits 90 days past the specified date. At times this can be multiple line items that have the same Development Date. This works well with no problems. My next goal I am hoping can be accomplished is to have the flow send an email to the individual who is tied to that respective line item/row. It is a column in the List, 'Point of Contact'. I don't see an issue with this if there was ONLY one line item that hits the +90 day 'Development Date', but this sounds tricky when there are multiple line items. My hope is to have the automation look at the first column, 'Opportunity', and send an email to the Point of Contact that is tied to that Opportunity without including the other line items that DO NOT pertain to that specific individual. The email context will be the same other than those dynamic field. I was thinking that I couldn't leverage the Switch Control condition because the 'Opportunity' does not equal the same every time. Opportunity names change and Point of Contacts change per opportunity. Please let me know if I can further clarify any of the above! Thanks in advance and much appreciated!
Disable Forms answers depending on List entries via Flow/Power Automate
Hi @all, I'm trying to create something like a sign in to scheduled dates. Each date has slots for 6 participants. Now I want to send a Forms form to all off them, so they can choose which date they want. The results of the Forms survey are stored in a SharePoint List. BUT if all 6 slots on a date are full the option in Forms for this date should be disabled. Is something like this possible or better made with another solution? 🙂 Greetings(Flagged e-mail => SPO list) results in duplicates
I have a flow that works mostly correctly. When an e-mail in a user's inbox is flagged, an item is created in a SPO list. (The list is a Task web part, but this problem occurs with a custom built list, also.) The problem piece is that the list items become duplicated. In addition to causing confusion, this distorts the item numbers and ID numbers. The desired behavior is to create an item only once per flagged e-mail, but not necessarily once per e-mail thread. (In other words, one thread might have two flagged messages.) I cannot determine if the duplication occurs each time Outlook is opened, each time the flagged e-mail is viewed, or whether it's something under the hood that's causing it. (1) Is this something that has an obvious fix? (2) If not, how can I cause the flow to check to see if the item has already been created?Flow to auto populate today's date when status set to completed
Hi all, I imagined this would be a fairly easy flow to write however as I'm still new to writing Flows, I'm struggling more then I thought I would with it. I have a SharePoint list which is for recording issues that we've found within a department and I'd like to be able to provide metrics that'll show the average time it takes to resolve them. To try and do this I've added a 'Date Completed' field within the list, but would like it to be automatically populated when someone changes the 'Status' field for that record to 'Completed'. At the moment we can obviously manually enter the date however it'll be a nicer solution to have the date auto-populate. Looking over the web at this, I can only find ways of doing this through SharePoint designer however I'd like to do it through a flow as I don't have designer. I had a little success, however it had an impact on a separate flow that is being used on the same list which just fills in today's date on every record so that it can be used to calculate how long that record has been open for. The only other option I've come across is to use a calculated field, but some have recommended against this as any adjustments to a record will cause the completed date field to updated and affect the results. If any additional information would help please let me know, but equally any help on this matter will be greatly appreciated. Many thanks in advance, RichardSubmitForm not working with auto-generated DataCard
Good afternoon everyone! I'm running into an issue where I'm trying to call `SubmitForm(Form1)` with Form1 being a SharePoint list, and I'm getting an error message saying I need to add the Title field. This is what the form looks like before submitting. The "TaskName" DataCardValue generates a task name with `User().FullName & "-" & Now()` but it will not update when clicking the SubmitForm button and gives me the following error. I cannot make the "Task Name" an optional item (Sharepoint makes it required) so I was wondering if anyone had come up with a solution for this? The Task Name is irrelevant to us so I was hoping to just submit an auto-generated name.
