New answers tagged

0

The steps and screenshots below show how to update multi-value People Picker (Person Type) column using REST API in Power Automate. Examine user ids in the hidden User Information List by a REST API call. These Ids will be used to update Approver column. The corresponding internal name of the updating property would be ApproverId. Once ids are identified, ...


0

Check to verify your verticals appear in office.com and bing.com (if Bing search is enabled in your tenant). If they do, when you search on an SPO site, if the path shows "Organization > <SiteTitle>", then click on the "Organization" link. You should then see your organization-wide verticals you created in the Microsoft Search ...


1

SharePoint mobile app list features are limited comparing to the options available through browser. There are multiple requests through User Voice forum, links below, and the feature you are after, is in the plans, not sure when it will be available though. https://sharepoint.uservoice.com/forums/350433-sharepoint-mobile-app-for-ios/suggestions/15874830-list-...


1

Here is a sample of JSON formatting for multi-choice column to produce the expected result. { "$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json", "elmType": "div", "style": { "display": "block" }, "children": [ { &...


1

Another method worth looking at. Run Fiddler to find whether the redirection comes from a specific javascript code or anything else. Run gulp serve --nobrowser then take your SharePoint site address (where it shows your web part), add /_layouts/workbench.aspx, and then add your web part. If nothing goes wrong (not redirecting) then likely other web parts ...


0

Based on your requirement, I understand that you want to add a required column to only one document set in the document library. The other document sets in the document library should be without the required column. You should create a new content type based on the document set content type, then add the new content type to the document library. After that, ...


1

You cannot manually set the "Highlight line" for SharePoint list cell. However, you could using jquery to achieve your design. Please follow steps: 1.Create a Choice column named "Condition" 2.Download the Highlight.js and upload to SharePoint Site Assets Library. <script src="https://code.jquery.com/jquery-1.12.4.min.js" ...


0

In that page are your webpart the only custom webpart embedded in the page? I mean, possibilities of your webpart that causes the redirect but if there is another custom webpart in the page it is also another possibilities that we need to consider. And, assuming its only your webpart that is custom in the page, what is your loadstuff function doing? it might ...


1

Make sure the list items are able to appear in search results. Ask the site administrator to check it at web level: If above settings are ok, check the crawl log at SharePoint admin center(with admin permission)to find whether the list has been crawled successfully.


1

If you want to dynamically change the choice option, you will need to use Rest Api with the action send http request Here is a demo I made to update the choice column, which works. Remember to change the Uri with your field name and the body. Results is the collection holding your new choice value { "__metadata":{ "type":"SP....


1

In the Body, use the Json below: { '__metadata': { 'type': 'SP.RoleDefinition' }, 'BasePermissions': { '__metadata': { 'type': 'SP.BasePermissions' }, 'High': '176', 'Low': '138612801' }, 'Description': 'New Permission Level Description', 'Name': 'New Permission Level', 'Order': 180 }


1

You could choose to use Update Item action in flow. Set a people field in SharePoint with Power Automate when all you have is a user’s name. FLOW UPDATE MULTI-SELECT COLUMN If you have got the user information in the previous actions, you could find them here.


1

OutSide of SharePoint Online Site, it's necessary to get the access token for authentication purpose. A solution is to register a SharePoint App and get the access token with this request: Then use the access token in the request to handle data: Here is a detailed blog for reference: Accessing SharePoint Data using Postman (SharePoint REST API) Postman is ...


0

You can use Compose action and Split function to extract the Filename string into substrings using the delimiter ' - '. See the sample flow here: And the expressions are: Compose: split(triggerOutputs()?['body/{Name}'],' - ') D: outputs('Compose')[0] Berlin: outputs('Compose')[1] Note: Since you do not need the last substring “2020-q*”, I have left it un-...


0

I would consider using the People Directory web part which is part of the SharePoint starter kit managed by the PnP team. The SharePoint starter kit is fairly easy to deploy to your environment and comes with a number of other great web parts.


1

Every application (SharePoint/Standalone) that I need to show tree view, before front-end developing, it's necessary to model the data structure to reflect this requirement; for example, to extract all planning data to tree, for example, using C# entities to make this: public class Department { public Guid ID { get; set; } public List<Category> ...


0

Currently there is no way to manually highlight the cell in SharePoint online list like word or excel.


0

Try using this formula: =IF(OR([Customer Name]="Company A", [Customer Name]="Company B", [Customer Name]="Company C", [Customer Name]="Company D", [Customer Name]="Company E"), "user@solutions.com", IF(OR([Customer Name]="Company F", [Customer Name]="Company G", [Customer Name]=&...


1

Using REST API, You can update People or Group field by setting field with user or group ID. Considering field name is AssignedTo, the format for user field value: Single-valued user field: 'AssignedToId' : 1 Multi-valued user field: 'AssignedToId' : { 'results': [1, 2, 3] } Where 1, 2, 3 are ID of users/groups. Example: References: Update a people field ...


0

This seems that the workflow waited too long for the response, and automatically requested the Rest again. Try to reset some attributes related to the workflow manager's HTTP request, such as WorkflowServiceMaxHttpResponseTime, WorkflowServiceMaxHttpRetryDelay Similar issues: https://docs.microsoft.com/en-us/answers/questions/168206/sharepoint-workflow-...


0

Before updating, you will first need to get the GUID of required term. A simple request will be like below: ‘__metadata’: { ‘type’: ‘SP.Data.YourListTitleListItem’ }, “TermFieldName”:{ “Label”:”Test Value 1″, “TermGuid”:”GUID of the Term”, “WssId”:-1 //which make sure to create an entry in TaxonomyHiddenList if not added. ...


0

SharePoint 2010 workflows have been retired since August 1, 2020 for new tenants and removed from existing tenants on November 1, 2020. It is recommended that you use MS Flow (Power Automate). Please follow steps: Upload Excel files to SharePoint Documents Library Create a List named "Excel List" to store Excel file Title Go back SharePoint ...


0

If you have a GUID of managed metadata term then you can use SharePoint REST API to update managed metadata column in SharePoint using Power Automate. Check below articles for detailed steps: Updating A Managed Metadata (MMS) Column Dynamically In A SharePoint List Using MS Flow Microsoft Flow: update Managed Metadata Column of a Document Set Microsoft Flow:...


0

You have to use Send an HTTP request to SharePoint with the below API /_api/web/lists('Libray-List Name')/Items(ItemID) Ref: Updating a row with METADATA FIELD in Rest API Also, this guide would help you to understand and work with Automate and Managed Metadata fields Read more at Update managed metadata column using term label or GUID Updating A Managed ...


0

As @Ganesh Sanap suggested, you may need to -UseWebLogin to sign in the MFA enabled account. And there is a new parameter -ForceAuthentication in the latest version of PnP PowerShell: https://twitter.com/PnpPowershell/status/1335362866069856258 https://pnp.github.io/powershell/articles/connecting.html If this parameter is specified it will clear the ...


0

As the other reply suggests, using People web part on a modern site page should suits your need. The web part would eventually look like this: The photo image comes from Delve profile, while the other properties come from user profiles, which can only be edited via admin portal (SharePoint admin center > More features > User profiles).


1

ShowInNewForm is a nullable property and has no value by default in SharePoint Online. You will need to update it first to have it return with value. The property can be found in Schema XML once given a value: Connect-PnPOnline "<SiteURL>" -UseWebLogin $ctx = Get-PnPContext $targetField = Get-PnPField -Identity "...


0

If you have already checked Office Delve and decided it's not an contender for your requirement, then you can use people profile web part in your SharePoint page. It would show the photo image uploaded by the user in his/her office 365 profile.


1

Please follow steps: 1.Create a Date and Time column named "Test_Data" 2.Then, create a Calcalated column called "Transmit Date" and copy the following formula to the Calcalated column:=IF(WEEKDAY(Test_Data)=1,Test_Data+21+2*4,IF(WEEKDAY(Test_Data)=6,Test_Data+21+2*5,IF(WEEKDAY(Test_Data)=7,Test_Data+21+2*4+1,Test_Data+21+2*4))) Note: ...


0

As a workaround, try to edit column settings on UI, as shown below:


1

Here is your complete answer to your 2 questions asked above You want to createt a SP Library using an HTTP request right? if so you can easily do that using Power Automate and "Send an HTTP request to SharePoint" action like this : For showing your SP Library to Navigation, you need to add :"OnQuickLaunch": true to your JSON body as ...


0

thanks a lot for your answer. For the title update, it's the same thing as creating a new library. when i try this, it creates a new one with the new name... my URI is the same , method POST and body identical. am I missing something ?


0

You can pass the parameters you want to the getTestDataDetails function, like: export default class OfficeUispfx extends React.Component<IOfficeUispfxProps, any> { constructor(props) { super(props); this.state = { items: [] } } public render(): React.ReactElement<IOfficeUispfxProps> { return ( <div className={...


1

For updating the library title, please use the body below: It is an update request. { "__metadata": { "type": "SP.List" }, "Title": "NewLibraryName" } For creating libraries showed in left navigation, you will need to add the property "OnQuickLaunch": true My test works like this:


0

Have you checked that the Search and offline availability settings in the sites with issue ? On the site, select Settings Settings icon., and then select Site settings. If you don't see Site settings, select Site information, and then select View all site settings. Under Search, click Search and offline availability. In the Indexing Site Content section, ...


0

Please refer to the following steps: Log in the Microsoft 365 compliance center Go to Reports page from the left navigation find Rentention label usage -> Show more Select the label you want to check in the Labels list -> Explore items Select Items with this label and location name in the upcoming page, label usage will be displayed on right. ...


1

No, the endpoint https://{site_url}/_api/site can only access a specific site collection. It cannot access other site collections, so it's not possible to get changes for all site collections in SharePoint rest api. Besides, the content base is in the back-end managed by microsoft, and we could not get any information in the backend. For your requirments, I ...


2

Solution first: You can use PowerShell to disable People in your organization sharing links in a site: Set-SPOSite -Identity <SiteURL> -DisableCompanyWideSharingLinks 1 Note that you need to be a Global admin or SharePoint admin to run the command. Turn “Allow access requests” off via Settings > Site permissions > Change how members can share to ...


2

Run the following Powershell script as an administrator:: $url = "https://test.sharepoint.com/sites/projects"; $userName = "username@test.com" $password = "*******" $cred = New-Object -TypeName System.Management.Automation.PSCredential -argumentlist $userName, $(convertto-securestring $Password -asplaintext -force) Function ...


1

As a workaround, you could create a calculated column and add the following formula: =CONCATENATE(TEXT(Num,"#,###"),"ft²") Test result:


0

Connect-PnPOnline -Url $row.URL -Credential $O365Credential #To Get the control********* Page = Get-PnPClientSidePage -Identity "home.aspx" foreach($webpart in $Page.Controls){ if($webpart.Title -eq "Button" -and ($webpart.HtmlPropertiesData.Contains("Log a ticket") -or $webpart.HtmlPropertiesData.Contains("Log a ticket ...


0

The modern list form for Event list is not yet supported for customization (using PowerApps). References: Modify Form in SharePoint Event List. / (You can vote for the UserVoice post here:) SharePoint Custom List Form: Event. You can take a look at developing a custom form as a web part using SPFx if you are open for programmatic customization.


0

Cool I got it: { "$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json", "elmType": "a", "txtContent": "Name for HyperLink", "attributes": { "target": "_blank", "href": "='https://sharepoint....


0

I was running into the same problem in Word. As it turns out, you have to "Enable All Macros" in the Trust Center.


0

Try using this: Connect-PnPOnline -Url https://contoso.sharepoint.com -UseWebLogin OR Connect-PnPOnline -Url https://contoso.sharepoint.com -PnPManagementShell -LaunchBrowser -UseWebLogin If you want to connect to SharePoint with browser based login. This is required when you have multi-factor authentication (MFA) enabled. Source: Connect-PnPOnline


0

You can achieve this in SPFx Web Part. `const file = await sp.web.getFileByServerRelativeUrl(this.newPageServerRelativeURL); const page = await ClientsidePageFromFile(file); page["json"].CanvasContent1 = "<div></ div>"; page["json"]....


1

If you are using Internet Explorer 11 with all the usual default settings e.g. document mode is set to 11 etc and encountering the error when using an out-of-the-box feature then you may need to raise a support ticket with Microsoft. You can do this from the Microsoft 365 admin center. If the error is caused by a custom solution which you have developed, you ...


0

You can customize SharePoint Online Search and Search results with PNP Modern Search WebParts in a fine granular manner: https://microsoft-search.github.io/pnp-modern-search/


0

A highly customizable solution for SharePoint Online is PNP Modern Search. With this WebParts it's possible to exclude any column from search https://microsoft-search.github.io/pnp-modern-search/


0

Per my test, I could reproduce this issue on my end. It seems to be a bug that on SharePoint online workbench it tries to request node_modules/react-dom/dist/react-dom.js instead of the react library


Top 50 recent answers are included