New answers tagged

0 votes

Is there a way to collect data from all cards from a form to a collection? (Powerapps)

Is it possible to insert a collection or a table variable in a field of the sharepoint list through a powerapps form.
donjul's user avatar
  • 1
1 vote

Search syntax for the sender of *.MSG emails saved in SharePoint library

I have had a look at the search schema. I do not expect this to work. The filetype managed property is present but the others like recipient and sender are not present. author is present as managed ...
Paul's user avatar
  • 57
0 votes

SharePoint Online Page with Doc Library web part missing "Add shortcut to One Drive"

Unfortunately, this is not possible using SharePoint default capabilities at this time - this is a limitation by Microsoft. You cannot show Add shortcut to OneDrive or Pin to Quick access commands in ...
Ganesh Sanap - MVP's user avatar
0 votes

Cannot change the "Created By" column in a SharePoint list item using Graph API

I don't work with python but changing the created by value is usually not a problem. Granted, one would be better of not doing it, but sometimes we need to do what we need to do. Not sure if you've ...
Tiago Duarte's user avatar
  • 5,466
0 votes

SharePoint Calendar Scheduled events

Try filtering calendar list view based on Attendees column using [Me] like below: Documentation: Use filtering to modify a SharePoint list view
Ganesh Sanap - MVP's user avatar
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
0 votes

How can I use PnP Powershell to enable custom script in a subsite?

