30,333 questions
0
votes
1
answer
252
views
User Information List is missing in Sharepoint site
I can not find the User Information List for my sharepoint site. I have people picker column in my list and I can assign them. Also I get the lookup Id value. But when I call the graph API with this ...
0
votes
0
answers
56
views
Can I access a SharePoint using Python, when I have username and password with MFA?
Is there any mean to access a SharePoint using an interactive Python script? The conditions are the following:
I have username/password for a user that can access the SharePoint online;
There is MFA ...
- 627
1
vote
0
answers
252
views
Programmatically generating Shortcuts in OneDrive to a SharePoint Document Library / folder
We are looking to leverage these shortcuts in lieu of deploying sync relationships via GPO for our SharePoint migrations moving forward, I am in the process of just seeing how feasible this is from a ...
-1
votes
1
answer
631
views
Power Apps show users instead of user claims format
I am reading a SharePoint list in Power Apps and the user data in list shows up like below:
i:0#.f|membership|[email protected]
Can I use a component to show user list here with single or ...
- 616
0
votes
1
answer
529
views
Parsing OData Select and Expand failed: Could not find a property named 'fields' on type 'microsoft.graph.site
I have this code inside my azure function which uses .NET core 8. to get all the items inside a SharePoint list which was modified since 7 days:-
Where i am inside the Development environment, so I ...
0
votes
0
answers
178
views
Lookup the Id from an array of objects in Power Automate
I am working on a Power Automate Flow that helps to bulk import data as new items into a Sharepoint list (List A) coming from an Excel file.
The Excel file contains flattened data that also contains a ...
- 3,512
0
votes
2
answers
93
views
Excel Macro pushing data to mulitple name column using SOAP XML
I've been writing a (surprisingly) simple VBA macro for my Excel file to add and upload data to an item on a SharePoint list. Everything works fine but I cannot, for the life of me, figure out what ...
- 3
0
votes
0
answers
14
views
How can I automate the process of cataloging dashboards on tableau onto a SharePoint list?
We have a Tableau site where dashboards are often published to and a sharepoint list where we're keeping a catalog of each dashboard. The list records information on each dashboard such as the title, ...
- 1
1
vote
0
answers
59
views
Call SharePoint Rest API with ADFS SSO
I am struggling to call SharePoint Rest API from a site which uses ADFS SSO Authentication. I have tried multiple solutions like this.
But I'm still stuck. Now I have built up a .NET Code to call the ...
- 1,256
0
votes
0
answers
51
views
SharePoint 2019 - List View Command Bar with BaseDialog and DropDown List
Hi experts: When I customize a List View Extension - Command Bar on SharePoint 2019 On-Premises and click on my custom Command Bar, my BaseDialog - Panel appears. I have successfully retrieved the ...
- 1
0
votes
0
answers
49
views
Send http to SharePoint - base64 image
I have a base64 string which I can view in a base64 to image converter.
The same string , using base64toBinary in a compose function, is viewable when the output is downloaded.
Using a send http ...
- 3
2
votes
1
answer
102
views
Trying to open text file via SharePoint with VBA
I'm trying to open a text file via Sharepoint to read but keeping getting an error message (Run-time 52 Bad name or number).
I get the debug error on strFile line: Open strFile For Input as #1
Dim ...
- 37
0
votes
0
answers
45
views
Copy SharePoint item from one list to another in separate site collection
I am looking for the best way possible to copy new list items in one site collection to another site collection. The list items belong to a calendar list and will need to be copied to another list in ...
- 11
0
votes
1
answer
55
views
Issues with personal Microsoft Sharepoint upload from Python
I am trying to use a Python script to upload a CSV file to a SharePoint personal directory, with a URL like:
https://{tenant}-my.sharepoint.com/personal/{user}_{tenant}_com/Documents/{path}
I have ...
- 909
0
votes
1
answer
30
views
cannot delete an input on my sharepoint site
I have lists on my sharepoint site that are connected to each other. An item is created in these lists when a user creates a project in our powerapp.
I need to delete one of the project entries, but I ...
- 3
1
vote
0
answers
46
views
Issue uploading CSV to SharePoint from Python
I am trying to upload a CSV of a Pandas DataFrame generated by a Python script to Microsoft SharePoint / OneDrive.
I cannot figure out how to get past the following error when I try to connect to ...
- 909
0
votes
1
answer
180
views
Azure AI Sharepoint Indexer issues - "apiError - Failed to update indexer"
I am setting up an indexer for our sharepoint library to interact with Azure AI Search. Here is the Datasource (Yes I am sending requests from a C# solution)
var url = "https://[search service ...
0
votes
0
answers
12
views
SharePoint Content Search REST API Call for specific document library and response in an array
I have SPFx solution and need to call REST API for Content Search functionality (find the text from documents) and the response should be particular library items in array.
Could you please guide on ...
0
votes
0
answers
35
views
Assign permissions to a user who isn't a member of a site via the REST API
I have a SharePoint library named "LIB_1" within the site "SITE_NAME".
I want to grant permissions to the user "[email protected]" for "LIB_1", but the user is ...
- 1
1
vote
0
answers
604
views
Using JSON code formatting in SharePoint List Gallery view to display list items as buttons which open URLs in the Embed web part
TL;DR
My JSON code (see below in 'Details') displays buttons horizontally. I want to display them vertically, but can't seem to achieve this. How do I go about doing this?
Details
I've created a ...
- 783
0
votes
1
answer
33
views
Power Automate - send email to specyfic people after changing choice column
I have a Choice column in SharePoint called Obszary_konsultacji, which can contain a maximum of 5 values (IT, Compliance, HR, Księgowość i Kadry, IT DO). When a new record is created, automated emails ...
0
votes
1
answer
85
views
Microsoft Graph API returns 404 when querying SharePoint file by siteId, listId, uniqueId
I'm retrieving the JSON representation of a SharePoint page using the endpoint:
GET https://graph.microsoft.com/v1.0/sites/${siteId}/pages/${pageId}/microsoft.graph.sitePage?expand=canvasLayout&...
0
votes
1
answer
51
views
Listing files in SharePoint Folder
I'm building a library with methods to use against the on-prem api for SharePoint, I'll skip the part on how we authenticate since I know that is working for other methods.
We're using a HttpClient to ...
- 319
0
votes
1
answer
130
views
How to Get a Retention Period of an File in sharepoint via Graph API
We are experiencing difficulties retrieving the Expiration Status from the Compliance Details of a document in SharePoint. Our goal is to extract this Expiration Status so that we can use it in an API ...
- 1
-1
votes
1
answer
62
views
Search for more columns of a lookup
My scenario is:
I have created a list, let's call it Customers, with a few columns, say CustomerID, CustomerName and CustomerTaxNr.
Then there's the Document Library in which I've created a column of ...
- 197
0
votes
0
answers
37
views
Take a picture with a webcam and add it to a Microsoft 365 profile
We -a school for adult education- are looking for a way to take a picture of our students and add it to their MS365 profile.
What we would like to achieve, preferably on a laptop in a supervised ...
1
vote
0
answers
9
views
SharePoint calculated IF(AND) column for status issue
I have a multiline if(and) with a quiz score that is a text datatype, and it works except for scores of 100.It evaluates 100 score as "Incomplete". I tried adding an additional line for '=...
- 11
0
votes
0
answers
78
views
Failure to authenticate a SharePoint connection with AuthenticationContext
I have the following python code in my Matillion PythonScript component:
from office365.sharepoint.client_context import ClientContext
from office365.runtime.auth.authentication_context import ...
- 1,938
0
votes
1
answer
222
views
New file on sharepoint, trigger python script
Each Monday, I have a number of files arrive in to a Sharepoint folder
Folder consists of Folder/different clients.
I have a python script (also stored on a different location in sharepoint) that ...
- 15
0
votes
1
answer
198
views
Power Apps: Collection passed through JSON function dropping columns with null values
I have an app and power automate combo where I am collecting columns from the selected gallery item in order to email the details to the user. When I check my collections, all desired columns are ...
-1
votes
2
answers
190
views
Sharepoint upload file via restapi Access Denied issue
I am trying to upload file to sharepoint via Postman.
I have following settings:
URL:
https://{tenantID}.sharepoint.com/sites/{mySite}/_api/web/GetFolderByServerRelativeUrl('/sites/{mySite}/Shared ...
- 79
0
votes
2
answers
393
views
MS Graph API - List getting all views for Sharepoint list
I am hoping I am just missing something in the documentation but I am trying to get a listing of all of the views for a SharePoint List. I have one with 4 or 5 custom views and when I search for ...
- 152
0
votes
1
answer
292
views
How to get Microsoft Teams SharePoint URL Programmatically for use by multiple Teams
I am trying to create a file using a Power Automate flow trigged by pressing a button in a PowerApp. This app needs to be usable by multiple Teams, and files generated by each Team need to be stored ...
- 21
1
vote
1
answer
38
views
Sharepoint REST Api fetch number column data with symbol selected
I am trying fetch number column data with the help of sharepoint API. Number can be fetched succesfully but in additional setting we can use symbol as prefix or suffix
For example the symbol is ...
- 1,115
0
votes
0
answers
83
views
Microsoft Power Automate Help Required for multiple image fetching onto the Word file from Sharepoint Image Column
I am working on a workflow in which I fill out details in Microsoft Power Apps, then after submission, the data is sent to Sharepoint. These details (including the image input) are then being fetched ...
0
votes
0
answers
83
views
Power Automate Microsoft Forms to Google Sheets
I'm new to Power Automate and trying to transfer form responses to a Google Sheet. I've set up the workflow, but when a respondent submits a form, only the response ID appears in the sheet. How can I ...
- 13
0
votes
1
answer
119
views
How to Restore Deleted Files from SharePoint Embedded via Microsoft Graph API
We're currently exploring SharePoint Embedded for the first time and are building our integration using the Visual Studio Code extension.
One challenge we've run into is restoring deleted files.
We ...
- 35
0
votes
0
answers
78
views
Get only field names where value is true from parseJSON array
Overview:
When a SharePoint list item is modified, I want to get that item's changed fields. I do this using PowerAutomate's function which returns an object that I convert into an array using the ...
0
votes
1
answer
68
views
Dynamically add hyperlink to sharepoint document library subfolder in list
How can I add a link to a list item column that is of type hyperlink. The link should be a link to a subfolder in a document library.
What the program does it creates a new subfolder in a document ...
- 1,253
1
vote
1
answer
274
views
How to fetch all SharePoint sites with Microsoft Graph SDK for Java
I want to fetch all SharePoint Sites a user has access to using graph SDK for Java (version 6.32.0). I've obtained the access token and created a graph client (I'd like to use delegated permissions to ...
- 13
1
vote
1
answer
77
views
Python MS Graph API does not download all files from SharePoint folder
I have used Python script with REST APIs to download and upload files from/to SharePoint till now. It was working fine. However due to certain constrains I need to switch to MS graph APIs to download ...
- 87
0
votes
2
answers
217
views
How do I configure URL Rewrite for IIS using Desired State Configuration (DSC)?
When automating a setup of an IIS site, I run into an issue that required me to use URL Rewrite.
However, I don't seem to get the grip of how to use the DSC Resource command WebConfigProperty ...
- 2,128
0
votes
1
answer
415
views
PowerApps - Obtain DisplayName
Our organization uses a DisplayName that is different from FullName for all things Microsoft.
Hence FullName maybe something like "John Smith" while DisplayName is "Smith, John (...
- 218
0
votes
1
answer
711
views
Person combobox in Power Apps - Default selection display issues
I have a SharePoint Online list with a Person column. I have created a Power Apps form to enter the data because I would like to be able to set up a default value for the field (the user should be ...
- 218
0
votes
1
answer
82
views
Attaching multiple excel files to different mails based on a specific cell values (preferably in PowerAutomate)
I created an excel file (excel file 1) using a simple macro which collects information such as "Full Name", "Work Stream ID", and a path to a different excel file for each employee ...
0
votes
0
answers
36
views
Referencing a .csv file outside of a working directory in Sharepoint
I'm working on a script that requires me to reference a table of data stored outside of my current R working directory. My working directory and data is all stored within my organization's Sharepoint ...
- 387
0
votes
0
answers
21
views
Editing of .aspx page in SharePoint SharePoint Server 2016
I am working on a SharePoint list which I did not create and where new items are added through a form (DispForm.aspx). In the list itself, many columns are duplicated with similar names and since I ...
- 73
3
votes
1
answer
177
views
How to Determine OneDrive or SharePoint Directory Using SHGetPropertyStoreFromParsingName
Question:
I have been using PowerShell to check the Available Status of a file in OneDrive or SharePoint directories using Shell32.dll. Previously, the GetDetailsOf function returned Available Status ...
0
votes
1
answer
116
views
Powershell script using Add-PnPFile to add same file to 2 different libraries isn't working
I wrote a script to add files to a document library within SharePoint. Pretty straightforward, however I now want to add that same file to a different document library depending on if certain criteria ...
- 107
0
votes
1
answer
102
views
Field cannot be updated - VBA SQL
I'm facing an issue when trying to update a Microsoft list. It goes well to SELECT and UPDATE some fields, but not to INSERT INTO.
Here is my code:
Sub SPListPushData()
Const SiteUrl As ...
- 301