Repository for the PnP JavaScript Core component development together with community members
I'm using sp-rest-proxy in local development but i got this error
Because you don't have cookies (or auth token) locally.
The proxy thing is probably a solution. MSAL is another. If you are going to run directly in SharePoint then proxy is probably best.
Another option for you, a simple one, is to create a new page and point to your scripts on localhost
The proxy thing is probably a solution. MSAL is another. If you are going to run directly in SharePoint then proxy is probably best.
Another option for you, a simple one, is to create a new page and point to your scripts on localhost
Hey @onur-saf you can take a look at generator-sppp. It scaffolds none spfx projects with react, pnpjs and proxy ootb. However, I didn’t update PnPjs dependency to the recent yet. Yet, using recent PnPjs is just easy as bump the dependency, remove it from webpack externals and import PnPjs due to the v2 partial import guidelines.
@onur-saf on your err screen you have conditional access lock error. You can’t workaround it rather than reaching your admins to provide you an allowed route. It can be addin only auth, user app password and allowence in cas for your user. Or none proxy but aad app reg and openidc driven client side auth.
as @eirikb mentioned
While in SPO, why you aren’t considering SPFx native approaches?
@eirikb thank you :)
also how do I make 1 list work on multiple sites but only display some particular columns on each page
Hello everyone again, I need a help about WebPartZone. I couldn't found any article or something helpfull. I need to render a WebPartZone in my reactjs application it's not SPFX Project. is it possible ?
Question for the gurus. I have a scenario where none of the options seem to fit perfectly. We have a .NET Web API hosted in Azure and need to use SharePoint for document management (custom web front-end also involved). Our tenant is large, and we are not allowed to use App permissions (which grant full control to all sites in tenant), we cannot use on-behalf-of flow, because one requirement is management of SP User Groups which again requires admin consent to a permission that is too broad ... is creating a user account and signing into SP directly from our Web API the only option? I don't see this scenario talked about often, and PnPCore, etc. require you to go the Azure App Registration route ... any other ideas? Thanks!
It seems so bizarre that App Registration scopes do not provide more granularity. There are tens of thousands of SP Sites in our tenant, we cannot safely consent to the scope that gives Full Control over all sites (though this would make life easier) ... hopefully one day they let you specify a particular site/site collection.
Just found that. Wow! Still requires admin consent... but seems like I'll have an easier time getting that granted.
Quick ?: ChangeTokenStart in IChangeQuery in js - what kinda of date format is required here? i kinda want to check changes the last 7 days in a list. But i keep getting an overflow error in response: Error: Error making HttpClient request in queryable [500] Internal Server Error ::> {"odata.error":{"code":"-1, System.Data.SqlTypes.SqlTypeException","message":{"lang":"en-US","value":"SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM."}}}
@trillian74 copying your comment with solution https://github.com/pnp/pnpjs/issues/2125#issuecomment-1050732361 , thanks for finding.
Hi, Pnp js query retrieves lookup/User id with lookup/Email value only while using expand query.
There are more then 20 lookups/Users fields. Pnp expand query cannot be performed due to dynamic approach.
Is there a approach where i can retrieve lookup/user id with lookup/Email values with email, without using expand query.
There are more then 20 lookups/Users fields. Pnp expand query cannot be performed due to dynamic approach.
Is there a approach where i can retrieve lookup/user id with lookup/Email values with email, without using expand query.
No, unfortunately you can't do it without expand in OData. However, you can use renderListDataAsStream instead. It returns emails for user lookups. Another alternative, which only would work for small teams, is to fetch all users (if a number is not large) and join responses on a client side. I'd recommend renderListDataAsStream way.
Hi @koltyakov Thanks for your Quick reply. But while using renderListDataAsStream. its not retriving all the lookup fields. some fields might get not showed in result. here also i cant able to give viewfields due to thresold limit.
let getDataById = await sp.web.lists
.getByTitle("TestList")
.renderListDataAsStream({
ViewXml:
})
let getDataById = await sp.web.lists
.getByTitle("TestList")
.renderListDataAsStream({
ViewXml:
<View>
<Query>
<Where>
<Eq>
<FieldRef Name="ID"/>
<Value Type="Number">${id}</Value>
</Eq>
</Where>
</Query>
<RowLimit Paged="TRUE">1</RowLimit>
</View>,})
@koltyakov is it good to use fieldValuesAsHTML ?. it retriving all the data that i want. but lookup and user is on html syntax. Which may be i can try to parse and get the value. But i dont know its the correct way.
await sp.web.lists
.getByTitle("TestList")
.items.getById(4).fieldValuesAsHTML()
await sp.web.lists
.getByTitle("TestList")
.items.getById(4).fieldValuesAsHTML()
await graph.groups
.getById("0000000-0000-0000-0000-00000000000")
.members.count() I have also tried this but its returning whole user member.
.getById("0000000-0000-0000-0000-00000000000")
.members.count() I have also tried this but its returning whole user member.
@koltyakov
Or am I thinking about it wrong? If I have a library with 4000 folders, each with broken inheritance. Am I at 4000/5000 regardless of what unique permissions those folders have?
Hi Ryan,
Unique break inheritance limit is a "bit larger" than 5000. Just for the info.
It's possible to relatively quickly (in terms of scheduled task) to iterate list items checking HasUniqueRoleAssignments property.
@eirikb For typescript apps in Azure Functions I'm using https://www.npmjs.com/package/@microsoft/microsoft-graph-client and https://www.npmjs.com/package/@azure/identity with a dev dependency on https://www.npmjs.com/package/@microsoft/microsoft-graph-types.
To create a graph client I create a TokenCredential based on config (populated from environment):
/**
Retrieve the credential for accessing M365 services such as Graph and SharePoint.
We are using a ClientCertificateCredential since the function is likely running in different tenant to where
the M365 resources are located. We are avoiding using the standard environment variables that would
populate the {@link EnvironmentCredential} (as called from {@link DefaultAzureCredential}) as this should
allow us to use {@link ManagedIdentityCredential} when accessing other Azure resources.
*/
export const getM365AppCredential = (): TokenCredential => {
return new ClientCertificateCredential(
config.m365TenantId,
config.m365ClientId,
{ certificate: config.m365ClientCerticate }
);
};
Then the client is created with a bit of basic caching based on access token expiry times:
let cachedClient: Client = null;
let cachedClientExpiryTime: DateTime = DateTime.now().minus({ days: 1 });
export const getGraphClient = async () => {
const now = DateTime.now();
if (cachedClient && cachedClientExpiryTime > now) {
return cachedClient;
}
let accessTokenExpiryTimestamp = 0;
const credential = getM365AppCredential();
const client = Client.init({
authProvider: (done: AuthProviderCallback) => {
credential
.getToken("https://graph.microsoft.com/.default")
.then((accessToken) => {
accessTokenExpiryTimestamp = accessToken.expiresOnTimestamp;
done(null, accessToken.token);
})
.catch((err) => done(err, null));
},
});
cachedClient = client;
cachedClientExpiryTime = DateTime.fromMillis(accessTokenExpiryTimestamp);
return cachedClient;
};