Category Archives: MNSPUG

Minnesota SharePoint User Group

pexels-photo-209728.jpeg

Why I Do Community

Why? Why, why, why… It’s a good question and not one I often think about because I decided a while back that it’s worth the time and investment – at least for me. Let’s see if something resonates for you to get involved.

The “why” for me is a combination, if not a balance, of selfish reasons and a desire to contribute.

It’s Fun!

Reason 1. I find contributing to the community to be fun and rewarding. We are extremely fortunate to have a community full of awesome people that are fun to be with. Consumers of our content are very appreciative and take the time to say "Thanks". 

“Thank you so much for that. It’s exactly the information I was looking for.”

– Variations from attendees at different conferences, most recently at M365 Community Days in Ottawa.

Participating allows me to share experiences – other than (and often counter to…) what product marketing puts out – with folks. It fills documentation and experience gaps, it provides practical examples that may align with a certain perspective or apply to a specific vertical, and shares discoveries that others may not have figured out yet.

Share What You’ve Learned

Let’s expand on that last thing for a minute. For me, it’s a prime example for many folks to contribute to community – through a blog post, a forum answer, a video, or some other way.

Reason 2. A scenario: Someone wants to accomplish something, finds a challenge along the way, and figures out the trick, the path, or method to overcome it. Finally, they want to share what they found so others don't have to experience that same pain. I regularly hit on this same scenario. 

Self-motivated learners navigate these paths every day. Sometimes its SMEs digging in to explore and exercise platforms. Sometimes its folks doing their jobs day after day. Community contributors go another step and share what they’ve learned with others.

We need to strike a bit of a balance here IMO. I don’t want to underplay the sharing part. It can take a significant amount of time to do effectively. Creating content (writing blog posts, producing videos, etc.) seems trivial, but often requires research time, writing time, production efforts, etc. – none of which is easy. I also don’t want to overplay the sharing part into some martyr-like effort, but it’s worthwhile to understand the efforts being made by folks and the organizations that employ them.

Stay Connected

Reason 3. Working with the community allows you to stay connected with the community. 

So many examples: Organizations using similar tech, 3rd party companies offering products and services in your market, and folks in a variety of roles working with similar products and in similar verticals. It gives you exposure to what other folks are using and running into in their jobs, from their varying perspectives.

Be an Example

Reason 4. I like to contribute to hopefully be an example for others to repeat. 

This doesn’t mean folks will choose to do the same things I’m doing, but it should demonstrate that they can – and at different scopes. Not everyone needs to speak at public conferences. They can, in many more cases actually, present internally at their organizations to others that need the info they have.

I tend to operate within product-specific and geography-specific community (M365 or Power Platform in Minnesota) – But many organizations are large enough and have technical user communities that can benefit internally from similar actions (lunch and learn sessions, internal blog posts, etc.). Imagine the improved ROI for those product licenses you’re paying for if more people know how to use the tools specifically in the context of your company…

Hey, if I can do this, you can do this. Have you learned something that others might benefit from? Talk about it! Write a blog post or submit a session.

It’s Good Exercise

No, not the physical “exercise” like working out. Though, we do get a lot of steps in attending and running events.

Reason 5. Contributing to the community is a good exercise in personal and professional skills. 

Skills that are useful in our professional and personal lives like communicating, listening, writing, (public) speaking, networking, planning, and many other things. Like many of these skills, they need practice. Practice to ramp up, maintain, and eventually mentor others.

So, if you didn’t need another reason, jump in to better yourself and grow your skills.

Retrospective

I would say my experience (in the context of the current technology community) started with combination of excitement about a technology (yep, SharePoint – a little geeky) that solved some business problems (helping people) and wanting to get more comfortable speaking in front of folks.

I like to share what I know – knowledge, experience, tips and tricks, and more – if it can help someone else. It’s the same general concept that drove me to do consulting, which is a lot of the same thing but being paid for it because you’re working specifically for someone and addressing their needs and efforts.

When I worked for a consulting company, community contributions were useful for a number of reasons. It established credibility – for me and my company – in my topic/technology area. It was good marketing getting the company name out there. It looked good from a “we care about the community” perspective as an organization. That sounds like it’s trying to make us look like something we weren’t – but we were legitimately interested in building community.

Summary

This was maybe a bit more introspective and retrospective than usual. Hopefully still useful to someone. I’m sure there are other reasons I could list, but this is already longer than intended so we’ll stop here.

Get involved. It’s fun and rewarding.

Follow up:

people holding their phones

Community Events – Local Reach

Another BIG event going on this week in the M365 world: M365 Conference 2023 in Las Vegas. It’s a 3rd party conference, though heavily invested and involved with by Microsoft by way of speakers, keynotes, sponsorship and other content. Lots of big announcements.

But not everyone can attend.

Not everyone can get there. Not everyone *wants to* attend or go to Vegas. And with a looming recession and/or economic outlook for many organizations, it might not be a great time to send folks to out of state costly conferences.

Enter… local events.

