Category "sharepoint"

Display data from SharePoint Online document library on Powerapp

I am looking for the best solution to get the documents from SharePoint online document library and display them on a website or power app. The website or app

SharePoint Framework SPFx , no exported memeber SP, PnPJs

Below is my code: import * as React from 'react'; import styles from './PnpfolderoperationsDemo.module.scss'; import { IPnpfolderoperationsDemoProps } from

Trying to open .xlsx file from sharepoint, tries to open it in MS Word instead

A user is trying to open an excel file (.xlsx) (using Open in App instead of in browser) from their Sharepoint site, but system tries to open it up in MS Word i

Excel Script and Flow problem - Script not found. It may have been unshared or deleted. clientRequestId: ebf53c05-7f24-4537-a91d-9edb8903eb8c

I have a PowerApp that takes a SharePoint list, filters the data, puts it in a collection, and calls a flow/PowerAutomate that formats the data and puts it in a

How could I display all the text of a column in a list?

I am using share point online and there is a news list. The problem of this list is that it shows only few lines of text in the Body column. If I want it to sho

AADSTS53003 error during getting file from sharepoint

I am trying to get file from sharepoint and everything is fine till I get: ValueError: An error occurred while retrieving token from XML response: AADSTS53003:

Refresh a variable within a foreach statement

We have a master registry within our on premise SharePoint environment, to keep this list accurate, we run a clean up script each day to remove the item within

Powerautomate Flow: sharepoint list name suddenly changed

We have had some flows running now for a few years and all of a sudden in a Get Elements action, the list name of a sharepoint list is displayed as "a6f9e2d3-ba

What type of accessToken scope/resourceType do I need when using Pnp-Powershell

In the PNP Docs it shows: https://pnp.github.io/powershell/cmdlets/Connect-PnPOnline.html#example-13 you can access the resource with an Oauth2 AccessToken: Con

calculate business day of the month in SharePoint

I have a SharePoint list where I need to find the next due date based on today's date and the business day. For example today is 5/13/2022 and the next due date

How to use Power Automate to send an email to a person who has been assigned to the corresponding item?

I'm trying to send an email to the individual who has been assigned to a project. I used "Get Items" to collect the information from the List and then a conditi

Transfer a modified sharepoint Excel file to another folder

Is there a way that whenever I modify an Excel file in sharepoint in the "INPUT" folder the file is then copied to the "OUTPUT" folder erasing the previous one?

SharePoint Flow: Collect Initial Approvals, then delay and send all for Final Approval on Date/Time

I'm looking for advice (or links to threads, which I searched for and couldn't find) on fixing a SharePoint Flow I've developed for our Weekly Highlights approv

How to have dynamic columns (like for weeks w1, w2, w3...) to contain number value as score in Sharepoint list

See attached spreadsheet screenshot. How to incorporate dynamic / ever increasing columns with custom labels such as W1, W2, W3 to contain number value (score 0

Sharepoint Locking Error when xlsm is Uploaded via VBA .SaveAs

I have this awesome vba macro that takes a template xlsm file saved on a shared drive and automatically uploads the file saved as with tomorrows date in the tit

Export excel/csv not working in SPFx with ag-grid

I'm using ag-grid react for SPFx in SharePoint. When I try to export file in workbench it's working fine. But when I'm deploying sppkg package in sharepoint the

Need Help Converting Embed Script to Iframe

Can't seem to get the embed code to work on a Sharepoint site page. > <script id="gnewtonjs" type="text/javascript" > src="//recruitingbypaycor.com/car

Unable to import from Sharepoint Excel file to an R dataset

I am trying to download an Excel in Sharepoint site into an R dataset. But I keep getting errors. I have also tried searching for solutions across forums for th

Powerapps Add Item to lookup field refresh combobox choices

I have two lists: Projects Contacts I have a powerapp that let you add new projects, it has a lookup field for contacts. In the app you can click add contact,

Add items to sharepoint list from parse json if missing

I have two lists, one is 8 items that are in a parse JSON, the other is a Sharepoint list with 3 items (Get items from Classes List), these lists have a unique