Skip to main content

New answers tagged

0 votes

SharePoint / Teams Date Column Restriction using Validation Syntax Question

For the first date column, you can use column validation like: =[Date Column]<=Today() For the second date column, you can use column validation like: =[Date Column]>=Today() Example: Note: ...
Ganesh Sanap - MVP's user avatar
1 vote

SharePoint List formatting a Date column

See if the following works for you { "$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json", "elmType": "div", &...
Matiur Rahman's user avatar
0 votes

Get top 2 Upcoming Recurring Events- SP Classic exp Events

It is also very complicated to get top 2 upcoming recurring events by power automate. As a workaround, you could consider to use Outlook group calendar and group calendar web part to show upcoming ...
Emily Du - MSFT's user avatar
0 votes

Hyperlink column with icon instead of text in a classic SharePoint list

You will not be able to add image in "Description" of SharePoint list hyperlink column using "Send HTTP Request to SharePoint" action in Power Automate. However, you can add emoji ...
Ganesh Sanap - MVP's user avatar
0 votes

Hyperlink column with icon instead of text in a classic SharePoint list

IIRC, the classic SharePoint list column is called "hyperlink or picture". You can use the URL to point to an online picture or use it as a text hyperlink. The description for a hyperlink ...
teylyn's user avatar
  • 9,044
1 vote

Calculated Column IF statement limit?

This is a known limitation with SharePoint calculated column formulas. You can use maximum 19 nested IF functions in calculated column formula. If you have more than 19 nested IF functions/conditions, ...
Ganesh Sanap - MVP's user avatar
0 votes

Hyperlink column not working as button

I also just discovered a Column Formatting that worked in the past and just stopped working recently. I think something has been changed by Microsoft or whoever (I am not an expert) I can also only ...
Maxi Rasmer's user avatar
0 votes

How to calculate difference in the same column

If I understood your question correctly, I think you are trying to create a calculated column based on same column (counters) values from 2 different list items/rows for same "Athletes name"....
Ganesh Sanap - MVP's user avatar
0 votes

Aggregating/displaying rows from multiple lists into master list

I don't quite know from your question why you need a master list, as you didn't give a reason, but perhaps the same thing can be achieved by creating a page with 6x web parts. Perhaps you just want ...
Tally's user avatar
  • 2,253
0 votes

Trigger conditions to start approval process or notify on rejction

Here is an example of trigger condition which might help construct yours. Please describe your list structure and approval process requirements for further assistance. @or( or( or( ...
Matiur Rahman's user avatar
0 votes

How can I limit a "View Comments" link on a list item only when comments exist?

The comment links here on SharePoint do not support display by condition at this time. There is no out-of-the-box solution for this issue at this time. Perhaps you can provide feedback about your ...
Karley Zhou-MSFT's user avatar
1 vote
Accepted

What is the JSON code for just showing profile picture (not the name) in a SharePoint list view?

You can show only user image and hide user name using SharePoint JSON column formatting. However, when you apply JSON column formatting to any column, it will change the display of column from All ...
Ganesh Sanap - MVP's user avatar
0 votes

What is the JSON code for just showing profile picture (not the name) in a SharePoint list view?

There is sample code for a round person image in Github. https://github.com/pnp/List-Formatting/tree/master/column-samples/person-roundimage-format You can change the JSON settings to another shape if ...
teylyn's user avatar
  • 9,044
0 votes

Filter list view date field by all entries that are NOT BLANK

If you want to hide (Empty) option from date column filtering pane, you have to apply the filter on your SharePoint list view. You can apply filter from list view settings like (from classic list view ...
Ganesh Sanap - MVP's user avatar
1 vote

I cannot hide the "New" button in SharePoint list using JSON

I just tried using below JSON in SharePoint list view formatting and it works fine for me: { "$schema": "https://developer.microsoft.com/json-schemas/sp/v2/row-formatting.schema.json&...
Ganesh Sanap - MVP's user avatar
0 votes
Accepted

Only get part of the SharePoint list with JavaScript Fetch

This is the default behavior of SharePoint REST APIs: If you do not mention $top in REST API endpoint, it returns 100 items by default. So, you have to use $top to retrieve more than 100 items in ...
Ganesh Sanap - MVP's user avatar
1 vote

Calculated column based on another column

Multiple selection choice columns in SharePoint list are not supported in calculated column formulas. If you use single selection choice column or text column, you can use calculated column formula ...
Ganesh Sanap - MVP's user avatar
0 votes

Formula to compare two date fields in SharePoint Lists

Your formula looks good to me. But, make sure to use this formula in List validation settings instead of Column validation settings. If you want validation like Date ISL Reported should be less than ...
Ganesh Sanap - MVP's user avatar
0 votes

List Column Validation dependant on another column

Yes it is possible using SharePoint list validation formula. You have to use the List validation settings instead of Column validation settings. Use formula like this: =IF([Leave Type]="Annual ...
Ganesh Sanap - MVP's user avatar
0 votes

Hyperlink column not working as button

I just tried using below SharePoint JSON column formatting and it works fine for me: { "$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json&...
Ganesh Sanap - MVP's user avatar

Top 50 recent answers are included