Questions tagged [error]
An error message is information displayed when an unexpected condition occurs.
1,198
questions
0
votes
1
answer
10
views
Problem with OneNote and SPO sync,
I have a problem with OneNote and sync (and opening unsynced OneNote) with OneNote File stored in SharePoint Online.
I receive this error:
Microsoft OneNote We couldn't open that location.[OneNote ...
0
votes
1
answer
16
views
What's wrong with my Calculated Column Formula Syntax?
I have a SharePoint list with 2 columns: Age and Age Group. The age groupings I want to display in the second columns are:
Under 16
16-20
21-30
31+
This is the formula I've tried:
=IF([Age]<16;&...
0
votes
2
answers
21
views
Can't get Lookup column data from list in SharePoint online
My list name is 'EmployeeData' and in that list my lookup column name is 'SectorId' and that column actual name is 'Sector'.
I want title of that lookup column:
https://site name /_api/web/lists/...
0
votes
1
answer
337
views
Unable to create a Solution "Provision cannot be performed because there is no linked CDS instance or the CDS instance version is not supported."
I am working on a new Power Platform environment, and when I tried to create a new Solution >> I got this screen:
and then I tried to create a new database, I got this error:
Any advice?
1
vote
1
answer
13
views
Dependency issue using viva connections extension in VS code
I have installed the Viva connections extension in VS code. When I create a new project I get this error:
[2023-04-26T19:04:44.654Z] [INFO]
Running command: yo @microsoft/sharepoint --solution-name &...
0
votes
1
answer
13
views
SharePoint 2013 : Get-PnPFile: No digest found!
How to download SharePoint 2013 document library files using the PnP command Get-PnPFile ?
Connect-PnPOnline -Url http://sharepoint2013site -TransformationOnPrem -CurrentCredential
$items = (Get-...
2
votes
1
answer
117
views
Power Automate - Action 'Get_tables' failed
Why am I getting error Action 'Get_tables' failed?
{
"status": 404,
"message": "The resource could not be found.\r\nclientRequestId: 58bfb995-21d7-4fda-af12-6f61e663b189\r\...
0
votes
0
answers
10
views
Cannot add excel file in web access excel web part in SharePoint Server 2013 on premises
The problem I'm facing is that when I'm trying to add an excel file into a web part of a SharePoint Server 2013 web page.
I'm receiving the following error:
The workbook cannot be opened"
Any ...
0
votes
2
answers
219
views
Microsoft List validation not working in SharePoint Online - Error: The server was unable to save the form at this time. Please try again
I have a SharePoint Online List.
It has some fields that are 'Required' fields.
I am also trying to use List Validation so that:
IF the value of MyChoiceColumn is Yes
THEN the AdditionalInformation ...
1
vote
1
answer
182
views
SPFx web part shows an error when viewed by external users
I have created my first web part following the steps in the Microsoft documentation tutorial. After struggling with many of the steps, I managed to get the web part up and running and added it to a ...
0
votes
1
answer
42
views
Get Items is raising this error "The expression "OriginalFilename eq 'Mothersday_FY24WK3_$70OFFGARMINLILYMOTHER'SDAYPROMO'" is not valid"
I have this Get Items action:
Now it is working well on some scenarios and failing on others, where on some instances it raised this error:
The expression "OriginalFilename eq '...
1
vote
1
answer
10
views
Can't return two differnt text values with forumula
I'm using this code:
=IF(Age>=5,"1W","0", =IF(Age>=10,"2W","0"))
I cant get it to return the values of 1W or 2W in the field. Any help would be ...
1
vote
1
answer
57
views
A type named ... could not be resolved by the model - but code is fine
I am trying to add an item to a SharePoint list synchronously. but I get the error
"A type named 'SP.Data.QAReadAndSignListItem' could not be resolved by the model. When a model is available, ...
1
vote
1
answer
59
views
PnP JS Person field only returns FieldId and FieldStringId
I have a list with a few columns that are Person columns. Below is a snippet without a select nor expand:
const newHires = this._sp.web.lists.getById(`${listId}`).items<ListItem[]>();
const ...
0
votes
1
answer
109
views
Using .env files with SPFx components - Undefined issues
I'm having a nightmare with using environment variables in my SPFx project. I have:
a .env in the root of my project
variables within this file all starting with REACT_APP_
references to these ...
0
votes
1
answer
155
views
Access SharePoint Online via CSOM with access Token from Username/Password in Azure Functions
I want to access a SharePoint site with a Token, which I get by Username and PW (AcquireTokenByUsernamePassword). I get the Token and I can access the site via Postman without any problems, but in my ...
1
vote
2
answers
14
views
ISBLANK WITH OTHER CRITERIA
I have a sharepoint calculated field that looks at a date and values in two other fields to populate with either a blank or a date.
First criteria:
Units > 0
Second criteria:
Type = "RDS"
...
1
vote
4
answers
505
views
Guest users cannot use SPFx web parts, by design?
I've encountered an issue where External / Guest users cannot use a SPFX Web part. Web parts instead return the error below:
Something went wrong
If the problem persists, contact the site ...
0
votes
1
answer
117
views
While trying to get user’s list of followed sites. By calling /users/{user-id}/followedSites endpoint gives "General exception while processing”
I was trying to get user’s list of followed sites (using application permissions). But calling /users/{user-id}/followed Sites endpoint gives "General exception while processing” error
and not ...
0
votes
1
answer
149
views
Getting JSON array value gives errors. I've tried two different ways
I am pulling Office 365 information into a SharePoint Online list and it works fine.
I have a 'Create Item' step for the SPO list and I add metadata from a Parse JSON step like this : body('Parse_JSON'...
1
vote
1
answer
108
views
Calculated column with IF condition
I'm writing from Italy. I have a list of 5 columns: one of them is called "available" and it's a yes/no column.
Another column is a text column called "last name". I want to create ...
0
votes
1
answer
96
views
CAML Query when using Or fails giving "Cannot complete this action"
I am creating an SPFX web part which queries a list in SharePoint Online
This works fine:
camlQuery = "<Query><OrderBy><FieldRef Name='LinkTitle' Ascending='TRUE' /></OrderBy&...
0
votes
0
answers
51
views
Unable to post messages on Teams using Micros
Getting the following error while running the python code:
{"error":{"code":"Unauthorized","message":"Message POST is allowed in application-only context ...
3
votes
1
answer
170
views
Appending Text to a Field within an IF Statement (JSON)
I am trying to append text to a field within an IF statement (intent shown in 3).
I understand how to append the basic text (shown in 1).
I understand how to set up the IF statement (shown in 2).
...
0
votes
0
answers
21
views
Unknown hard error when executing SP-Mount Database in SharePoint 2016 using PowerShell
I am getting Unknown hard error when executing SP-Mount Database in SharePoint 2016 using PowerShell causing the upgrade to stop.
We have below VM's with Windows 2019 and 32 GB of RAM:
1 Application ...
0
votes
1
answer
29
views
Unable to get "schemaXml" for a field using Rest API
I want to get "schemaXml" for a field, using this Rest API:
https://***.sharepoint.com/_api/web/lists/getbytitle('Documents')/fields?$filter=Name eq '_EndDate'$select=schemaXml
But I got ...
0
votes
0
answers
248
views
SharePoint REST api ODATA filter on nested array properties
I am trying to call SharePoint REST api with $expand and would like to filter on inner array object in the JSON. I tried few filter options but getting error for each of them.
Error:
The expression &...
0
votes
2
answers
26
views
'#Value!' error in filtered lookup column
I'm trying to create a filtered lookup from a 'Projects' list that sits on a SharePoint site.
I followed the steps to create a filtered column in a SharePoint list as outlined here: How to make a ...
0
votes
2
answers
118
views
Web-Part works on localhost, but it does not working on SPO
I have a webpart, which works on my localhost fine, i can read items from List "A", and can write items in List "B".
I deploy it on my site collection, so I add the sppkg file in ...
1
vote
1
answer
31
views
Calculated column Multiple with multiple IF(IF()) error
Good morning people. I'm sorry but I need your help.
I have tried to create a calculated column in SharePoint list, depending on two values "height" and "area" corresponds to a ...
0
votes
1
answer
14
views
Error when inputting Site Address and List Name in Power Automate
I'm trying to get my MS Form to be added to my SharePoint List as a new item using Power Automate. However, I am stumped on the step where I need to input my Site Address and List name.
I'm getting ...
1
vote
0
answers
61
views
Listview Command Set on SharePoint 2019
Has anyone succeeded in building a Listview Command Set on SharePoint 2019?
I am using SPFx 1.4.1 as recommended.
Problem: the custom buttons in the ribbon disappear after opening a different page (e....
0
votes
1
answer
35
views
Nested Calculated Column Returns Invalid Syntax
I have a column [Meeting Date] which is used to determine [Initial Date]. The user when creating a new list item, inserts a date for [Meeting Date] which is automatically set to Today's date. [Initial ...
0
votes
0
answers
64
views
"The server was unable to save the form at this Time. Please try again." 403 (Forbidden)
I am experiencing an issue with SharePoint 2016 server that when I want to create a new List I am getting this error.
From ULS log
Begin CSOM Request
Request is a Cross-Origin request. Origin is : '...
0
votes
0
answers
48
views
Error while executing web part: System.InvalidCastException: Unable to cast object of type 'System.Xml.XmlElement' to type 'System.String'
Working on SharePoint 2019 Server, I created a View 3 years ago, and it worked fine until few weeks ago. Here the xml:
<View Name="{39186434-EFEE-4BF6-BDE5-XXXXXXXXXXXX}" DefaultView=&...
0
votes
1
answer
146
views
How can I pass parameter to (Get-PnPUser | ? Email -eq ($SPUserEmail));
I have the following PnP PowerShell script:
$conn = New-Object System.Data.SqlClient.SqlConnection("Data Source=$DBServer;Integrated Security=True;Initial Catalog=$DBName") ...
0
votes
1
answer
24
views
SharePoint Calculated Column Multi Conditional Formula
I have a Final Submission Due Date calculated column.
I am trying to create a condition to where if another column (Yes/No Boolean) is checked add a certain value, if not use the original value.
I ...
0
votes
1
answer
12
views
Nof replacements counter not working as expected
Update item Noofassignments field has below expression and its working as expected
So when first time if for item modified with status active then Noofassignments counter will be 1 and ...
0
votes
1
answer
214
views
When item modified with trigger condition it should trigger email
I have set below Trigger condition when item create or modified
@and(equals(triggerOutputs()?['body/SRVolunteer/Value'],'Yes'),equals(triggerOutputs()?['body/SRroles/Value'],null))
Issue: It is ...
0
votes
1
answer
1k
views
Get files from a folder in Power Automate is not working
I am querying all files from a given folder in Power Automate. I have used the below in the filter query of Get Items action:
{FullPath} eq 'GSD Test Document Library/DS0001'
But while running the ...
1
vote
1
answer
410
views
gulp serve error
I'm trying to work on a project of a SPFx web part. The project was built normally but when I try to test my web part on my tenant the following error occurs:
Error: Your dev environment is running ...
0
votes
2
answers
110
views
I am getting list view threshold although all the columns involved in the filter and Sort are indexed columns
I have the Workflow tasks list which contain 42,613 items. and inside a list view i have those filtering and sorting (where all the columns are indexed):
But when we access the list view we got this ...
0
votes
0
answers
361
views
Getting -"Either scp or roles claim need to be present in the token" and Access Denied while using Graph API to upload files to SharePoint
Initially when I tried to generate the token using the URL - https://login.microsoftonline.com/tenant-id/oauth2/v2.0/token I was able to fetch the Bearer token using grant_type, client_id, scope and ...
1
vote
1
answer
136
views
SP Calculated Columns with nested IF statements
I'm looking for some advice on nested IF statements within SP as what I am trying keeps giving me errors. I'm trying to get my statement correct and if I can't should I be using a flow instead of the ...
0
votes
2
answers
999
views
Connect-PnPOnline : AADSTS50076: Due to a configuration change made by your administrator, or because you moved to a new location, you must use multi-
I have this script to connect to a SharePoint online site using username & password:
$encpassword = convertto-securestring -String "********" -AsPlainText -Force
$cred = new-object -...
2
votes
1
answer
96
views
Calculated column syntax error
I use this formula for the date to appear after changing the data in the column (two answers). This formula works for me:
(IF([Approve Status]="Approved";TEXT(NOW();"dd/mm/yyyy hh:mm&...
0
votes
0
answers
347
views
{"The remote server returned an error: (401) Unauthorized."} error during accessing SharePoint site shared Folder files
string siteUrl1 = "https://#######.sharepoint.com/sites/####";
string clientID = "#####################################";
string clientSecret = "#######...
0
votes
0
answers
17
views
Prevent holidays from selection in MS List Date/Time Field using column validation
We have a simple task tracker with two due date columns that are both date/time columns [Requestor Due Date] and [Due to OPO].
Note 1: The "Due Date" shows as DueDate in the hyperlink when I ...
0
votes
1
answer
31
views
Power app formula error
I have an error on this calculation:
Trying this:
Text(Value(TextInput2)+Value(TextInput2_1)/2)
Any ideas?
0
votes
0
answers
42
views
SharePoint 2019 Relevant Documents Web Part throwing "...exceeds the list view threshold enforced by the administrator"
I'm pretty new the SharePoint scene and have just started a new job where I've been asked to take up some of the support. The site is using the "Relevant Documents" web part and is ...