Custom script can only be enabled in the site collection level. In the SharePoint admin center, you can choose to allow users to run custom script on OneDrive (referred to as "personal sites"...
Emily Du - MSFT'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

Change the font size of the Section Name on a Collapsible Section

I agree with Ganesh Sanap, SharePoint Online does not provide default settings to customize the font size, font family, or font color of collapsible section titles. So, you cannot change the font size,...
Xyza_MSFT's user avatar
  • 381
0 votes

Standalone Power Automate per user plan for Premuim connectors

If you are trying to create a Power automate flow which will be ran using only one user account, it will work with per user plan in Power Automate. Check below Microsoft official documentations for ...
Ganesh Sanap - MVP's user avatar
1 vote
Accepted

Can SPMT Tool do - SharePoint Online to SharePoint Online

Question: Can the SharePoint Migration tool (SPMT) migrate content from one SharePoint tenant to another SharePoint tenant? Answer: No. SPMT can migrate content from SharePoint on-premises Server, but ...
Ganesh Sanap - MVP's user avatar
0 votes

Comments in read-only Word/Excel files

For Excel, a roughly parallel workaround is to Protect the sheet or workbook (Review -> Protect Sheet) Consider password-protecting the sheet or workbook to discourage the individual using the ...
dat's user avatar
  • 101
1 vote
Accepted

PowerApp DataCardValue.Text Returning as blank when not blank

To achieve this you need to do the following two steps: Set the form mode - Whenever you work with the Edit Form component you need to specify in which mode you are going to work. Since you want to ...
Ganesh Sanap - MVP's user avatar
0 votes

How to display more than one list in a single page?

Yes, it is possible to display multiple SharePoint lists on single site page. You can use List web part for adding lists on the SharePoint site page: References: Use the List web part - detailed ...
Ganesh Sanap - MVP'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

ClientContext API will not return items in Teams SharePoint site, works fine in SharePoint Online

Whether we're talking about C# or PowerShell, we need to authenticate in order to interact with SharePoint Online. Right now, Azure Control Service (ACS) is still available but it is deprecated and ...
Tiago Duarte's user avatar
  • 5,466
0 votes

Cannot change the "Created By" column in a SharePoint list item using Graph API

This is not possible, see: https://powerusers.microsoft.com/t5/Building-Flows/Change-created-by-column-in-SharePoint-List-item/td-p/1188628 Created By field is a system column and its value is ...
Martin Iszac's user avatar
0 votes

Do teams connected SharePoint sites not support direct access/advanced permission management?

It's possible to manage SharePoint site permissions separately from the Microsoft 365 group by using SharePoint groups (advanced permissions settings). If you want users to have access to related ...
Ganesh Sanap - MVP's user avatar
0 votes

What is the difference between `Add members to group` vs `Share site only`?

See: https://learn.microsoft.com/en-us/sharepoint/modern-experience-sharing-permissions When you add members to a group, the users permissions will be determined by the group you add them to. When you ...
Martin Iszac's user avatar
-1 votes

How can I use PnP Powershell to enable custom script in a subsite?

Set-PnPTenantSite is for site collections, not subsites. Use Set-PnpSite Set-PnPSite -NoScriptSite $false See more information here: https://learn.microsoft.com/en-us/sharepoint/allow-or-prevent-...
Martin Iszac's user avatar
1 vote

[Object][Object] Error Sharepoint Power App Table

For multiple selection choice columns, try using formula like this: AddColumns('QSAR Analysis Submission Data'[@Composition], "newColumn", Concat(ThisItem.Composition, Value & ", &...
Ganesh Sanap - MVP's user avatar
1 vote
Accepted

What is the difference between the members on home page vs members in the site permissions?

I think you are using SharePoint online team site connected with Microsoft 365 groups. The groups you see directly from site home page are M365 groups. And the groups you see under site permissions ...
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
0 votes

Change the font size of the Section Name on a Collapsible Section

Unfortunately, there are no SharePoint default settings available to change the font size of the collapsible section display name. Reference: SharePoint: Collapsible sections on modern pages - check ...
Ganesh Sanap - MVP's user avatar
0 votes

While setting up a SPFx solution, getting node:path error

When you look at the package.json file in your project, do you see line like this: "engines": { "node": ">=16.13.0 <17.0.0 || >=18.17.1 <19.0.0"}, If you do, ...
Mario Zagreb's user avatar
0 votes

How to customize tables in SharePoint?

I think that your best option to get close to what you have now would be to actually build an Excel spreadsheet and then embed it on your page. Your other option would be to build an PowerApp but that ...
Christoffer's user avatar
  • 9,801
1 vote

PowerApp DataCardValue.Text Returning as blank when not blank

You can try = Blank() instead of IsBlank(): If(DataCardValue1.Text = Blank(), DisplayMode.Disabled, DisplayMode.Edit) The IsBlank function tests for a blank value or an empty string. The test ...
jleture's user avatar
  • 881
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

Access information in hidden columns with JSON formatting

I had the same challenge. Calculated column was the answer. In my list there are 3 choice columns. I created a calculated column combining these 3 columns and with a column formatting I replaced text ...
Magic's user avatar
  • 1
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
1 vote

SPO Modern List - How to make the Attachments field mandatory?

This question looks old but answer might be helpful of someone here, To make Attachments column required in Modern Experience, go to the list setting --> click any column, on the top url , change ...
FanSira's user avatar
  • 11
0 votes

How can I provide access to different user over the Power BI report embedded into SharePoint page

Assuming all users have license to access the Power BI. You need to give user access rights in both places to SharePoint site/Page In PowerBI report as well. You could use Azure AD group to manage ...
Marek Sarad's user avatar
  • 3,540
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

How can I provide access to different user over the Power BI report embedded into SharePoint page

Follow below Microsoft official documentation for sharing Power BI reports with other users: Share Power BI reports and dashboards with coworkers and others Prerequisites: You need a Power BI Pro or ...
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

Looking for a Data Protection solution for Microsoft SharePoint - File protection and AGSCS compliant

Yes you, you can save files in SharePoint. The management of all content in SharePoint requires authentication of identity and permissions. To learn how SharePoint protects your data, read this ...
Karley Zhou-MSFT'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
0 votes
Accepted

Collapsible Grouped List Gallery View

We can group items in the item using JSON formatting as the example shown in this article: Build custom group headers. However, there is no built-in way to create a collapsible gallery view in ...
Allen_MSFT's user avatar
  • 1,021
0 votes

- DisableCustomAppAuthentication Parameter not found on Sharepoint Command set-spotenant -DisableCustomAppAuthentication $false

Install-Module -Name Microsoft.Online.SharePoint.PowerShell -RequiredVersion 16.0.20414.12000 This is the only version I found that had access to that property. Otherwise I received the same error ...
aalesund's user avatar
  • 101
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

How to render Document Library from custom web part

Please see if the answers in this thread are helpful to you. SharePoint Framework: how to display document library data in a SPFx client side web part using ReactJs and Type Script
Karley Zhou-MSFT'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

SharePoint online default templates

You can use PnP PowerShell script to remove page title / header section from SharePoint online modern experience site page: Connect-PnPOnline -Url https://tenant.sharepoint.com/sites/siteName -...
Ganesh Sanap - MVP's user avatar
0 votes

How to update links on SharePoint Online Modern Text Editor, dynamically on many pages within site collection?

You could possibly have considered using Document IDs so URLs to documents are kept even when moved to another library or site. https://support.microsoft.com/en-us/office/activate-and-configure-...
Anders Nielsen's user avatar
0 votes

Import web parts from SharePoint 2013 to SharePoint Online

What type of web parts are we talking? Most likely you will need to transform your web parts to SharePoint Framework web parts. https://learn.microsoft.com/en-us/sharepoint/dev/spfx/sharepoint-...
Anders Nielsen's user avatar

Top 50 recent answers are included