All board posts in Microsoft 365 PnP

New to Microsoft Build: Product Roundtables!

Michael Kophs — Wed, 19 May 2021 23:59:44 GMT

There is so much for you to learn by attending Microsoft Build (May 25th-27th) . And while you attend, we want to learn from you too! Join group discussions between you, fellow attendees and our product teams to share insights that will help shape the future of the products you use. Attend meeting covering a broad range of Microsoft 365 developer technologies; Teams, Graph, Identity, SharePoint and more!

Follow these steps to sign-up for a Product Roundtable:

Go to https://mybuild.microsoft.com and select “Register Now” (You must be registered for Build to participate in a Product Roundtable)
Once you’re registered and are authenticated, click the “Connection Zone” drop-down and select “Product Roundtables”
Browse the list of available Product Roundtable meetings; search for a keyword or choose from the available filters on the left.

Re: Hiding the SharePoint App Bar when embedding

Mike Hatheway — Mon, 19 Apr 2021 15:11:02 GMT

"?env=Embedded" seems to be working on system and form pages to hide the SP App bar now.

Hiding the SharePoint App Bar when embedding

Mike Hatheway — Tue, 16 Mar 2021 17:34:15 GMT

Does anyone know if you can hide the new SharePoint App bar (global nav) with a URL query param when embedding?

I've tried:

env=Embedded

and

env=WebViewList

which work in some instances, but not everywhere (e.g., List forms like newform.aspx, and most _layout pages I have checked).

Example: [tenant].sharepoint.com/_layouts/15/viewlsts.aspx?view=14&env=Embedded

That gets rid of alomost everything except the App bar.

Re: What do you use Microsoft Graph for?

waldek — Fri, 05 Mar 2021 10:14:09 GMT

When you build apps that span multiple workloads, that's when Graph truly gets to shine :flexed_biceps:

Re: What do you use Microsoft Graph for?

Luise Freese — Thu, 04 Mar 2021 16:27:04 GMT

When I read your reply, I could literally see the endpoints you are referring to :smiling_face_with_halo:

For everyone who wants to start exploring Microsoft Graph:

1. Head over to Graph Explorer, where you can experiment with it
2. Read the docs https://docs.microsoft.com/en-us/graph/

3. Get some more inspo here: Microsoft 365 PnP Blog - Microsoft Tech Community

4. Ask questions, we are here and happy to help!

#SharingIsCaring

Re: What do you use Microsoft Graph for?

waldek — Thu, 04 Mar 2021 15:55:41 GMT

Just this week me and my colleagues are working on a bot that shows trending content, upcoming meetings and tasks and allows you to quickly set a reminder for something - all powered by Microsoft Graph!

What do you use Microsoft Graph for?

Luise Freese — Thu, 04 Mar 2021 14:34:33 GMT

I am curious again - how do you Microsoft Graph? What did you build with it?

If you need some ideas, head over to our blog where you can find some cool articles

To me, it's almost the answer to everything, whenever I ask myself 'How can I build this?'

Re: What did you automate last week?

ganeshsanap — Thu, 25 Feb 2021 11:50:12 GMT

Data need to be loaded once in a month.

Re: What did you automate last week?

Luise Freese — Thu, 25 Feb 2021 11:47:56 GMT

Cool! do you need to do this regularly?

Re: What did you automate last week?

ganeshsanap — Thu, 25 Feb 2021 11:42:17 GMT

Power Automate flow to upload excel file data to SharePoint online lists

Re: What did you automate last week?

waldek — Thu, 25 Feb 2021 10:17:16 GMT

What did you automate? :beaming_face_with_smiling_eyes:

Re: What did you automate last week?

waldek — Wed, 24 Feb 2021 19:12:33 GMT

Not quite last week but something I’m using every day: permanently remove deleted messages and also getting a notification when publishing new post on my blog completed.

What did you automate last week?

Luise Freese — Wed, 24 Feb 2021 19:03:28 GMT