Now, I’m not trying to poo-poo these big events. They’ve got a ton of value. I speak at some of them. They’re a fantastic opportunity to step away from your day-to-day responsibilities (if you can…) meet with community (topic-wise, not geographic community) folks, spend time chatting, building broader networks, or meet and connect with Microsoft and vendor contacts. The coverage that larger events offer is also extremely important in that you can see so many sessions, workshops, vendors, and more in one spot. In addition to this week’s event, there are events like 365 EduCon that offer options in more cities throughout the year.

What I am saying is that local – usually community-run – events have a place, an important one – for many folks.

Community events like our M365TwinCities event (working on a Fall date…), the upcoming MN M365 User Group Spring Workshop, or even frequent M365TC #CoffeeCrew events fill important gaps in our communities. In upcoming weeks here in Minnesota we’ll be reviewing this week’s big announcements from Microsoft, offering more in depth coverage with workshop sessions, or just having a coffee and connecting with others. Similar groups will be meeting all over the US and the world doing the same thing.

SO. Get familiar with your local community. Join it. Take part in it. Contribute to it with your time and experience. And if there’s not a community you’re looking for – consider building one!

SharePoint [Me] Filter in PowerApps

SharePoint has a couple of built-in filters for column values: [Today] and [Me]. These allow users to filter views by dynamic data. For example you can create a view called AssignedToMe and set a filter like so:

image

Using this approach site admins don’t need to create views specific to each user, but can use the [Me] filter on a single view that applies to each individual user. As a user visits the view, they see only the records that are specific to them.

How does one do this in PowerApps when filtering data? Good question. This came up during our Minnesota SharePoint User Group (MNSPUG) meeting today and good old Brian Caauwe knew the answer: rather than using [Me] we use the User function in PowerApps.

On a gallery or data table object, our Items property might have a formula something like this:

Items = Filter(‘IT Request’, AssignedTo.DisplayName=User().FullName)

Note: When bringing fields over from SharePoint, PowerApps translates the CreatedBy and ModifiedBy fields to something a little different. That might be a little confusing when getting started.

  • CreatedBy –> Author
  • ModifiedBy –> Editor

Good questions from the attendees today and good catch by Brian with the User() answer. Smile 

References

SharePoint, PowerApps, and List View Permissions

While discussing SharePoint list views during a recent SharePoint 101 session at our local SharePoint User group, the inevitable question about permissions on columns and views came up. Standard answer: ‘No’. Permissions in SharePoint are set at the list level, or the item level. Nothing is available at the column or view level. However

Here are the facts (today – this stuff changes so fast…):

  • Permissions on SharePoint lists are set at the list or item level. There are no SharePoint settings for permissions on a specific view.
  • PowerApps are surfaced in the views dropdown.
  • PowerApps permissions are set at the App level.

Are you there yet? Did you make the connection? Yep. You can have an item in the view dropdown with permissions different than the list itself. You can now have a ‘view’ with its own permissions. PowerApps are even integrated enough to *not* show up in the dropdown if you are a user that doesn’t have permissions to the App.

image

Now, PowerApps are not as simple to create as a SharePoint view, but it is possible. Currently two facts hamper users a little bit here.

  1. The current SharePoint to PowerApps ‘wizard’ only creates a phone layout App. Not something that easily replicates a traditional SharePoint view.
    image
    Don’t get me wrong, this template (wizard) is awesome. it just doesn’t do what we’re talking about (replicate a list view) in this scenario.
  2. PowerApps are not yet embedded in the SharePoint interface – so the user experience is not as smooth as we’d like it to be.

I have to believe that both of these issues are on the roadmap for the PowerApps and SharePoint teams. We’ll just need to wait and see if and when they work their way up the list. Smile

Until these are addressed, you have a few things you can do manually with SharePoint and PowerApps. I’m walking through some of the options and steps with this blog series (References listed below – still have more posts to come…).

As with anything you’re working on in SharePoint or PowerApps, you need to pay attention to permissions levels. Extending SharePoint with PowerApps – while awesome – adds to the details you need to pay attention to. #governance. You might run into something like this:
image

You can also use the ever popular ‘security by obscurity’ approach and remove the PowerApps listing from SharePoint:
image
Although, you don’t actually have to do the ‘obscurity’ approach though since we have the capability of setting appropriate permissions at both the SharePoint and PowerApps levels.

You have options to switch the visibility, permissions, and integration experience in the SharePoint list menu:
image

These are a few of the configuration options. Check them out to see if the integration between SharePoint and PowerApps can meet your particular needs. If it doesn’t now, by bet would be that it will eventually… soon even.

References

MNSPUG July 2016 – PowerApps and Flow

Raymond and I did a presentation at the July 13th Minnesota SharePoint User Group a few weeks ago: Microsoft PowerApps and Flow: Overview and Integration Points with SharePoint. We had a nice crowd of 70-80 folks between the people in the room and folks that participated online.

Links to the presentation slides and recording (TBD) can be found on the MNSPUG site.

