New answers tagged list
1
Yes, you can do that using JSON view formatting.
Follow below steps:
Go to your SharePoint list
Click on switch view options dropdown at the top & select Format current view.
Make sure Format view & Gallery is selected like below:
Click on Edit card & then select Advanced mode
In the JSON text box below, change the width property as per your ...
0
This is a known limitation of JSON formatting in SharePoint.
You cannot format the column headers using JSON formatting in SharePoint online.
2
If your "Name" column is of type "Single line of text", use below for display attribute:
"display": "=if([$Name] != '', 'block', 'none')"
If your "Name" column is of type "Person or Group", use below for display attribute:
"display": "=if([$Name.title] != '', 'block', 'none')"
...
0
Try this solution:
Set the following formula to OnSelect property of button:
Set(defaultComboValue, LookUp(Choices('SP List'.ChoiceColumnName), Value="option1"))
Set the following formula to DefaultSelectedItems of combo box:
If(IsBlankOrError(defaultComboValue), Parent.Default, defaultComboValue)
References:
Change the value of a dropdown by ...
0
If you are going to use classic experience in SharePoint Online, you can still use JQUERY & custom scripts in team sites.
If you are going to use the modern experience:
For list form customizations: You can use Power Apps customized forms, conditional formula to show/hide fields, JSON to format the list forms
For list view customizations: You can use ...
1
Use below code in script editor or content editor web part:
<script type="text/javascript">
function hideAllListsColumnHeaders(){
var allListTables = document.querySelectorAll("table.ms-listviewtable");
for(var i = 0; i < allListTables.length; i++) {
var tbodyElement = allListTables[i].firstChild;...
0
Base on my test, it is not possible to automatically add value to the choice options for multiple choice column, but for single choice column is ok, it is by design.
0
As I am not sure about the type of "CQUniqueID", just assume it to be a number from its name.
The most straightforward way will be like adding a new flow. Triggered when item is created/modified in the list. As you mention there is some kind of relationship between the item and file in library. If you can get the file ID from the list item, just ...
0
Unfortunately, this is not possible using SharePoint out of the box capabilities.
Fill-in values will not be added to choice column options automatically.
0
Just faced this issue today while working with SharePoint Rating columns in PowerApps. It looks like we can only read the rating value but cannot update it.
I found one workaround for this issue, but we need to first change the rating column type from "ratings" to "likes". Here are the remaining steps:
In PowerApps when you connect the ...
0
Go to Settings → Style → View style and edited to "No labels"
1
Try using below settings in list view:
If this is not working for you then add below code to your SharePoint page using Script Editor or Content Editor web part:
function hideColumnHeaders(){
// hide list column headers
document.querySelector("table[summary^='TESTLIJSTPK'] tbody tr").style.display = "none";
}
...
0
For your requirements, you can simply create a custom list in SharePoint.
Add all necessary questions (columns) in list & then customize default list forms to auto populate the current user details.
Check below reference for auto populating user name in list forms:
Auto Populate Current User Login Name in SharePoint
To add attachments to list items, make ...
0
NO. AFAIK, there is no OOB way can achieve this requirement.
0
For list:
Break permissions inheritance from SharePoint site & then assign required permissions as per your requirements.
Check Break permission inheritance in SharePoint section at: Customize permissions for a SharePoint list or library
For web part page:
Break permissions inheritance on particular page & then assign required permissions as per your ...
2
No.
Using out of the box functionalities of SharePoint, it is not possible to open the modern list forms in dialog like classic experience.
0
I think you have at least two ways to do what you want:
As suggested, create a Calculated column. You can use an existing column of the list and create a formula to display what you want: https://docs.microsoft.com/en-us/previous-versions/office/developer/sharepoint-2010/bb862071(v=office.14)
Another solution consists to format your view. This solution has ...
0
If you are using SharePoint online modern experience, you can achieve this using conditional formulas.
You can use formula like:
=if([$Category] == 'Meeting Request', 'true', 'false')
Steps to add conditional formulas:
Go to the list where you want to show or hide columns in the form.
Open an item to view the item details in the display form OR open the ...
0
As per my test, I am not able to find the comma (,) in number column using SharePoint formulas. So, it is difficult to add such validations.
Workaround:
Use single line of text field instead of number column & use below column validation:
=ISNumber([MyColumnName] + 0)
0
There is no such thing like "margins" in SharePoint list forms.
It's all HTML & you have to hide the unnecessary HTML elements at the top by identifying their "selectors" & applying custom CSS.
like:
div#divId {
display: none
}
Or if there is "margin" or "padding" applied to HTML elements, remove it.
like:
...
0
Power Automate: How can I copy a SharePoint list item with a multiple choice column to another list?
please follow the answer in this thread. I tested it again and works fine.
There is an mistake in the append to array variable 2 action.
You do not need to add a quotation mark around the value.
0
Not the best answer, but I would start with this:
function createListItem( ) {
//Post score to SharePoint list
var siteUrl = 'https://www.mySite.com';
var scoreValue = $('[name="scoreField"]').val();
var clientContext = new SP.ClientContext(siteUrl);
var oList = clientContext.get_web().get_lists().getByTitle('Crossword Scores');...
0
Since yesterday this problem has been resolved for us by using the new drop-down in Sharepoint list, select Export > CSV. The issue was with the workbook export option (that used to be the default on the Export button) that downloads the .iqy, however .iqy has access granted via the cloud account, while some of our employees have a different account for ...
0
As we can easily drag the length of the column, automatic line wrapping is canceled by default in SharePoint Online. Agree with Denis, you can use classic experience instead. Also, you can use multiple lines of text column instead of single line of text column and link column(use hyperlink).
You can give your feedback to Microsoft if you don't want to ...
1
Calculated columns cannot be shown on list forms using out of the box capabilities.
You need to customize the list form using Power Apps, reproduce the calculated column value logic using Power apps formulas & show the calculated value on list form using label control.
0
Please run the below PowerShell script as an administratorin the SharePoint Online Management Shell
Add-Type –Path "C:\Program Files\SharePoint Online Management Shell\Microsoft.Online.SharePoint.PowerShell\Microsoft.SharePoint.Client.dll"
Add-Type –Path "C:\Program Files\SharePoint Online Management Shell\Microsoft.Online.SharePoint....
1
No.
Deleted columns or the data of that particular do not go to the Recycle bins.
So, if you don't have its backup, then data is lost.
Note: You can create a support ticket with Microsoft and see if they can provide any help regarding data recovery: Contact support for business products - Admin Help.
Similar questions:
Recover deleted column from SharePoint ...
0
If you are using any one of the triggers of SharePoint Connector triggers, you can easily access list item ID using below expression:
@{triggerOutputs()?['body/ID']}
Also, you can select the ID property from dynamic content (as you are already doing it). Both above cases working perfectly fine for me while storing item ID in string variable.
Flow:
Output:
...
0
Use this formula:
=IF([Impact]="High", IF([Urgency]="High", "1", IF([Urgency]="Medium", "2", IF([Urgency]="Low", "3", ""))), IF([Impact]="Medium", IF([Urgency]="High", "2", IF([Urgency]="Medium", "3", IF([Urgency]="Low", ...
2
Use either of below JSON codes on your date column as per your requirements:
Based on Month only:
{
"$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json",
"elmType": "div",
"txtContent": "@currentField",
"style": {
"background-color&...
2
Try this:
{
"$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json",
"elmType": "div",
"txtContent": "@currentField",
"style": {
"background-color": "=if(getMonth([$DateField])==getMonth(@now), 'Orange', '')",
"...
0
As you have observed, there is indeed a difference between the Form format in Power Apps preview mode and the actual Sharepoint Form format. At present, there is no way to make the Form format of Power Apps and Sharepoint completely consistent.
Cancel Highlight style
Please modify the value of HoverFill
HoverFill : RGBA(255, 255, 255, 1)
2
SharePoint workflow can be categorized to site workflow, list workflow and reusable workflow. List Workflow is workflow which is Associated with one particular List. It waits for events happened on that specific list and start actions pre-configured.
A simple introduction blog:http://devendra-sharepoint.blogspot.com/2012/02/list-workflow-vs-reusable-wokflow-...
0
You can force the list to display in the classic view by going to the List settings > Advanced Settings > List experience and selecting Classic experience:
In the modern lists, you can adjust the width of the column and then save the view. The column width will be then stored in the view and other users will be able to see this change.
In terms of ...
0
Using the ID column in calculated columns is not supported, this is why it doesn't appear in the "Insert Column" list next to the formula box. Alternatively, you could use a Power Automate flow that runs on the creation of a new item to update a column using the ID column.
0
If
[Annual pack days diff] is of "Date" type
[Public Liability expired?] & [Employers Liability expired?] are of "Yes/No" type
then use this formula:
=IF(AND([Annual pack days diff] > Today(), NOT([Public Liability expired?]), NOT([Employers Liability expired?]), "Yes", "No"))
If
[Annual pack days diff] is ...
1
As per my understanding from your question, you are trying to read the information from multiple items/rows & show it on the hovercard (Correct me if I am wrong).
If this is the case then it is not possible using JSON Formatting.
In JSON column formatting, you can only read the columns from same item/row.
For more information, check my answer at: How can ...
2
In order to display a custom hover card, you need to use customCardProps element. See more details here. It has the following properties:
openOnEvent
hover - card appears on mouse hover;
click - card appears on click on the field.
directionalHint
topCenter bottomCenter leftCenter rightCenter
isBeakVisible - boolean. if true the card has a beak.
Sample ...
0
You can try this formula:
=IF(ISBLANK(Route),TRUE,AND(LEN(Route)=7,NOT(MID(Route,5,1)="-"),NOT(MID(Route,6,1)="-"),NOT(MID(Route,7,1)="-"),MID(Route,4,1)="-",CODE(UPPER(MID(Route,1,1)))=CODE(MID(Route,1,1)),CODE(UPPER(MID(Route,2,1)))=CODE(MID(Route,2,1)),CODE(UPPER(MID(Route,3,1)))=CODE(MID(Route,3,1)),CODE(UPPER(MID(...
1
Looks like there is one additional ) in your 2nd formula. It should be like:
=AND(LEN(Route)=7,MID(Route,4,1)="-",CODE(UPPER(MID(Route,1,1)))=CODE(MID(Route,1,1)),CODE(UPPER(MID(Route,2,1)))=CODE(MID(Route,2,1)),CODE(UPPER(MID(Route,3,1)))=CODE(MID(Route,3,1)),CODE(UPPER(MID(Route,4,1)))=CODE(MID(Route,4,1)),CODE(UPPER(MID(Route,5,1)))=CODE(MID(...
1
You cannot apply multiple JSON formatting codes to single column. So, you have to manage multiple conditions/rules within same JSON.
For changing color to red when number is negative, add below code in your existing JSON:
...
"style": {
"color": "=if(@currentField < 0, 'red', '#323130')"
}
...
Documentation: Use ...
2
Here is a workaround which may be easier to carry out.
Select all items with the toggle selection.
Click edit button, then you will be edit the column value in bulk.
Note: This operation also has the list view threshold. So it may not work when you have over 5k items.
4
There is no direct way to remove all values vertically in particular column in Grid view.
As a workaround, follow steps given below:
Click on column cell in first row.
Remove its value (Click Delete on keyboard directly or click again in cell & use "Backspace" to delete value).
Select the small dot at the bottom right of column cell.
Drag ...
1
Please the following steps:
1.Create two lists named "Customer" and "Invoices"
2.Go to the Invoices list and swith to the classic mode
3.Click on "LIST" tab and select "Default New Form"
4.Click "Settings" icon in the upper right corner and select "Edit page"
5.Click "Add a Web Part" ...
0
If you are using SharePoint online list classic New/ Edit Form use below JavaScript code
<script language="javascript" type="text/javascript" src="https://ajax.googleapis.com/ajax/libs/jquery/3.5.1/jquery.min.js">
</script>
<script type="text/javascript">
$(document).ready(function() {
...
0
What you are looking for seems to be a cascading dropdown list. You can refer to the below blogs for more help.
For SharePoint On-Prem or SharePoint Online classic experience:https://www.c-sharpcorner.com/article/cascading-of-lookup-dropdown-fields-on-sharepoint-2013-and-o/
Multilevel Cascading Dropdowns for SharePoint 2013, 2016, and O365 Classic forms
For ...
1
Microsoft Lists are stored in your personal site. These are good old SharePoint lists, in a good old SharePoint site.
You can verify it by navigating your the MS List service and then replacing /Lists.aspx with /ViewLsts.aspx in the URL:
0
The way to group lists/libraries is using sites. If the seven lists are associated with each other, and not the other 43, then they should be in their own site. Sites also allow you to easily configure permissions, and then be default all lists/libraries in the site will have the same permissions.
If this really can't be done, then perhaps create a page that ...
2
Try below steps using Power Automate ,
Create a automated flow When item is created and modified
Add condition action and check status value is equal to publish
if Yes then add new action Create item
Connect to another list and add dynamic content
1
Try this using Value() function:
Sort(Filter(Master,StartsWith("ID",Value(Search.Text)),Created.Email=User().Email),ID,Descending)
In this case, user has to enter the valid number in search textbox.
Reference: Value function in Power Apps
Update from comments:
If above is not working for you then use below:
Sort(Filter(Master,StartsWith(Text(...
Top 50 recent answers are included