Again, I am super curious - and a big fan of automation! What did you automate? And which tools did you use? Dare to share?

Re: What did you build last week?

waldek — Tue, 23 Feb 2021 17:17:19 GMT

when looking at Azure Functions, please check out Proxies. They could offer you a lightweight way to pass requests between SharePoint Framework and your existing APIs extending them with the necessary information like API keys, tokens, etc.

When it comes to securing Azure Functions, the easiest way is by using the Authentication and Authorization settings and secure your Function with Azure AD.

SharePoint Framework has a built-in support accessing APIs secured with Azure AD.

One thing that I haven't checked, if configured proxies are subject to authentication and authorization settings. If they are, and proxies are sufficient for you to relay requests, they would be a great and robus solution that doesn't request any custom code on the API side.

Re: What did you build last week?

LindsayTShelton — Tue, 23 Feb 2021 16:43:31 GMT

I greatly appreciate it! We are working with 3 main types of APIs in this solution - one of them uses API tokens, one of them (Atlassian) says it prefers HTTP Basic and supports OAuth, but I believe it's OAuth 1 (it's on-prem), and the third is wide open because we just built it and if it gets locked down, it will be however we choose.

Last night we started looking at Azure Functions as an option since we are reaching out to everyone we can for advice, and that was one recommendation to use to take in the APIs and feed them right to SPFx.

Re: What did you build last week?

waldek — Tue, 23 Feb 2021 10:44:23 GMT

I totally understand your struggle. Like with everything unfortunately, there are multiple ways of doing things and often their effectives depends on an obscure detail.

Before I send you out to research something else, that might or might not work, what authentication model does your API support? Does it work with an API key or an app token that you need to add to every request either via query string or a header?

Re: What did you build last week?

LindsayTShelton — Mon, 22 Feb 2021 17:38:24 GMT

I really appreciate your input - would you have a good tutorial on getting the proxy-API secured by AAD? Part of our problem we keep running into is that it seems like all of the walkthroughs we find are doing something fundamentally different than what we are trying to accomplish, and of course we are getting different recommendations depending on who we ask without actually getting any data pulled through.

Re: What did you build last week?

Feder365 — Thu, 18 Feb 2021 15:46:25 GMT

Regarding to the document preview, the solution wasn't a list nor a SharePoint page with webparts. Starting with a document library, I created an image column and used src: @thumbnail in JSON code (knowledge source here). This is the result:

Re: What did you build last week?

Luise Freese — Thu, 18 Feb 2021 15:38:21 GMT

this sounds awesome! If you want to learn more about JSON, you can head over here: Introduction to JSON - Microsoft Tech Community

I recently build a document preview (dynamically) like this:

Create a dynamic preview for documents in SharePoint – M365 Princess - How did you approach this?

Re: What did you build last week?

Feder365 — Thu, 18 Feb 2021 15:10:24 GMT

I created the V2 of a SharePoint team site, including a mini knowledge base management system with metadata and document preview windows on hover and a Yammer communities catalog built with Microsoft Lists. I had to edit a lot of JSON card layout, but the result is pretty satisfying

Re: What did you build last week?

waldek — Thu, 18 Feb 2021 09:57:47 GMT

Connectors make a lot of sense if you plan to consume these APIs in Power Apps or flows. In the context of SPFx though, they don't add any value, because to use them, you'd need to build an HTTP-triggered flow that would expose the data as an API, which you already have. Instead, it would be easier to connect SPFx web parts directly to your API.

You mentioned that these APIs don't support OAuth. If this is the case, then building a proxy-API secured with AAD, which you could call from SPFx and which would relay calls to the API could help you.

Re: What did you build last week?

LindsayTShelton — Wed, 17 Feb 2021 17:46:41 GMT

