I am using a shared spreadsheet from my company's Sharepoint site, so it's the "online" version of Excel. Basically, If text in column G equals "Classical", I n
I am trying to generate some code that will open up an excel file on Sharepoint and copy data into another spreadsheet. I have been using the below code when th
I have a SharePoint List (list_dls) which has all the Email addresses. The list has a single column with Field name "Title". I need to validate that the Item in
How do I create a folder on my list? I can create a file but I can't define a type. Should I define a type column? But how can I create a column with a type cha
I have a script within an excel that needs to loop through whichever folder its in on the Sharepoint, and attach it to an email. As I understand I need a direct
We have a Windows Application using MSAL with PublicClientApplicationBuilder to access SharePoint with the delegated permissions of the logged on user. When our
How do I add an item from an Excel file to a SharePoint list? I cannot use Access as an additional step here. Within Excel 2019 I run a macro and part of it sho
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
Below is my code: import * as React from 'react'; import styles from './PnpfolderoperationsDemo.module.scss'; import { IPnpfolderoperationsDemoProps } from
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
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
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
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:
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
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
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
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
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
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?
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