Microsoft 365 & Power Platform Community call
💡 Microsoft 365 & Power Platform Development bi-weekly community call focuses on different use cases and features within the Microsoft 365 and Power Platform - across Microsoft 365 Copilot, Copilot Studio, SharePoint, Power Apps and more. Demos in this call are presented by the community members. 👏 Looking to catch up on the latest news and updates, including cool community demos, this call is for you! 📅 On 5th of March we'll have following agenda: Latest on SharePoint Framework (SPFx) Latest on Copilot prompt of the week PnPjs CLI for Microsoft 365 Dev Proxy Reusable Controls for SPFx SPFx Toolkit VS Code extension PnP Search Solution Demos this time Aimery Thomas (Avanade) – Extend PnP Modern Search solution with a custom layout to improve pages display Peter Paul Kirschner (ACP Cubido) – Creating agent chat solution with OpenAI GPT SDK and Semantic Kernel with SPFx Hugo Bernier (Takeda) – Creating UX gallery to pick templates - Building AI integrated SPFx web part 📅 Download recurrent invite from https://aka.ms/community/m365-powerplat-dev-call-invite 📞 & 📺 Join the Microsoft Teams meeting live at https://aka.ms/community/m365-powerplat-dev-call-join 💡 Building something cool for Microsoft 365 or Power Platform (Copilot, SharePoint, Power Apps, etc)? We are always looking for presenters - Volunteer for a community call demo at https://aka.ms/community/request/demo 👋 See you in the call! 📖 Resources: Previous community call recordings and demos from the Microsoft Community Learning YouTube channel at https://aka.ms/community/youtube Microsoft 365 & Power Platform samples from Microsoft and community - https://aka.ms/community/samples Microsoft 365 & Power Platform community details - https://aka.ms/community/home 🧡 Sharing is caring!
SharePoint Admin Center redirecting to SPFx Single Sign On Redirect Page
Hello, I've got an issue currently open with Microsoft Support however they're so far have been unable to resolve why I am being redirected to the SPFx Single Sign On Redirect Page when trying to access https://tenantname-admin.sharepoint.com/_layouts/15/online/AdminHome.aspx#/home or https://admin.microsoft.com/sharepoint I am automatically taken to this page: https://mytenant-admin.sharepoint.com/_forms/spfxsinglesignon.aspx#code=0.AS8AW0bSmouaik6V_eHePuABYHaI4Qh3YX5IuLXPlQweWYwvABo.AgABAAIAAAAmoFfGtYxvRrNriQdPKIZ-AgDs_wUA9P_WluBbcSJB8cYbx71lqqyGHXDLsQVhhZcLagG1nJVuzJmvdXqmMvfZLcR57oq4kV22VhbPOWpKyp9ABUF4tm7Pxs5I5_B3BPsDOD4QiS0VqO6gwAwQYNUc9pOjEloq0Bz1B1ZHnQMm-hG4V_82qj9O8Hx6rJ8JSpA9fBzhz51tsPClPQOBVpBU1fns_9bkraWscTBJnOlDTJv5hBrN1q6Fg7wqj5B2C9xdYCFBvb-VtaDifKLGrfvMUcnQ65q4QdOUogXsMT-jRVEQiLtMlqRb577n2BH0AQNrgAAOx2O4mlaICP0zryw6Gq3gZwnn8nCieusQ_zUqDUENaF9EDovxLvq-VDkNy7FUKU3lOlXqOE-j89oez7Wxpe-811wJUKVwv4nyeymNTqs4K7e1BHR-15iECb40bI65TvjzKSS-Zz9qBLu2c8vDxq18snuqpyhO_JxUIC7ya4qysOl1kexTqBjINizSrb7s94PXXJAzVBT_XuCZDPK2YaOewowrpPPzcV5d7M_HgezHDGI6_8YPZOI4SfKDWAQ4hN02LiexG71z3OtzUt1pPMErBVjzDMC1NGdNspu4f9JPAIjdBlYRbHRB0mt1HsbmJiVmbUpSDgoqz0VIBPeh_zVfhFp8Yv8qGBut6mbOCgG9IYppfX3K5j9hsEUYhKDpdSPSxcGuW2JfoOI6kD222eZ9WRyVip9WyAndCzO0yKp48op3z_5_NnqfVEWZEW4vNOkB3TZF3n8SI2OEu6eYODGjyZBKikhnMQ6o72PpO9V8lFQKejK_3-ll-Znh4nDpjkjoix8FCzAsLRydrV0I-4Zb2U4aTRDc7Z4ZkAUKyHHFjO_cIeMrw_mYmRmzF6SOsTX5cbwLcyukQiT-a9WLBg0UVQNkuQB0gruCANYYlP4d-aElOvODltEP&client_info=eyJ1aWQiOiI0MTljN2FhNS1hMzlmLTQwZGEtODQxZi02MDQ4OTA1YzliYzYiLCJ1dGlkIjoiOWFkMjQ2NWItOWE4Yi00ZThhLTk1ZmQtZTFkZTNlZTAwMTYwIn0&state=eyJpZCI6IjhhNjM0ZGQwLWYxYTgtNGE4NC1iNGQwLTcwNzAwYWQ1ODE4YyIsIm1ldGEiOnsiaW50ZXJhY3Rpb25UeXBlIjoicmVkaXJlY3QifX0%3d%7chttps%3a%2f%2fmytenant-admin.sharepoint.com%2f_layouts%2f15%2fonline%2fAdminHome.aspx%23%2fhome&session_state=3eeb8686-6f12-44cd-8159-1bb6ccf45bdb&correlation_id=5318a330-f909-411b-b997-a203bf473edb Any clue on what could be causing this as it only appears to be happening with my admin account. All other admins who have the SharePoint Admin role are able to traverse to the SharePoint Admin Center correctly. and Yes, I've tried this on 4 different browsers and several different computers - all resulting in the same issue.
SharePoint 2019 - Embed.aspx page
Hello, I've implemented an SPFX solution that displays document files retrieved from document library , once clicked, it should open the document in sharepoint's embed.aspx page from the field "ServerRedirectedEmbedUrl". But this field is always empty for the documents. Also, when i try to access the embed page through the browser like "http://servername/_layouts/15/embed.aspx" i see the error bellow: how can i fix this? knowing that this functionality is working normally for SharePoint Online, but iam struggling trying to implement the same for sharepoint 2019 server.
How to know if I can trust an SPFX webpart?
I am in the process of implementing an spfx webpart but before I need to make sure it is not a security threat. From researching I was not able to find if there is any way to run a check or provide a validation that the webpart is safe for the organization as it does ask for Graph API permissions, I do not think there is any issues with it, but I need to be able to have cleareance. This is the webpart: https://github.com/pnp/sp-dev-fx-webparts/tree/main/samples/react-accordion-dynamic-section
Issue while posting the request to Sharepoint list which has more than 5000 items.
Hi, I am using below code for my spfx soution to post my caml and getting beow 500 error. private getOpenstatus() { let _openCount: string = ''; let val="In Progress"; let camlQueryPayLoad: any = { 'query' : { '__metadata': { 'type': 'SP.CamlQuery' }, "ViewXml": "<View><Query><Where><Eq><FieldRef Name='Status' /><Value Type='Text'>"+val+"</Value></Eq></Where></Query><ViewFields><FieldRef Name='ID' /></ViewFields><QueryOptions /><RowLimit>5000</RowLimit></View>" } }; let spOpts = { headers: { 'odata-version': '3.0' }, body: JSON.stringify(camlQueryPayLoad) }; const queryString: string = "$select=ID&$filter=Status eq '"+val+"'"; let url: string = this.context.pageContext.web.absoluteUrl + `/_api/web/lists/getbytitle('IncidentDetails')/GetItems?$top=5000`; return this.context.spHttpClient .post(url, SPHttpClient.configurations.v1, spOpts) .then((response: SPHttpClientResponse) => { let lvlFive: string = ''; if (response.status === 404) { //Log.error('js-display-List', new Error('List not found.')); return []; } else { if (response.ok) { response.json().then((responseJson) => { console.log(responseJson); if (responseJson != null) { let length= responseJson.value.length; _openCount +=`<a class="nav-link active" data-toggle="tab" href="#open-incident">Open<span>(<span>${length}</span>)</span></a>`; this.domElement.querySelector('#openCountView').innerHTML = _openCount; //this.domElement.querySelector('#levelFive').innerHTML = lvlFive; } }); } } }); } Below is the Response from API with 500 code. { "odata.error": { "code": "-2147024860, Microsoft.SharePoint.SPQueryThrottledException", "message": { "lang": "en-US", "value": "The attempted operation is prohibited because it exceeds the list view threshold." } } } Could you please help me how can I fix it ? I need an urgent help and would be great if i can get the quick solution.
Fetch Data from on premise Database, SAP HANA Cloud for SPFx adaptive card Extension
I am trying to achieve. looking for how to retrieve and store data on a database system deployed on-premise, such as an SAP HANA solution that has its own database through the custom Viva Connections ACE(Adaptive Card Extension) card which I am trying to create. To give you an idea an example a customer has a locally deployed payroll Management solution that uses a local database. I am trying to connect the ACE card to that database to display the payroll information for an Employee in the card which will be added to the Viva connections Dashboard inside Microsoft Teams.Fetch Data from on premise Database, SQL, Oracle, or SAP for SPFx adaptive card Extension
I am trying to achieve. looking for is how to retrieve and store data on a database system deployed on-premise, such as an SQL server, Oracle Database, or SAP solution which has its own database through the custom Viva Connections ACE(Adaptive Card Extension) card which I am trying to create. To give you an idea an example a customer has a locally deployed Leave Management solution that uses a local database let's say as an example an Oracle database. I am trying to connect the ACE card to that database to display the Leave information for an Employee in the card which will be added to the Viva connections Dashboard inside Microsoft Teams. And also the employee should be able to create new leave requests through the ACE card from Viva Connections inside Microsoft Teams.
navigatedEvent is not loading in new site
When I switch between sites - Site A (eng) and Site B (polish), the navigation from term store is loading from Site A in Site B. I have called the navigatedEvent to render the navigation when switching between sites but somehow it is not triggering the navigation in Site B (polish). As it shows the navigation from english site for at least sometime. @override public onInit(): Promise<void> { Log.info(LOG_SOURCE, `Initialized ${strings.Title}`); super.onInit().then(_ => { console.log("super oninit called"); sp.setup({ spfxContext: this.context, defaultCachingTimeoutSeconds: 30, globalCacheDisable: false }); }).then((_) => { console.log("Sp Initilize"); this.context.application.navigatedEvent.add(this, this._renderPlaceHolders); }); return Promise.resolve(); } private _renderPlaceHolders(): void { console.log("NavigationApplicationCustomizer._renderPlaceHolders()"); console.log( "Available placeholders: ", this.context.placeholderProvider.placeholderNames .map(name => PlaceholderName[name]) .join(", ") );
Documents uploaded to a SharePoint Online library using the REST API can no longer be opened.
We have documents (Word, Excel, PDF, png, jpg) that were uploaded to a SharePoint Online document library last month using the REST API from an SPFx web part. These documents could be opened in the browser or downloaded from the document library. Yesterday (1/17) we noticed that all of those documents (regardless of type) now show a file size of 15 bytes. When downloaded and examined, their contents is the following text: [object Object]. This is not happening with documents that were uploaded using the SPO GUI. Those documents have a normal file size and can be opened. Was there a change to SharePoint online in the last week that would render documents uploaded using REST to be modified/corrupted? Here are more details on the SPFx web part and REST endpoint that were used: SPFx version 1.16.0 example endpoint URL: https://<tenant>.sharepoint.com/_api/web/GetFolderByServerRelativeUrl('FacilityDocuments/Acton')/files/add(url='test.xlsx',overwrite=true)?$expand=ListItemAllFields using the web part context spHttpClient.post const request = { body: file }; const response: SPHttpClientResponse = await spHttpClient.post( endpoint, SPHttpClient.configurations.v1, request );
