Workflow for importing Excel to List
I'm a novice developing a workflow for importing an Excel spreadsheet to a SharePoint list. Have I missed anything? Workflow: Thoroughly clean up the data in Excel before importing to a list. Caution: Excel filters (and list filters) are case-insensitive and ignore superfluous spaces, etc. So we can't rely solely on filter functionality to find messy values. Instead, consider using the EXACT function in Excel like this: =OR(EXACT(A2,"PRIMARY"),EXACT(A2,"SECONDARY")). See this Stack Exchange post for more options: https://sharepoint.stackexchange.com/questions/317576/find-list-values-that-arent-in-the-picklist-choices Or, as a last resort, we could consider importing to an Oracle table and use a GROUP BY query (SQL) to find incorrect values, since that's dead easy in databases. I don't use Access for this because it has the same filtering limitations that Excel and lists have. Manually create an empty list. Or import a blank list from Excel and modify it. Caution: When importing from Excel to a list, the list won't honor the Excel column names for the internal list names, even if the Excel names are clean. The list will generate column names like "field_0" through to "field_30" (or whatever applies). Google suggests importing from Access is an alternative -- the column names should be honored. https://i.sstatic.net/3KoAsrMl.png Caution: The time zone for my SharePoint sites and personal MS list environment is wrong. It's set to Pacific Time, when it should be Eastern Time. Keep an eye on any list date values to ensure they are correct and haven't been automatically changed to a different day. Import the Excel rows/data using Power Automate. For what it's worth, any dates that get imported via PA will be correct, despite the time zone, unlike when importing data from Excel using the list UI. Inspect the imported data, correct the list columns/settings, correct the Excel data, and repeat #3. Do this multiple times -- as many times as it takes.OneDrive and SharePoint : New Hero Link has arrived
🚀 One Link. Simpler Sharing - Hero Link Microsoft is rolling out a new sharing experience across SharePoint, OneDrive, and Microsoft 365 called the "Hero Link" - (Not Hero Webpart 😀) Instead of creating multiple links for the same file, every file and folder will have a single primary sharing link that can be updated after it's been shared. ✅ One consistent sharing experience ✅ Update permissions without creating a new URL ✅ Change link access at any time ✅ Reduce sharing link sprawl Additional capabilities include: 🔹 People with edit access can reshare and add additional people. 🔹 Apply folder access changes to this item, allowing folder permissions to flow down to files. 🔹 Existing sharing links will continue to work and appear under Other Links, where you can continue using options such as expiration dates, view-only access, and edit permissions. Admins can also configure default link audiences at the site level to match different sharing requirements. The rollout begins in October 2026. 🎥 I've also recorded a step-by-step walkthrough of the new Hero Link experience so you can see exactly how it works in practice. https://youtu.be/HdXgfVy4fl4
Hyperlinking List gallery view on SP
I have a list that is full of training courses and i want to make it so that when a user select one of them, it will hyperlink to the corresponding hyperlink. I could do an powerapp, but wanted to see if there is a way to do this via list webpart on a SP page. Can't use event webpart since there are no set dates, some are on demand.
SharePoint List Web Part - major caching issues
Hi All, I've spent a lot of time building a List based company calendar in our SharePoint Intranet Portal, and the calendar itself is working great, however I'm having no end of headaches with the List Web Part. (not just for this calendar, but all list web parts for that matter) The calendar has a Start and End field - both are Date and Time fields. A custom view is created for use with the List Web Part to embed an "upcoming week" view, this is based on a filter which checks both Start and End dates to see whether an event exists within or spans the date range from today to 7 days in the future, so it is a rolling 7 day window. This is based on a number of filter criteria which include [Today] and [Today]+6. The view also has a sort criteria to sort based on the Start (Date/Time) field. This all works fine when previewing the view within the list itself - at midnight the results update to include events from the day that is now 7 days in the future which were previously excluded. So the view itself is working fine. However the same view in a List Web part on another page suffers from a ridiculous amount of browser side (?) caching, to the point that it is basically broken and unusable. When I open the page the next day in a browser (even if the browser was closed) one of three things happens, somewhat at random: The events 7 days in the future (which just came into filter scope today) just don't appear until a forced page reload is done. The events 7 days in the future do appear but they are sorted incorrectly, appearing at the TOP when the date sort order should show them at the BOTTOM. Sometimes 2 happens but the event is shown with the Start and End Date/Time fields empty - so not only is it at the wrong end of the list it doesn't even show a date at all until the page is refreshed. Here is a picture showing the sort order being incorrect as in case 2: When these various problems happen a full CTRL-F5 browser refresh always updates the list to be complete, up to date and sorted correctly, however, if after that you click away from the page and follow a link to return to it OR press a regular F5 refresh it goes back to being incorrect! It takes many page reloads or a lot of time to pass (hours) before it finally settles down and gives the correct results every time. Then the next day the same caching problems happen again. If you go to a new browser or PC the same problems happen again, suggesting this is browser side caching not something at the servers. While the actual content of the list items update in real-time if you edit the list content in another page (which is pretty cool) the "result set" of list items (which items should or should not be seen) is heavily cached, and the sorting is unreliable. Has anyone else found a solution to this ? I have already done things like disabling offline mode for the list, (this only seems to affect caching of the actual data in the list items, not caching of filter results) etc and I cannot find a solution. The only thing I know which would probably work, as I have had to use this approach on another list is to extend the date range of the filter criteria for the view further into the future, then filter out the extra days using json code in "format view - however AFAIK you can only selectively hide rows like this if you use a custom rowFormatter, which means you have to fully re-implement the standard view including hard coding all the columns you want and it still won't look quite the same. This is a lot of work and maintenance overhead in the future to work around a caching problem that shouldn't exist in the first place. Any thoughts appreciated as a lot of time and effort has gone into building an entire calendar system around a SharePoint List, only to find that the list web part just doesn't work properly.
JSON formatting to change background color of ENTIRE column of list?
Hi, I'm trying to use JSON formatting to change the color of an entire column of a SharePoint list, and I can't figure it out. Setting the background-color style property appears to only affect the background color of the text. You can still see the default column color in between rows. I want the whole column to be one color. Is there a way to do that?
ID Calculated Column Not Showing
I have created a calculated column to show the ID in an opened List item. This is using =ID in the formula box. However, in the actual List item, the vasty majority are showing ID as 0: There does not seem to be a pattern for this, Does anyone have an explanation for this?Recycle Bin and Site Content Hidden for Site Members and Site Visitors
I posted this before but made a mistake with my write up, so I am reposting. I have a requirement that the Recycle bin and Site Contents should be be hidden from the Site Members and Site Visitors. Please how can I achieve this because the Server Infrastructure activation is not working for me. Any workarounds? Please helpSharePoint List "Lookup" columns not available in Get Items in Flow
I have seen this discussion before (see https://jgvjg48436.lithium.com/t5/General-Power-Automate/Missing-Columns-from-SharePoint-List-in-Flow/td-p/239360) but suggested solutions have not resolved my issue. So, I am looking for some more guidance or suggestions. I have a SharePoint list with a Look-up column. Using Get Items in a cloud flow this field does not display. Setup SharePoint List called "ARB Meetings" SharePoint List called "Decision Register", this has a lookup column to the ARB Meetings list. Get Item Note, I have tried using Limit columns by View and created a new view including the required lookup column, without success. In the Decision Register SharePoint List, there are some items where the ARB Meetings column is blank, I don't know if this could cause an issue? Co-Pilot Help I have asked Co-Pilot for help, which gave me plently of good options I have tried the following without success: If your lookup column is not showing in the Get items action in Power Automate, here are a few steps you can try to resolve the issue: Check List Views: Ensure that the lookup column is included in the default view of your SharePoint list. Sometimes, columns not included in the view might not appear in Power Automatehttps://jgvjg48436.lithium.com/t5/Building-Flows/Get-items-not-showing-lookup-column/td-p/859264. Refresh the Flow: After adding the lookup column to your list, refresh your Power Automate flow. You might need to close and reopen the flow designer to see the updated columnshttps://jgvjg48436.lithium.com/t5/General-Power-Automate/Missing-Columns-from-SharePoint-List-in-Flow/td-p/239360. Limit Columns by View: In the Get items action, use the Limit columns by view option to select a view that includes the lookup column. This can help ensure that the column is retrievedhttps://jgvjg48436.lithium.com/t5/General-Power-Automate/Missing-Columns-from-SharePoint-List-in-Flow/td-p/239360. Check Column Settings: Verify that the lookup column is properly configured in SharePoint. Ensure it is not hidden or restricted in any wayhttps://jgvjg48436.lithium.com/t5/Building-Flows/Get-items-not-showing-lookup-column/td-p/859264. Pagination Settings: If your list has a large number of items, enable pagination in the Get items action settings. This can help retrieve all items, including those with lookup columnshttps://learn.microsoft.com/en-us/sharepoint/dev/business-apps/power-automate/guidance/working-with-get-items-and-get-files. If these steps don't resolve the issue, you might want to try creating a new flow from scratch to see if the lookup column appears. Sometimes, starting fresh can help Power Automate recognize new or updated columns. Let me know if you need further assistance or if there's anything else I can help with! References [1] https://jgvjg48436.lithium.com/t5/Building-Flows/Get-items-not-showing-lookup-column/td-p/859264 [2] https://jgvjg48436.lithium.com/t5/General-Power-Automate/Missing-Columns-from-SharePoint-List-in-Flow/td-p/239360 [3] https://learn.microsoft.com/en-us/sharepoint/dev/business-apps/power-automate/guidance/working-with-get-items-and-get-files Thank-you, IreneCustom Formatter for Read-Only Fields conditional based on other columns
Hello! Does anyone know if it's possible with the fieldsettings, readonly formatting, to make it conditional based on a Person field? It's a multi people field if that makes a difference? I ideally want to make certain fields read only based on who is viewing it (without having to use a Power App customised form!). This is what I want (but I know the syntax is likely all wrong!) but not sure if it's possible to use an IF statement with boolean statements? { "sections": [ {} ], "fieldsettings": [ { "name": "Comments", "readonly": "=if([$People.email] == me, false, true)" } ] }