The use case is building a dashboard with various SPFx web apps (maybe a pre-built grid like Kendo offers) connected to the client's various services - some more custom, and some more common like Confluence. We have been trying to build custom connectors through PowerApps with schema defined with some guidance from the glorious SharePoint Cowboy, who said they looked right. We aren't sure about authentication, because most of them aren't going to support OAuth 2.0, which the tutorials we are finding mostly involve authenticating through Azure and OAuth.

As the JUNIOR junior working on the SPFx side, I'm trying to figure out what I'm pulling in since we don't have it all cemented on the connector side, and how to specifically map the schema to one of those pre-built grid view lists. It seems like on some of the examples I was looking at, the data keeps pulling from a json file that's built into the web part, and I can't figure out how that would be updated live data.

Re: What did you build last week?

waldek — Wed, 17 Feb 2021 17:30:06 GMT

Cool! Are the connectors that you’re working with in SPFx APIs that you’d like to use? Anything specific that you’re blocked with?

Re: What did you build last week?

LindsayTShelton — Wed, 17 Feb 2021 17:26:28 GMT

I've been trying and failing with my team to figure out getting custom connectors into SPFx web parts, so I at least made some progress - whether it's down the right path, I do not know.

In terms of actual success, thanks to the Power BI community, I figured out with an Exchange data connection how to map the duration of categorized meetings into a growth visualization, comparing month to month, after many weeks of trial and error!

Re: What did you build last week?

Luise Freese — Wed, 17 Feb 2021 17:24:57 GMT

as always, it depends. There are use cases for SharePoint, Dataverse and SQL, even for Excel. From a licensing perspective, Dataverse for Teams solves a lot, as its seeded in Microsoft 365 licenses.

This is a nice post on how the decision on your backend impacts the performance of your app: Considerations for optimized performance in Power Apps | Microsoft Power Apps

Re: What did you build last week?

Marc Anderson — Wed, 17 Feb 2021 17:20:00 GMT

Fun with Power Apps and flows. Using those two tools along with a set of SharePoint lists, you can really build complex, valuable solutions. (I know - some people say we should use Dataverse, but that's not realistic in many organizations).

Re: What did you build last week?

waldek — Wed, 17 Feb 2021 15:55:15 GMT

Totally! We have several commands that focus on things that are relevant to end-users, like creating tasks, moving emails, etc. If you need to do more than one of something, CLI is a great time-saver!

Re: What did you build last week?

Luise Freese — Wed, 17 Feb 2021 15:24:38 GMT

sweet! So CLI is also a tool for individual productivity?

Re: What did you build last week?

waldek — Wed, 17 Feb 2021 14:50:57 GMT

I needed something to move a lot of emails from one folder to another. Started from building a flow. Ended up using CLI for Microsoft 365 8)

What did you build last week?

Luise Freese — Wed, 17 Feb 2021 10:04:11 GMT

I am super curious!

What did you build last week in Microsoft 365? Which problem did you solve? Where did you get stuck? What did you use? Want to share something?

Please reply below- don't be shy =)

Re: Phone Call Link in SharePoint View/Column Formatting

Mike Hatheway — Thu, 11 Feb 2021 15:12:06 GMT

Thanks

If anyone sees this change, please let me know.

I have a client that loves this "mobile card view" we built for thier contacts, but "phone" links would take it to the next level.

Cheers!

Re: Phone Call Link in SharePoint View/Column Formatting

Chris Kent — Thu, 11 Feb 2021 13:42:35 GMT

, Unfortunately, no. In List Formatting, link protocols are whitelisted and only http, https, mailto, and relative links (start with /) are allowed. All other href values won't be rendered.

Re: Phone Call Link in SharePoint View/Column Formatting

waldek — Thu, 11 Feb 2021 07:36:44 GMT

sounds like something that could be solved using a list formatter. Do you have any pointers that could help Mike?

Re: Does SharePoint Online Cache members of Azure AD Groups

waldek — Thu, 11 Feb 2021 07:34:59 GMT