NOTE: In our slides we mention the connector for Office 365 Video. Right now there is an issue with that connector working with the current version of PowerApps. This is a known issue and Microsoft is working to resolve it.

Microsoft is generating a LOT of interest in these two new technologies – both still in Preview (now, and when the presentation was given). With the Ignite conference coming up this Fall, I’d be surprised if there isn’t more to see by conference time – between polishing the release version, adding new features, and potentially releasing one or both of the products. Stay tuned.

*Disclaimer* – This post based on Preview version of PowerApps. I’ll make every effort to update with any changes and verify when PowerApps is released.

Registration is open for the Spring 2013 SharePoint Saturday Twin Cities

SharePoint Saturday Twin Cites will have its Spring event on May 18th, 2013. We will again be at the Normandale Community College campus, but this time will be using the brand spanking new wing and rooms (still using the same entrance area on the West side).

Registration: http://spstcspring2013.eventbrite.com/

The last few events have filled up – so get signed up early. Also please be courteous to other hopeful attendees and cancel your registration if you are unable to join us.

We’ve got one of the largest SharePoint Saturday events in the country and with feedback from attendees, speakers and sponsors, one of the most successful as well. So join us for another day of SharePoint with tracks for SharePoint 101, Information Workers, Developers, IT Pros and a new vendor showcase room – all for free.

We have a new web site on the way as well. Keep an eye on http://www.spstc.com for information on sponsors, speakers, sessions and schedules coming soon. Also ‘Like’ our Facebook page for more immediate updates.  https://www.facebook.com/SPSTwinCities

We look forward to seeing you there!

SharePoint 2013 App Store

In my session at today’s Minnesota SharePoint User Group (MNSPUG) we had a question about the SharePoint App Store and if there was a feed available so that folks could keep up on what’s out there and when new apps are added.

The short answer appears to be No. At least for now.

For starters the SharePoint App Store can be accessed here to browse apps online:
http://office.microsoft.com/en-us/store/apps-for-sharepoint-FX102804987.aspx 

The closest we’ve got to a ‘feed’ is the New Apps for SharePoint section on this page. At the bottom of the page we’ve got categories to work with, but we’re likely better off going to search and using the search refiners, which should produce the same results. 

For search you can start here:
http://office.microsoft.com/en-us/store/results.aspx?qu=sharepoint&avg=osu150

Each of the apps has a Released date. Maybe Microsoft can add a sort based on that field to help us find new items.

We’ll see. There aren’t that many apps listed yet, but hopefully they’ll be added on a regular basis going forward as the 2013 platform adoption increases.

SharePoint Saturday – Twin Cities – Fall 2012

Yep, it’s that time of year again.  We’re ramping up for the Fall 2012 SharePoint Saturday Twin Cities event.  We’ll be meeting on November 3rd this year, still at the Normandale campus down in Bloomington.  

We’re not planning on covering a lot for 2013 in our sessions just yet – too many folks are still interested in and using 2010 and the final 2013 version hasn’t been released yet. So, we’ll be focused on 2010 for one more round at least and then see where things are in the Spring.  You’ll likely hear a LOT of news about 2013 the following week with the big Microsoft SharePoint Conference in Vegas happening and most of it centered on the 2013 platform. 

Speakers and sessions have all been posted – take a look when you have a chance.  We’ve got great folks coming from all over and bringing a ton of great sessions, content and experience. 

We are also continuing with our 101 Track – so if you have folks that are new to SharePoint, the event has content for them as well.  We’ve got 4 sessions specifically in the track – starting with my ‘What is this thing called SharePoint’ session – but there are other sessions throughout the day not in the 101 Track that folks new to the platform can certainly benefit from as well. 

Keep an eye out for registration to open next Monday – Sept 10. We will be limiting registration to 600 people again this time as it seems to be getting us to about the level we can manage at the current location.  The Spring event had over 460 attendees…  Smile  We’re one of the largest SPS events in the country. 

There are lots of great sponsors again as well, we hope to fill up our space with 30 vendors – they’ll be added to the site as soon as they are validated. 

Finally, when putting the event in your calendar, don’t forget to set aside Friday night as we’ll be having our SharePint (the night BEFORE the SPS event).  More info to come on that…

If you have any questions about the event, let me know!!  I look forward to seeing you there. 

Back with a Vengeance – MNSPUG Tomorrow

June?  Really?  It’s been that long since I’ve actually completed a post and uploaded it?  Sad.  Well, it’s been a crazy busy summer and now that that is wrapping up (the kids walked to the bus stop for the first day of school just 2 hours ago…) I can hopefully get back to it.  So much to do and so much coming.  I’ve got a few posts to hopefully get out in the next day or two – stuff that’s been sitting around 90% done. 

In the meantime, I’ll be participating on the Panel Discussion tomorrow for the Minnesota SharePoint User Group if you’re interested and in the area.  Come and join us!  I’ll have a few copies of the SharePoint 2010 Creating and Implementing Real-World Projects book as well. 

Check back soon – lots of fun news to get out here…   Smile