developer
7769 TopicsAccessing Meeting Participant List via a Teams App (not a Bot)?
Hi everyone, I'm currently working on a Microsoft Teams App (not a bot), and I'm trying to figure out if it's possible to programmatically access the participant list of a meeting - either during or after the meeting - directly from within the app context. Here are my specific questions: Is it possible for a Teams app (not a bot) to access the list of meeting participants? If yes, what are the required conditions (e.g. permissions, app manifest settings, API endpoints, etc.)? Are there any restrictions regarding the app context (e.g. does it have to be running in a meeting side panel, meeting stage, etc.)? If anyone has experience with this or can clarify whether this is possible at all, I’d greatly appreciate your input! Thanks in advance, Michael39Views0likes1CommentAccessing Meeting Participant List via a Teams App (not a Bot)?
Hi everyone, I'm currently working on a Microsoft Teams App (not a bot), and I'm trying to figure out if it's possible to programmatically access the participant list of a meeting - either during or after the meeting - directly from within the app context. Here are my specific questions: Is it possible for a Teams app (not a bot) to access the list of meeting participants? If yes, what are the required conditions (e.g. permissions, app manifest settings, API endpoints, etc.)? Are there any restrictions regarding the app context (e.g. does it have to be running in a meeting side panel, meeting stage, etc.)? If anyone has experience with this or can clarify whether this is possible at all, I’d greatly appreciate your input! Thanks in advance, Michael26Views0likes1CommentManifest.xml is partially processed in Teams Admin panel leading to auth issue
Hi Teams dev community, we are facing a strange problem. We have developed a simple application on Teams that opens a tab pointing to a private Webview (accessible only via our VPN). When we deploy the manifest in our Teams test environment, the application works perfectly. But when we deploy it in our production environment, the manifest is only partially taken into account. We changed the UUID, upgraded the version number, but nothing works. The manifest is only partially taken into account, so the application does not appear, or sometimes it appears after several hours and there is a blank page on the front end and an invalid token error on the Msal backend (even though authentication works perfectly in our test environment). On the web, we read about Teams policies that may be different, but IT tells us they have never touched the Teams policies. Have you ever had this type of problem? Are there any tools to facilitate integration? Thank you in advance for your help.18Views0likes1CommentAccess releases bug fixes in version 2506
Need intro Bug Name Issue Fixed Error when trying to run append query When an update/append query qualified column references (e.g., Table1.Field1) the reference might fail to resolve and produce an error reading “The INSERT INTO statement contains the following unknown field name: Table1.Field1” Error when trying to save or run a query containing certain characters For queries containing some Unicode characters, attempting to run or save the query could generate the error “The SQL statement is invalid.” Can't create a query directly in SQL view We have now added a button to the Queries section of the Create ribbon to allow you to create a new query opened to the SQL editor, rather than the QBE (Query-By-Example) designer Exporting data to a text file might export some characters incorrectly When exporting data containing some Unicode characters and choosing the “Export data with formatting and layout” option, invalid characters would sometimes be output to the text file. Using the clipboard to transfer data from tables/queries to text did not work for some Unicode characters Access was not rendering text from tables/queries with the CF_UNICODETEXT format so when you copied a table/query from the Navigation Pane, then pasted into a destination that accepted text, Unicode characters might not be preserved When exporting to Email using the HTML format Unicode characters might not be preserved Some characters would be replaced by question marks rather than preserving the original content when exporting to HTML Email When exporting a table with a relationship but no lookup defined Access may hang during the validation step During export Access tries to create a lookup in Dataverse that corresponds to a lookup defined in Access for related tables. However, if a relationship was defined but there was no lookup defined for the foreign key, then Access could hang during the export process. If the Display Form option is set in the Options dialog, then any time the Options dialog is closed you incorrectly get a message saying that you must close and reopen the database for changes to take effect This could happen even if no changes were made. Access will now only generate this message if you really do need to close and reopen the database for changes to take effect.145Views4likes1CommentSPFX call gets error "interaction required" after turning on function's System Assigned Identity
I have an spfx web part that is connected an Azure Function. All was working until I turned on the System Assigned Identity for the function. Below is my configuration while it was working: Function app: contoso-fn App Service authentication enabled Unauthenticated requests get a 302 HTTP code Microsoft is the identity provider, with app registration "contoso-fn-auth" It allows token audiences from api://<id-contoso-fn-auth> and from <my-tenant>.sharepoint.com Allowed client applications include 08e18876-6177-487e-b8b5-cf950c1e598c and <id-contoso-fn-auth> CORS: https://learn.microsoft.com/en-us/answers/questions/4374948/spfx-making-call-to-azure-function-gets-error-inte and https://<my-tenant>.sharepoint.com App registration "contoso-fn-auth" (used above when setting up identity provider) Authentication > Web > Redirect URI: https://learn.microsoft.com/en-us/answers/questions/4374948/spfx-making-call-to-azure-function-gets-error-inte ID tokens issued only accounts in the tenant can access this API API permissions > contoso-fn-auth > user_impersonation ; Delegated; Status: granted for tenant Expose an API: Scopes api://<id-contoso-fn-auth>/user_impersonation The code in the SPFX to request the function is something like this: this.context.aadHttpClientFactory .getClient('<id-contoso-fn-auth') .then((client: AadHttpClient): void => { client.get(<url-to-the-fn>/api/upload)...}); In the SharePoint Admin Center, under Advanced > API Access, the user_impersonation permission is approved for contoso-fn. I then changed the Function app identity, turning on "system assigned", as I needed the function to authenticate against the Azure Blob Client, and now I'm getting the following error: interaction_required: Seamless single sign on failed for the user. This can happen if the user is unable to access on premises AD or intranet zone is not configured correctly I read something about turning on the function's system assigned identity affecting how I requests tokens using the aadHttpClientFactory, but I haven't been too successful in finding how to solve the issue (including internet search and asking several LLMs). I don't need my function to have user context (I could send that from the spfx) but I need this to work without any redirects. I would appreciate help to be able to call the function from the spfx seamlessly, while keeping the function secured with Microsoft identity. (porting from a https://learn.microsoft.com/en-us/answers/questions/4374948/spfx-making-call-to-azure-function-gets-error-inte, as requested)Solved61Views0likes1CommentSwagger Auto-Generation on MCP Server
Would you like to generate a swagger.json directly on an MCP server on-the-fly? In many use cases, using remote MCP servers is not uncommon. In particular, if you're using Azure API Management (APIM), Azure API Center (APIC) or Copilot Studio in Power Platform, integrating with remote MCP servers is inevitable.Spin Control only increments
I have a sheet that I use for tracking statistics. Each cell contains a simple number with 0 decimal places. I have added a spin controls in my sheet to simply increment and decrement the value of a field by 1. As I have added and tested the spin controls, I have found that many of them will only increment the field, not decrement the value. Both the up and down buttons are visible, but when clicking the down arrow in the control, the field is incremented improperly. Thanks for the help7.8KViews4likes17CommentsGet-PnPSiteTemplate: The remote server returned an error: (403) Forbidden
I want to copy one site collection from one tenant to another, so on the source tenant, I created this App Registering and I grant it full control on SharePoint:- And I define to use secret for the authentication:- Then I run this command:- Connect-PnPOnline -Url "https://****.sharepoint.com/sites/****Integration" -ClientId "***" -ClientSecret "ptv**" Connecting with Client Secret uses legacy authentication and provides limited functionality. We can for instance not execute requests towards the Microsoft Graph, which limits cmdlets related to Microsoft Teams, Microsoft Planner, Microsoft Flow and Microsoft 365 Groups. You can hide this warning by using Connect-PnPOnline [your parameters] -WarningAction Ignore then i got this error, when i tried to Get the site template:- Get-PnPSiteTemplate -Out "Integration.xml" Get-PnPSiteTemplate : The remote server returned an error: (403) Forbidden. Any advice? i remember i did this operation 1 year ago and it worked well. Thanks179Views0likes4CommentsAdaptive Card not Displaying On Teams Mobile
Hey everyone, I've been messing with Power Automate to create Adaptive Cards after every day to update the team on how we're doing. It works perfectly on Desktop, however, some text is not visible on Mobile as seen in attached pictures. The first picture is how it displays on mobile, the second is how it displays on desktop. Changing my theme to light still does not show the numbers that should be there. I've attached the adaptive card json at the bottom, any help is appreciated! { "type": "AdaptiveCard", "body": [ { "type": "Container", "items": [ { "type": "TextBlock", "size": "Large", "weight": "Bolder", "text": "DC Data for Last Shipping Day ", "spacing": "Large", "horizontalAlignment": "Center", "color": "Good" }, { "type": "TextBlock", "text": "Great work! We shipped @{add(add(int(variables('Output')[0]['Orders Shipped']), int(variables('Output')[1]['Orders Shipped'])), int(variables('Output')[2]['Orders Shipped']))} orders.", "wrap": true, "size": "Medium", "horizontalAlignment": "Center" } ] }, { "type": "ColumnSet", "columns": [ { "type": "Column", "width": "stretch", "items": [ { "type": "TextBlock", "wrap": true, "text": "Wisconsin:\n\n", "size": "Large", "weight": "Bolder" }, { "type": "FactSet", "facts": [ { "title": "Orders Shipped:", "value": "@{variables('Output')[0]['Orders Shipped']}" }, { "title": "Orders Left to Ship:", "value": "@{variables('Output')[0]['Orders Left to Ship']}" }, { "title": "Overdue Orders:", "value": "@{variables('Output')[0]['Overdue Orders ']}" } ] } ] }, { "type": "Column", "width": "stretch", "items": [ { "type": "TextBlock", "text": "Nevada:", "wrap": true, "size": "Large", "weight": "Bolder" }, { "type": "FactSet", "facts": [ { "title": "Orders Shipped:", "value": "@{variables('Output')[1]['Orders Shipped']}", "color": "Accent" }, { "title": "Orders Left to Ship:", "value": "@{variables('Output')[1]['Orders Left to Ship']}" }, { "title": "Overdue Orders:", "value": "@{variables('Output')[1]['Overdue Orders ']}" } ] } ] }, { "type": "Column", "width": "stretch", "items": [ { "type": "TextBlock", "text": "Mississippi:", "wrap": true, "size": "Large", "weight": "Bolder" }, { "type": "FactSet", "facts": [ { "title": "Orders Shipped:", "value": "@{variables('Output')[2]['Orders Shipped']}" }, { "title": "Orders Left to Ship:", "value": "@{variables('Output')[2]['Orders Left to Ship']}" }, { "title": "Overdue Orders:", "value": "@{variables('Output')[2]['Overdue Orders ']}" } ] } ] } ] }, { "type": "ColumnSet", "columns": [ { "type": "Column", "width": "stretch", "items": [ { "type": "TextBlock", "text": "TOTAL PERCENTAGE", "size": "Large", "color": "Accent", "maxLines": 3, "wrap": true, "horizontalAlignment": "Center" } ], "verticalContentAlignment": "Center" }, { "type": "Column", "width": "stretch", "items": [ { "type": "TextBlock", "wrap": true, "text": " @{body('Format_number')}%", "size": "ExtraLarge", "horizontalAlignment": "Center", "color": "Good" } ], "verticalContentAlignment": "Center" }, { "type": "Column", "width": "stretch", "items": [ { "type": "Image", "url": "imageURL", "horizontalAlignment": "Center", "spacing": "None" } ], "verticalContentAlignment": "Center", "backgroundImage": { "verticalAlignment": "Center", "horizontalAlignment": "Center" }, "horizontalAlignment": "Center" } ] } ], "$schema": "http://adaptivecards.io/schemas/adaptive-card.json", "version": "1.3" }Solved12KViews1like21CommentsA Little Help from my Friends
I am an advanced (expert) in Excel. I've used it for over 20 years everyday and have thousands of education hours under my belt. I would like to get some ideas on how some of you would approach this complex situation I have. I have already created three different methods but each have too many draw backs or failure points. With that said, I'll try to be brief but detailed enough for your thoughts. I have a file for which I'll call the Master-File it has a list of parts, suppliers, prices by month with Forecast and Actual. Current and Future months are forecast, previous months are actuals. I have 6 people that send me, what I'll refer to as Sub-Files. These subfiles contain the same headers as the Master-File. In the Master-File previous months data cannot change. (Ex. If reporting was done today 7/14 Actuals for June would be imported as Actuals and the remaining July thru December would be Forecast updated with the latest forecast data, which is already included in the sub-files). Months are listed left to right in columns not rows. Also, those sub-files can contain new parts that are required to be imported into the Master-File. My first solution was to use Power Query and import the Sub-files each month from a folder into the Master-file. Problem with that was, data from previous months would change in some of the Sub-Files and would over-write the data. (This data can't change once locked in). My second solution was to utilize a Unique ID for each record where I could easily identify new parts first and import that data by manually copying and pasting the data. Then sort the data using a match formula so the records in the Sub-file matched the Master-file and then manually copy and paste in the Actual and Forecast data. Some data was not correctly matched, so I started using XLOOKUP to import the data in the Actual and Forecast. Then, copy and paste as values. With 6 different files the table would at times over-write the data in the Actual forecast fields causing errors. Even after turning off auto table formula update option. Plus, this was very time consuming. Now I am starting over. I have some other ideas but if two heads are better than one then many heads are even better. I would love to hear your thoughts on how you would go about handling this process.97Views0likes4Comments