Not sure if this is still the case, but I recall in the past folks had similar issues when using AD groups on prem, where changing group membership wouldn't update ACLs in SharePoint. I don't know the solution off the top of my head, but if you'd search for the similar problem but then based on local AD, you might find a workable solution.

Does SharePoint Online Cache members of Azure AD Groups

Russell Gove — Tue, 09 Feb 2021 18:47:37 GMT

Hi, and thanks for starting this forum!

We have an azure AD security group called ‘PowerApps-GCC-AM Control Group’ (ID is c2e5e562-3851-4417-a743-8b71fc43ecb6) .

The AD Group has directly been given READ permission to a SharePoint Online list called Global Complaints Webform.

A user (some.user@tenant.onmicrosoft.com) was in the AD Group previously but has been removed from the group (over a day ago).

When I check the users permission on the list SharePoint still thinks the user is in that group:

If the user browses to the list he can view the content of the list.

So it seems that SharePoint is caching the members of the AD Group somewhere.

Does anyone have any idea how to resolve this issue, or how this caching is done?

Phone Call Link in SharePoint View/Column Formatting

Mike Hatheway — Tue, 09 Feb 2021 17:12:33 GMT

Does anyone know of a way (or a workaround) to get tel:123-456-7890 links working in view/column formatting?

This would be very helpful for showing contact links with "click to call" on mobile.

It already works for "mailto" links, but "tel" links are not working.

What is the M365 PnP Community?

Luise Freese — Wed, 17 Feb 2021 15:23:00 GMT

Intro

The Microsoft 365 PnP Community is the virtual home for everyone who wants to extend Microsoft 365 beyond the standard. We want to share knowledge, learn from each other and achieve more together.

This hub will be a part of the Microsoft 365 Patterns and Practices community and will complement our existing initiatives under the PnP umbrella, such as our open-source projects and Community Docs, where we explain how the different features of Microsoft 365 work and offer guidance on how to use them.

Mission:

Our mission is to create a single inclusive and welcoming place for everyone who wants to build on Microsoft 365.

Goals:

Drop labels

We do not want to distinguish between so-called developers and citizen developers or spend much energy putting people into boxes. We want to provide guidance, knowledge, and reusable patterns and practices for everyone who wants to build on top of Microsoft 365, regardless of their profession, role, technical background, approach, or skill level. By living our Sharing is Caring mission, everyone will benefit.

One Community

Having one community as a virtual home for everyone who wants to extend Microsoft 365 will break down information silos and broaden everyone’s horizon, which will lead to better outcomes and more connected solutions. Sharing ideas across products using no code, low-code, and coded solutions in one single place will bring our communities closer together.

Lower entry barriers

We want to let our community grow and get new people involved, so we want to also cater to people who are not in that community right now and lower entry barriers. Helping everyone getting started rather than gatekeeping is one of our primary goals.

Being inclusive

Appreciating people from all backgrounds and with different expertise will ensure inclusiveness and improve our ability to step outside of our comfort zones and respect diverse perspectives. Learning that there is no pecking order of power users, makers, and developers but that we will be most successful when we focus on a bettertogether approach will make a huge difference.

What can you expect in this community?

We learned that people build solutions that span multiple Microsoft products with varying degrees of complexity, and we shouldn’t compartmentalize communities. We like to bring people together by guiding and sharing knowledge and listening to understand people’s needs. Please expect blog posts, videos, and open discussion on all kinds of topics around building on Microsoft 365. We are here to help.

How can you get involved?

This community doesn’t have any entry barriers; it’s made for everyone who extends Microsoft 365, including no-code, low-code, or coded solutions.

Join us for our community calls
Let us know what you'd like to know more about, please don't be shy, all feedback is welcome.
If you create (blog, vlog, code on GitHub) let us know where so that we can share it with others
If you'd like to show your work, let us know and we'll get you a slot on the community call
Meanwhile, explore what we have to offer

#SharingIsCaring ❤