Recent Discussions
Importing JSON as a list in SharePoint Online via pnp
I'm trying to import a JSON list file to my Sharepoint online website. But it seems impossible to import it directly. Does anyone know a possibility via pnp because I saw a method on pnp named "fromJson" but I don't know how to use it to import my files to my SharePoint website. Thanks in advance!
PnP - Search Filters template with multi-values
How do I update the template for PnP filters to separate the multi-values? This is what the filter options look like now: This is what the filter options should look like: The code I have now for the filter template is: <content id="data-content"> <style> .filter { margin-bottom: 30px; } .filter--value { white-space: nowrap; overflow: hidden; text-overflow: ellipsis; display: flex; align-items: center; } .filter--message { padding: 10px; } .filter--name { font-weight: bold; font-size: 16px; color: rgb(119, 117, 111); padding: 0px 0px 5px; } pnp-filtercheckbox { max-width: 100%; } pnp-filtercombobox { flex: 1; } pnp-filterComboBox > div { display: flex; align-items: stretch; padding: 0; } .filterComboBox { align-items: center; flex: 1; } #{{@root.instanceId}}wrapper { max-width: 100% !important; } .ms-ComboBox { max-width: 100% !important; min-width: 100%; width: 100%; } .ms-ComboBox-container { width: 100%; } .ms-ComboBox-header { bottom: 0; height: 45px; position: fixed; top: 127px; } .ms-Fabric { width: 100%; } </style> <div class="template vertical"> {{#each root.filters as |filter|}} <div class="filter"> <div class="filter--name">{{filter.displayName}}</div> <div class="filter--value"> <pnp-filtercombobox data-instance-id={{@root.instanceId}} data-filter-name="{{filter.filterName}}" data-is-multi="{{filter.isMulti}}" data-show-count="{{filter.showCount}}" data-theme-variant="{{JSONstringify root.theme}}" > {{#each filter.values}} <option value="{{value}}" data-selected="{{selected}}" data-disabled="{{disabled}}" data-count="{{count}}">{{name}}</option> {{/each}} </pnp-filtercombobox> </div> </div> {{/each}} </div> </content> I've tried a few different options with the help of ChatGPT but did not get anywhere.
authenticationManager.GetACSAppOnlyContext: ExecuteQuery() - throws error "Token Request Failed"
Hi. I have a .Net Core v6 MVC project using Nuget Package PnP.Framework 1.13.0. This project works fine in LIVE on the App Service in Azure. However, using Visual Studio 2022 and debug on this project keeps throwing a "The SSL connection could not be established, see inner exception.'" or "Token Request failed". This has only started happening recently. I updated to windows 11 about 6 months ago. It did seem firstly intermittent and now it happends pretty much every time on the ExecuteQuery(). I'm wondering if there is throttling somewhere. AuthenticationManager authenticationManager = new AuthenticationManager(); using (ClientContext clientContext = authenticationManager.GetACSAppOnlyContext(_siteUrl, _clientId, _clientSecret)) { User Requester = clientContext.Web.EnsureUser(emailAddress); clientContext.Load(Requester); clientContext.Load(clientContext.Web); clientContext.ExecuteQuery(); Does anyone know if this still works in Debug Mode? Any help appreciated. Thanks. John.
Unable to retrieve version history of a file.
$file = Get-PnPFile -Url "https://???/sites/???/Shared%20Documents/some-file.docx" correctly returns the file object. $versions = Get-PnPProperty -ClientObject $file -Property Versions Get-PnPProperty : The object id "site:???:web:???:file:/sites/???/https: //???/sites/???/Shared Documents/some-file.docx" is invalid. At line:1 char:13 + $versions = Get-PnPProperty -ClientObject $file -Property Versions + ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ + CategoryInfo : WriteError: (:) [Get-PnPProperty], ServerException + FullyQualifiedErrorId : EXCEPTION,PnP.PowerShell.Commands.Base.EnsureProperty This is consistent for different files in different tenants that I have tested. Am using PnP PowerShell v1.1.10Copy-PnPFile does not honor version history metadata
The command completes successfully copying all version history, but does not honour the version metadata. It simply places the current time in date created and the current logged-in account as Creator for all versions. I'm currently using version 1.1.10 because of another bug. But this doesn't work in 1.1.12 either. You don't want to lose your history - a major issue.Microsoft 365 PnP - Microsoft 365 Platform Community moved
Microsoft 365 Platform Community (PnP) has moved to GitHub to align on the one door experience for the blog posts and the relevant assets. Front page - https://aka.ms/m365/community Blog - https://aka.ms/m365/community/blog Weekly community calls - https://aka.ms/m365/calls Videos - https://aka.ms/m365/videos On technical questions and discussions we recommend using the feature area specific forums or the GitHub issues. This move happened already in spring 2022 - but adding this message for additional clarity also in the forum.How to make 3 column layout using Adaptive cards in PnP Search Results
Dear Experts, I am working with PnP Search Results. Especially, I am customizing Adaptive Cards to show People's Card information in the Search Results and so far I got one column. Please visit the link below to see what I have done so far. https://github.com/merpssirk/demo/blob/main/image/PeopleSearcAdaptiveCard.png I want to have at least 3 column layout. How can I do that? Can you please guide me through this? Thank you.New-PnPMicrosoft365Group automatically connects to SharePoint Admin Center?
Hey Guys, I have some trouble with the cmdlet New-PnPMicrosoft365Group. I have to build up a connection to run PnP-Cmdlets, therefore I run: Connect-PnPOnline -Url "https://tenantXY.sharepoint.com/sites/anysite New-PnPMicrosoft365Group Connection is done with AppRegistration and Certificate Please disregard the missing Parameters "displayname", "mailnickname", etc. Can you confirm: Running New-PnPMicrosoft365Group builds up a connection towards the SharePoint Admin Center "https://tenantXY-admin.sharepoint.com" Does it disconnect from the connection towards the SharePoint Admin Center and connects back to "https://tenantXY.sharepoint.com/sites/anysite"? If I run the cmdlet Add-PnPSiteCollectionAdmin -Owners "email address removed for privacy reasons", does it add user1 as SiteCollection Admin in the SharePoint Admin Center "https://tenantXY-admin.sharepoint.com" or in the other site "https://tenantXY.sharepoint.com/sites/anysite"? Thanks in Advance Best Regards Marco
Application Background Creating Event
Hi, I am new for Microsoft Graph API. Purpose (What I want to achieve): A public Calendar with input new event. I want user if they fill the form of meeting in my website, the Graph API can create event to my calendar. They don't need to login to Microsoft Account to fill. Problem : I only see the example code of Delegated Account. Example: the app need Microsoft Account to login and it create event to their(user) calendar not mine. I have already retrieve account id, and calendar id. I have created app registration, client secret and add permission (Calendars.Read , Calendars.ReadWrite) of application permissions. Is it possible to do my purpose ? ThanksSharepoint form list footer send email, field [$Start Time] (possible href)? issue
We're using a sharepoint calendar list and the JSON code in the footer sends an email based on values in the current record. It's partially working and so far I've been able to populate the email subject and body using href and can retrieve the field [$Title] - a string. However I've not been able to retrieve the value [$Start Time] which is a field of type date and not a calculated field. [edit] found this to display a date in JSON but I couldn't get it to work inside the href 'block' "txtContent": "=toLocaleString(@currentField)" I'm not a developer so this is mostly cobbled together from around the internet and MS examples, thanks in advance 🙂 Chris Here's the current code { "$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json", "elmType": "div", "children": [ { "elmType": "span", "style": { "padding": "12px" }, "txtContent": "='Email trainer: ' + [$Trainer] + ' with details for: ' + [$Title]" }, { "elmType": "a", "attributes": { "iconName": "Mail", "class": "sp-field-quickActions", "href": { "operator": "+", "operands": [ "mailto:", "[$Trainer]", "?subject=WFD Training Calendar reminder for: ", "[$Title]", "&body=You are listed as trainer for the training event ", "[$Title]", " from ", "[$Start Time]", " to ", "[$End Time]" ] } } } ] } @sharepoint @JSON
Provisioning SharePoint lists rules
Are (SharePoint) list rules deployable? PnP schema, PnP PowerShell, or any other way? https://support.microsoft.com/en-us/office/create-a-rule-to-automate-a-list-or-library-151ea008-7fa6-409b-b0bd-b04a3b3cacd5#:~:text=With%20the%20list%20open%20in,complete%20in%20the%20next%20step.I met a error as "items are nested at level '9' which exceeds the maximum nesting limit of '8'."
Hi all: I met a error as "items are nested at level '9' which exceeds the maximum nesting limit of '8'." in power automate flow. Would you please tell me how to solve this issue in details? Thank you very much in advance:)How to set new column under special rule for a share point list?
Hi all: Now i need to set a new column for a list and it need to be set under special rule. The rule is combine strings from other column, like this "deptA+date+001" the last three bits need to add automatically when new item have been created. 001, 002, 003 ...... It will help us to statistic how many items during period for each department. It maybe like this: New column dept date deptA20211028001 deptA 20211028 deptB20211028001 deptB 20211028 deptA20211028002 deptA 20211028 deptA20211028003 deptA 20211028 The dept is get from department column and date is get from request data column. How to configure the new column in the share point list? Thank you very much in advance:)How to set new column under special rule for a share point list?
Now i need to set a new column for a list and it need to be set under special rule. The rule is combine strings from other column, like this "deptA+date+001" the last three bits need to add automatically when new item have been created. 001, 002, 003 ...... It will help us to statistic how many items during period for each department. It maybe like this: New column dept date deptA20211028001 deptA 20211028 deptB20211028001 deptB 20211028 deptA20211028002 deptA 20211028 deptA20211028003 deptA 20211028 The dept is get from department column and date is get from request data column. How to configure the new column in the share point list? Thank you very much in advance:)Microsoft emails with missing email headers
Hi, I came across with some emails from Microsoft specifically coming from viva-noreply@microsoft.com and cortana@microsoft.com which don't have any emails headers with them. I would like to ask the reason why these emails don't have emails headers. Thanks!
