New answers tagged

1 vote
Accepted

How to do one GetItems call to SharePoint then filter the items inside the workflow

Ideally, no need to use the "Select" action in this case, use flow like: Expression used in compose: body('Filter_array')[0]?['WorkFlowGroup'] Where WorkFlowGroup is an internal name of ...
Ganesh Sanap - MVP's user avatar
2 votes
Accepted

Issue Fetching DisplayName Column Data from SharePoint List via REST API

It seems that "DisplayName" word is not working as the list column internal name with the normal select query of the REST API. You can try FieldValuesAsText method to retrieve all columns ...
Dikesh Gandhi's user avatar
0 votes

How to be write in cells in SharePoint cells?

First of all, make sure you have Edit or higher permissions on the SharePoint list and you have created the required columns in the list - Create a column in a SharePoint list or library. Then you can ...
Ganesh Sanap - MVP's user avatar
0 votes

Sharepoint list "Load more items" issue

The default limit of 100 items per page in SharePoint Online list views. When you try to load more items, the page refreshes and returns to the initial state of "Load more items". Please ...
Amy Jiang_MSFT's user avatar
1 vote
Accepted

PowerApps SP Custom Form - Display fields as currency

Try this: Set OnChange property of text input control to: Set(varFormat, Self.Text); Reset(Self); Set Default property of text input control to (same as given by you): If( !IsBlank(varFormat), ...
Ganesh Sanap - MVP's user avatar
0 votes

Reference value of another row (item) in list Validation Settings conditional formula

Unfortunately, No. You cannot reference values of another row (list item) in list Validation settings conditional formula (or calculated column formula). Source: Introduction to SharePoint formulas ...
Ganesh Sanap - MVP's user avatar
0 votes

Multiple User Messages on list Validation Settings

Unfortunately, No. You cannot add multiple user messages on list validation settings. You will have to combine all the validation messages in the single text box as validation message is a simple text ...
Ganesh Sanap - MVP's user avatar
0 votes
Accepted

JSON to wrap text after ";" from a lookup AND delete blank spaces

Try using SharePoint JSON column formatting like: { "$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json", "elmType": "...
Ganesh Sanap - MVP's user avatar
0 votes

Is it possible to use an if statement on choice type column in MS List conditional formatting?

I updated the JSON: { "$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json", "elmType": "div", "style": {...
Stevan's user avatar
  • 3
0 votes
Accepted

Is it possible to use an if statement on choice type column in MS List conditional formatting?

Try using JSON like below: { "$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json", "elmType": "div", "style&...
Ganesh Sanap - MVP's user avatar
0 votes

JSON: InlineEditField for choice columns

There is an issue where if the field is not visible on your Input form, the inlineEditField will not function properly. Text field value will be erase, multi-choice fields will quickly blink and ...
Simon's user avatar
  • 1
0 votes

multiple conditional formatting

Add a second condition to the background-color and color properties to check if the "Status" column equals "Left the Company". Here is the code snippet: { "$schema": &...
Martin Iszac's user avatar
0 votes

Displaying the details (first name, surname ,email etc.) of the user currently logged into my power app

If you are using a "Form" control in your Power Apps to show the information, you can set the Item of form control with formula like this: LookUp(SharePointListName, EmailColumnFromList = ...
Ganesh Sanap - MVP's user avatar
0 votes

Conditional formatting of Calendar View for an Events List not working

I have this same problem. I created a List in SP and displayed it as a calendar with conditional formatting, no problem. But then I found out you can only connect classic Event Lists to Outlook so I ...
JessicaE's user avatar
1 vote
Accepted

In a graph search query, is it possible to retrieve per each listItem, their parent name?

As per my knowledge, there is no managed property available for SharePoint "list name". However, you can try using path or listid properties in fields array in request body which will give ...
Ganesh Sanap - MVP's user avatar
0 votes

List permissions in SharePoint Online

Unfortunately, you cannot do it using SharePoint out of the box "Advanced settings > Item level permissions". You will have to break permissions inheritance at individual item level and ...
Ganesh Sanap - MVP's user avatar
0 votes
Accepted

List permissions in SharePoint Online

There is no way to get this without setting unique permissions on each item (which will be a nightmare to maintain). Perhaps you could build a flow of some sort. The easiest way in my opinion would be:...
Christoffer's user avatar
  • 9,801
0 votes

How to manage onClick event of a row field in DetailsList(UI Fabric)

you can actually put it directly this way onClick={this._onColumnClickView} the _onColumnClickView function will still know the event. private _onColumnClickView = (event) =>{ console.log("...
Edwin's user avatar
  • 367
1 vote

How to do an AND statement in amongst nested IF statements

You have to properly open/close the parentheses for AND function like AND(condition_1, condition_2, condition_3). Try using below formula for your SharePoint calculated column: =1-IF([Customer details ...
Ganesh Sanap - MVP's user avatar
0 votes

Getting list of all users that are currently co-editing document

I don't think there is any SharePoint API at the moment where we can get a list of accounts currently editing a document. If at any point in time one is made available I would love to know myself. ...
Tiago Duarte's user avatar
  • 5,466
1 vote
Accepted

SharePoint List calculation using current date

Use calculated column formula like this: =IF(ISBLANK([Date Closed]),IF([Due Date]<Today(),"Overdue","Open"),"Closed") Notes: Sometimes comma(,) does not work in ...
Ganesh Sanap - MVP's user avatar
1 vote
Accepted

Is there a way to backup/archive JSON formatting

Unfortunately, there is no SharePoint out of the box feature for backup/versioning of SharePoint JSON formatting. However, if you want to backup the JSON formatting codes locally, you can do it using ...
Ganesh Sanap - MVP's user avatar
0 votes

Power automate "Link to Item" launches form in Classic, rather than Modern view

I actually resolved this issue. Audience Targeting function was selected for classic mode. I unchecked, and now the form launches correctly.
Chris's user avatar
  • 393
0 votes
Accepted

SharePoint List counting number of days depending upon status

You will not be able to achieve this requirements using Today() in SharePoint calculated column formula because calculated column value is calculated/updated when: You create a new list item. You ...
Ganesh Sanap - MVP's user avatar
1 vote
Accepted

SharePoint List Formatting - Choice Field Overflow

Try using this JSON column formatting for your choice column: { "$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json", "elmType&...
Ganesh Sanap - MVP's user avatar
0 votes

How can we save a link over 255 characters in SharePoint hyperlink column

This works but when I view in board view it shows the entire URL and my paragraph typed out above the url link is not showing up
annonymous's user avatar
1 vote
Accepted

Rest API SharePoint 2019 Endpoint for List Settings

Here are some links to SharePoint REST API endpoints/documentations which might help you: Get to know the SharePoint REST service Complete basic operations using SharePoint REST endpoints SharePoint ...
Ganesh Sanap - MVP's user avatar

Top 50 recent answers are included