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 help
SharePoint 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, Irene
Custom 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)" } ] }MS List Column Width Forced
Hi, I've had a number of MS lists and been able to enter grid view and amend the width of columns and the text doesn't overflow which I want to keep the overall list width smaller; but as of yesterday all my columns are forced to be as wide as the text, meaning the that 1 column can be multiple screens wide for multi-line columns and they can't be resized smaller Is this a bug? Any help appreciated.
Create reference number in SharePoint lists with each new entry
Migrating an Excel table into SP lists, so I can existing reference numbering system, so with each new entry I need this to increase by one. Let's say the current ref number is R5687 how to I ensure that subsequent entries are allocated a reference number, which is one more last the last
MS List - View a list of columns, including internal column name and column alias
I'm trying to make sense of column names in MS Lists. It seems like columns can have both an internal/system name and an alias. For example, my Title column (internal/system name) is displayed as a custom "Asset ID" column in the Microsoft Lists app. Is there a way to view a list of all column names, and the list would show both the internal/system column name and the column alias? Like this:Import picklist values for SharePoint List choice field
I have a column in a SharePoint List that uses the choice field type. I'm able to manually enter each choice value by copying/pasting text from an Excel spreadsheet. Is there a way to import a long list of values directly into SharePoint to save time?
