sharepoint list gallery view, center text vertically
I have a single column selected in card design and made some changes to the advanced formatting, but I cannot get the text to center vertically in each. Any suggestions on how to fix this would be greatly appreciated. { "$schema": "https://developer.microsoft.com/json-schemas/sp/v2/tile-formatting.schema.json", "height": 70, "width": 190, "hideSelection": false, "fillHorizontally": false, "formatter": { "elmType": "div", "attributes": { "class": "sp-card-container" }, "children": [ { "elmType": "div", "attributes": { "class": "sp-card-defaultClickButton" }, "customRowAction": { "action": "none" } }, { "elmType": "div", "attributes": { "class": "ms-bgColor-sharedCyanBlue10 sp-css-borderColor-neutralLight sp-card-borderHighlight sp-card-subContainer" }, "children": [ { "elmType": "div", "attributes": { "class": "sp-card-lastTextColumnContainer" }, "children": [ { "elmType": "p", "style": { "padding": "4px", "white-space": "wrap", "word-break": "keep-all", "text-align": "center", "font-weight": "700", "font-size": "18px" }, "attributes": { "title": "[$Title]", "class": "ms-fontColor-white sp-card-content sp-card-highlightedContent", "role": "heading", "aria-level": "3" }, "txtContent": "=if ([$Title] == '', '–', [$Title])" } ] } ] } ] } }
Find and replace part of an item in a SharePoint List
Hello, I am very new to SharePoint and have inherited a long SharePoint List which needs multiple items updated. What I need to do is find all the items in a Column containing the term "ER" in part of the entry and replace this part of the entry with the term "EAR". In Excel, this is easily done using the 'Find and Replace' search function. Is there a simple way of finding and replacing part of an item entry quickly in a SharePoint List? Here is an example of items that I currently have and what I want to change them to: Current Items: 14ER-110 16ER-215 18ER-330 After updating, the Items should read: 14EAR-110 16EAR-215 18EAR-330 Thank you 🙂
Set default value by logged user for title colum in a SharePoint list
Hi Everyone, I want the current user is the default value in Title column (or Person or Group column type). How can I achieve this? I have tried to set default value is [Me] but it's not showing the current user name. Thanks a lot! ROSE
SharePoint List search limited to ID265
A SharePoint Online list with 400 records. The search function was working fine until one day it could not give results beyond ID 260. I reindexed the list but that did not resolve the problem. I found a workaround "ListItemID: No" and that also did not give us anything above ID265. Any ideas on how to resolve this?Create a workflow in sharepoint list
I have a list in the sharepoint. I would like to create an workflow to fill in a specific column based on the date of other column. For instance: I place manually a date in "column 1" , and the system should place a date in "column 2" . The date of column 2 is the date from column 1 + 30 days. I created: When an item is created or modified; Condition: "column 1" is not equal to null If yes: addDays(triggerOutputs()?['body/Final do Lote'], 30) Appear an error saying: this workflow may result in an infinitive trigger loop. How can I define it ?
Column filter bug?
Hi all, does anyone know if this is a bug or a pretty bad feature? While trying to filter a text column users start having issues with some sort of autoselecy feature. When they write the first letter SP autoselect the item and this happen all the time the user press a key, so if you want to filter for a specific field you need to delete all the letters that the system add, becouse if you just press the next letter you'll be at the end of the autoselect suggestion (img.3). This is an issue when people need to filter in list with high number of items with for example code the are the same for the first 5-6 characters Thank in advance for any suggestion, the issue started yesterday. Francesco
Sum for a Calculated Column
I am tracking invoices for projects throughout the year. The columns in my SharePoint list include: PROJECT TITLE JAN, FEB, MAR… DEC (monthly invoice amounts, formatted as currency) TOTAL (a calculated column that sums the monthly values) The issue I’m facing is that I can see the Sum for each month at the bottom of the view, but I cannot see the Sum for the TOTAL column. Since it’s a calculated field, SharePoint won’t let me display its sum. If anyone knows how to work around this, I’d be incredibly grateful!
