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!Modern experience Filters pane for Multivalued Lookup column misbehaving
We have an Online (M365) SharePoint, Modern experience, hosting a Document Library “DocLib”, with a [Countries] multivalued lookup column targeting column [Country] in a “Countries” List. This List also contains a [Region] column which relates any country to a specific region, and this column is imported in “DocLib” resulting in another column, [Countries:Region]. As [Countries] is multivalued, [Countries:Region] appears to be multivalued as well. But filtering, using the standard Filters pane behaves strangely on [Countries:Region]. We expected to be able to filter on any individual region a document can be relating to (through the countries the document is relating to). However, here is what we get: Instead of individual [Region] values, we get, in the Filters pane, individual “Sets of Regions” resulting from all regions related to all countries in [Countries] but there is more… Selecting individual Regions, work just as expected. In the picture you see Regions “Middle-East” and “Africa” selected and on the left, you can see that any document with at least one country belonging to these regions are displayed On the other hand selecting “Middle-East; Middle-East” in the Filters pane, which results from relating a document to both Oman and Saudi Arabia in my exemple, gives no result at all My expectation would be – Having in the [Countries:Region] Filters pane any individual distinct regions linked to the countries the documents in the view are relating to THIS IS NOT WORKING Also, No "combinations of regions" should appear in the pane, they do not work anyway Selecting the regions in the Filters pane would keep the documents that relates at least one of these selected regions - THIS IS WORKING JUST FINE Except that not all regions are displayed if not appearing individually and alone on any of the document of the view! Is this a bug? Did I miss something?
Lookup for two columns in data verse table
Dears I created a table named "onboarding employee" I made a column name "Sector name " and the type is choices, which are (Production sector, Support sector, ...) I created another table named "All Jobs", this table has two columns "Sector name" and "Job title" and each sector has some job titles like the below photo I created a new field in the "onboarding employee table " named "Job title " My request is when I select a sector from the "sector name field" like the production sector and then when I press on "the Job title field", it shows me only the jobs related to the production sector what can I make this? Thanks in advance
Hiding Lookup Column Values
Hello, I'm using a lookup column that displays dates in MM/dd/yyyy format from another SPO list. In my SPO form this lookup works well as a drop down for date selection. How can I hide values/dates in this lookup column/dropdown that have passed without deleting them? Is there a formula I can use to achieve this?
Field custom formatter not working with Edit In GridView
Even a basic custom field formatter like below, makes the Edit in Gridview search render and empty listbox. I've tried @currentField.lookupValue in place of the [FieldName].lookupValue with the same result. formatter: { "$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json", "elmType": "div", "txtContent": "[$HG_x0020_Test.lookupValue]", "debugMode": true }
SharePoint List lookup Column not Available in Power Automate
I have a SharePoint List Lookup Column, however when I go to make a flow to export/share the data from the SharePoint list, the lookup column values do not appear. Does anyone know a way to use flow to export data from a SharePoint list lookup column to somewhere like excel or another SharePoint? Thanks!
Take associated value on lookup column
Hi everyone, I have 3lists, the first one, incident with title, priority and category and some others. The second one is my tracking list, with a lookup value on the title in incident list and others. The third one, list of my category In my incident list, priority is a choice column and category lookup column on my category list. I want to have the priority and category incident associated to the incident title the user choose in my tracking list and I don't want to let the user choose. Can someone help me ?
Centrally managed (dynamic) list accessible via lookup columns across all sites
I have a 'main' list that needs to be looked up from other SP lists (ex. customer name column). The other SP lists are not within subsites where the 'main' list was created, they are in other separate sites. Site columns don't seem to support this as they are only visible to children subsites. Is there a way to achieve this with metadata, content types or do I need to duplicate the data in all sites and using a flow to keep everything in sync ?
