Following are questions that have been answered in our monthly office hours:
See Upcoming Office HoursProcessing JSON for Power Apps from a custom connector - Azure Functions?
What are the drawbacks and challenges of using lookup columns in SharePoint lists to emulate a relational database?
How to get senior management to buy into investing in technology?
What are some tips for adoption of Power Platform at an organization level?
Expiring access tokens with a custom connector - Azure Functions?
How do I notify external users when something happens in a Teams channel that they're invited to?
What toolsets do you use? Can anyone use / deploy SPFX to their SharePoint site?
What processes have we automated in the last year that helped us?
Is there a way to create a SharePoint page that will accept user input, parse an XML doc, calculate something and return a result to the user?
How can I stop users from having direct access to SharePoint list data, but still let them create and view the data from a Canvas App?
How does Matt really feel about Stored Procedures?
I have intermittent issues when submitting data to a SharePoint list using a Canvas app where my data is kept in a hidden form. Is there a better way?
What is the best way to manage deep links to my app, sent by a flow, when moving from one environment to the next?
How can I quickly rename (find/replace) an incorrect data source reference in my Canvas App?
I want to get aggregate counts for data from a list, grouped by some field in that list, into a collection in a Canvas App.
I'm trying to configure the Help Desk app for my organization and point it at my list of Tickets. How do I do this?
How do I set myself as an administrator for the Help Desk app?
What are best practices and tools you use for migrating content from one tenant to another or from a network share to SharePoint Online?
Is there any way to call an API (http) directly from a Power App? Can we use a Power App in offline mode to connect to a SQL data source?
How much customization should we do in O365 given Microsoft is changing things all the time?
How do I troubleshoot a runtime error in a Canvas App?
How do I deal with errors coming from Office365Users.UserPhotoMetadata() in Power Apps?
Could you explain the 5000 item limit for SharePoint Libraries and Lists?
Can I filter out the current user, user's supervisor, and direct reports when using O365 Groups connector to get users?
Can I use a Gallery in Power apps to display items from a list with 100k rows without performance issues if I manage delegation properly?
What is the best way to update a SharePoint calendar or list from data created in Excel?
Can I connect to two Azure tenants from a Power App?
How do I set a Canvas App Gallery item template to display 4 items in a 2x2 grid layout?
I passed MB-910. Now how do I become proficient with Power Apps?
What are some good resources for learning about Dev lifecycle?
What dev methodology do you prefer (Waterfall / Agile)?
How do I lock down my environment so that I can protect my content from being downloaded or shared outside my organization?
We have a SharePoint document library with 70k items. What recommendations do you have for organizing this content and helping users find what they're looking for?
How do I connect the Help Desk app to my SharePoint list data?
I'm unable to log in as Admin to the Help Desk app. How do I fix it?
How do you deal with putting personal identifiable data in SharePoint or Power Apps?
Do you prefer one screen or multiple screen Power Apps? Or is it dependent on another factor, such as number/size of data sources loading each screen?
Please describe what you see coming as the change to OnStart?
What are the top Power Platform features that Microsoft is launching that you're looking forward to?
What recommendations do you have for how to document apps for other developers?
How do I update all of the records from one data source based on data from a different data source (eg. updating a field in a SharePoint List based on data from a different SharePoint List)?
How do I update a multi-select choice field using a Power Apps Patch?
What are your thoughts on Power Pages?
What are some best practices for gathering requirements for new applications and processes?
How should I configure a Leave Request app that displays when other people have already requested leave?
In terms of Power Automate, is there a way to search a pdf attachment for keywords to assign meta tags?
How should I develop in the Power Platform today if I don’t have my final environment set up yet?
Is there an issue with putting everything in the OnStart module of PowerApps?
Is there a way to get data from planner, as we do from project on the web for reporting purposes?
If you do a get items action and you want the top record, is there a way to prevent the apply to each when doing an update action on the get item action?
Is there a way to export the Word templates so we can bring over the data to a SharePoint online list (using columns to match the fields in the Word template)?
How can I change the view of a calendar that has been migrated from classic to modern SharePoint?
Should I ask my guest users to switch to my organization before the Teams meeting (rather than after)?
How do I deal with a flow that is now spamming people in my organization?
Is it best to capture data in Microsoft Forms or SharePoint List and Libraries?
How can you leverage Office 365 resources for planning and project management?
Is there a way to automatically delete Microsoft Forms responses?
How can I embed a dashboard in my Canvas App?
What options can be used to implement role-level security in a Canvas App?
How can I streamline data collection for my employee onboarding process?
Matt & Mike, what upcoming Power Platform / SharePoint features are you excited about?
Should I use a Flow if I want a Canvas App to interact with a third-party API?
What alternatives are there for SharePoint as a database? I’m having trouble with it returning partial searches.
How can I calculate a score based on SharePoint form inputs?
Is there a way I can deep link between a canvas app and model-driven app, but have a way to go “back” to where I was in the canvas app?
Is it possible to create a deep link to a screen in a customized form that gets sent from Power Apps/Power Automate?
Why are multiple entries being saved in a customized SharePoint list form?
Can you distinguish between Portals in Power Apps (standalone) and Power Apps for Teams?
Should I use SQL or Dataverse for the data store of a Power Apps portal?
Can I rename a file in Power Apps to rename a file attachment in SharePoint?
Is there a way to branch the choice column in a SharePoint list?
How should we tackle migrating from SMB shares to a SharePoint Library? Especially with customer set up with a lot of permissions?
How do I change username to email in the sign-in page for a power apps portal?
I have an excel online file within One Drive with a table and I want to trigger it when someone updates this table. My problem is that besides when someone makes any change, it triggers when the excel online file reloads, so I get triggered more than once.
How can I integrate an existing help desk app with one we want to manage in SharePoint/Power Apps?
You mention you get different capabilities depending on where you make your team/group. Do you have recommendations on where is best to establish the group?
Is there a way to warn the user the form (in SharePoint) has been changed before they exit?
How do I build an app that redirects the user based on their permission/role?
Who has access to edit SharePoint forms that have been customized with Power Apps?
For the calendar icon in power apps, is there a way to change the background color? Not the icon background color in the advanced properties but the color of the background when you select the date. Is there a way to change it besides using the theme to change it?
What is your experience with scalable forms? How difficult is it to build a form that scales to fit different resolutions? Do i have to go in and edit the x and y of every control/object on the page?
What are best practices for setting up notifications in Teams Channels?
Dataverse Subscription - How do I know if our tier of service can use Dataverse or Power Apps Portals?
PowerApps - I’m frustrated that you can’t add components to the app rather than each screen, is there a best practice for this?
Modern Calendar View - Will the calendar dynamically update when new events are added to the list?
What measures should I put in place in SharePoint/OneDrive to have a smooth transitions when someone retires?
Modern Calendar View - When will we be able to set the modern calendar to a week view and color code the categories?
SharePoint Forms - Is there a way to show different forms based on rights. F.e. another view for an admin and another view for an end user?
SharePoint Forms - I followed this but I added three screens and for some reason when I save the form it creates three separate records in the SPO list. I want it to save to just one record.
SharePoint Forms - Can I create rules on the form? Also can the user review their data entry?
We have people submitting a form, and I already have a SharePoint list created. Is there an easy way for me to get all of these responses from the form into the SharePoint list?
I am having an issue with my flow creating a SharePoint item from an MS Form. The dynamic content for Title and Name fields were missing. Is this because I set up the SharePoint columns wrong?
Is using Power Automate from Power Apps the same as just going to the Power Automate start screen?
The Power Apps Theme Template, does it allow you to select a primary Font?
Can you help with saving files uploaded from Forms as attachments to SharePoint List items?
My SharePoint multi-choice column isn't working properly in Power App unless configured to allow a user to add new choices.
Can you help with capturing name/contact info using Microsoft Form and capturing input in a SharePoint List?
I want to create a ticketing system that registers inbox emails as tickets, and when dragged to another folder are registered as closed.
Help Desk App - I’m trying to grant myself admin permissions, but I keep getting an error message?
Is component importing/exporting in Power Apps deprecated?
Open to all. Ask us anything about Office 365 that you need help with!