Microsoft 365 Kick Start

Turn your Microsoft 365 subscription from pain-point to business advantage with our expert guidance and streamlined process.

Intranet Roadmap

We'll help you plan the foundation for an employee portal that will give them access to resources they need and be in-the-know on what the organization is doing.

Private Coaching

Get personalized, expert guidance with our Private Coaching and overcome obstacles with a 1-on-1 working session.

Buy a Roadmap
Cart
0

Office Hours Questions

Following are questions that have been answered in our monthly office hours:

See Upcoming Office Hours

Processing 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?

December 7, 2022

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?

December 7, 2022

What is the best way to manage deep links to my app, sent by a flow, when moving from one environment to the next?

December 7, 2022

How can I quickly rename (find/replace) an incorrect data source reference in my Canvas App?

December 7, 2022

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.

December 7, 2022

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?

December 7, 2022

How do I set myself as an administrator for the Help Desk app?

November 2, 2022

What are best practices and tools you use for migrating content from one tenant to another or from a network share to SharePoint Online?

November 2, 2022

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?

November 2, 2022

How much customization should we do in O365 given Microsoft is changing things all the time?

November 2, 2022

How do I troubleshoot a runtime error in a Canvas App?

November 2, 2022

How do I deal with errors coming from Office365Users.UserPhotoMetadata() in Power Apps?

November 2, 2022

Could you explain the 5000 item limit for SharePoint Libraries and Lists?

October 5, 2022

Can I filter out the current user, user's supervisor, and direct reports when using O365 Groups connector to get users?

October 5, 2022

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?

October 5, 2022

What is the best way to update a SharePoint calendar or list from data created in Excel?

October 5, 2022

Can I connect to two Azure tenants from a Power App?

October 5, 2022

How do I set a Canvas App Gallery item template to display 4 items in a 2x2 grid layout?

October 5, 2022

I passed MB-910. Now how do I become proficient with Power Apps?

October 5, 2022

What are some good resources for learning about Dev lifecycle?

October 5, 2022

What dev methodology do you prefer (Waterfall / Agile)?

September 7, 2022

How do I lock down my environment so that I can protect my content from being downloaded or shared outside my organization?

September 7, 2022

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?

September 7, 2022

How do I connect the Help Desk app to my SharePoint list data?

September 7, 2022

I'm unable to log in as Admin to the Help Desk app. How do I fix it?

August 3, 2022

How do you deal with putting personal identifiable data in SharePoint or Power Apps?

August 3, 2022

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?

August 3, 2022

Please describe what you see coming as the change to OnStart?

August 3, 2022

What are the top Power Platform features that Microsoft is launching that you're looking forward to?

August 3, 2022

What recommendations do you have for how to document apps for other developers?

August 3, 2022

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)?

August 3, 2022

How do I update a multi-select choice field using a Power Apps Patch?

July 6, 2022

What are your thoughts on Power Pages?

July 6, 2022

What are some best practices for gathering requirements for new applications and processes?

July 6, 2022

How should I configure a Leave Request app that displays when other people have already requested leave?

July 6, 2022

In terms of Power Automate, is there a way to search a pdf attachment for keywords to assign meta tags?

July 6, 2022

How should I develop in the Power Platform today if I don’t have my final environment set up yet?

July 6, 2022

Is there an issue with putting everything in the OnStart module of PowerApps?

June 1, 2022

Is there a way to get data from planner, as we do from project on the web for reporting purposes?

June 1, 2022

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?

June 1, 2022

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)?

May 4, 2022

How can I change the view of a calendar that has been migrated from classic to modern SharePoint?

May 4, 2022

Should I ask my guest users to switch to my organization before the Teams meeting (rather than after)?

May 4, 2022

How do I deal with a flow that is now spamming people in my organization?

May 4, 2022

Is it best to capture data in Microsoft Forms or SharePoint List and Libraries?

May 4, 2022

How can you leverage Office 365 resources for planning and project management?

March 2, 2022

Is there a way to automatically delete Microsoft Forms responses?

March 2, 2022

How can I embed a dashboard in my Canvas App?

March 2, 2022

What options can be used to implement role-level security in a Canvas App?

March 2, 2022

How can I streamline data collection for my employee onboarding process?

March 2, 2022

Matt & Mike, what upcoming Power Platform / SharePoint features are you excited about?

February 2, 2022

Should I use a Flow if I want a Canvas App to interact with a third-party API?

February 2, 2022

What alternatives are there for SharePoint as a database? I’m having trouble with it returning partial searches.

February 2, 2022

How can I calculate a score based on SharePoint form inputs?

January 5, 2022

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?

January 5, 2022

Is it possible to create a deep link to a screen in a customized form that gets sent from Power Apps/Power Automate?

January 5, 2022

Why are multiple entries being saved in a customized SharePoint list form?

December 1, 2021

Can you distinguish between Portals in Power Apps (standalone) and Power Apps for Teams?

December 1, 2021

Should I use SQL or Dataverse for the data store of a Power Apps portal?

December 1, 2021

Can I rename a file in Power Apps to rename a file attachment in SharePoint?

December 1, 2021

Is there a way to branch the choice column in a SharePoint list?

December 1, 2021

How should we tackle migrating from SMB shares to a SharePoint Library? Especially with customer set up with a lot of permissions?

December 1, 2021

How do I change username to email in the sign-in page for a power apps portal?

December 1, 2021

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.

November 10, 2021

How can I integrate an existing help desk app with one we want to manage in SharePoint/Power Apps?

November 10, 2021

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?

November 10, 2021

Is there a way to warn the user the form (in SharePoint) has been changed before they exit?

November 10, 2021

How do I build an app that redirects the user based on their permission/role?

November 10, 2021

Who has access to edit SharePoint forms that have been customized with Power Apps?

October 6, 2021

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?

October 6, 2021

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?

October 6, 2021

What are best practices for setting up notifications in Teams Channels?

October 6, 2021

Dataverse Subscription - How do I know if our tier of service can use Dataverse or Power Apps Portals?

October 6, 2021

PowerApps - I’m frustrated that you can’t add components to the app rather than each screen, is there a best practice for this?

October 6, 2021

Modern Calendar View - Will the calendar dynamically update when new events are added to the list?

October 6, 2021

What measures should I put in place in SharePoint/OneDrive to have a smooth transitions when someone retires?

September 1, 2021

Modern Calendar View - When will we be able to set the modern calendar to a week view and color code the categories?

September 1, 2021

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?

September 1, 2021

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.

September 1, 2021

SharePoint Forms - Can I create rules on the form? Also can the user review their data entry?

July 7, 2021

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?

July 7, 2021

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?

July 7, 2021

Is using Power Automate from Power Apps the same as just going to the Power Automate start screen?

July 7, 2021

The Power Apps Theme Template, does it allow you to select a primary Font?

August 4, 2021

Can you help with saving files uploaded from Forms as attachments to SharePoint List items?

August 4, 2021

My SharePoint multi-choice column isn't working properly in Power App unless configured to allow a user to add new choices.

August 4, 2021

Can you help with capturing name/contact info using Microsoft Form and capturing input in a SharePoint List?

August 4, 2021

I want to create a ticketing system that registers inbox emails as tickets, and when dragged to another folder are registered as closed.

August 4, 2021

Help Desk App - I’m trying to grant myself admin permissions, but I keep getting an error message?

August 4, 2021

Is component importing/exporting in Power Apps deprecated?

Attend

Office Hours April 2023

April 5, 2023

|

2PM EST - 3PM EST

|

Online Event

Open to all. Ask us anything about Office 365 that you need help with!

Presenters