Microsoft 365 Community SharePoint, 7 Mar 2023

Previous Meeting Next Meeting

⏯

youtube image

►

From YouTube: Developing a personal wellness app to prevent burnout using Power Apps and SharePoint

Description

In this 9-minute citizen developer-focused demo, Carlos Solís delivers a Power Apps app that addresses job burnout using 2 approaches - actions that lead to positive developments and refocusing after reflecting. Uses SharePoint Lists, Power Apps and Power Automate (for reminders). Randomly delivered cards explore the user’s wellbeing and prompts for actions/reflections. SharePoint stores tips, prompts and reflections. Step through the logic for presenting information based on person’s energy level – pre and post reflection.

This PnP Community demo is taken from the Microsoft Power Platform community call – February 2023, recorded on February 15, 2023.

Demo Presenter
• Carlos Solís (Texas State University) | @CarlosBKSolis1

Community Call Conversation
• https://aka.ms/Feb15-Demo1

Supporting materials
• Website - Technology Innovation Office – Texas State University | https://www.tio.txst.edu/

Stay connected
• Twitter https://twitter.com/microsoft365dev
• Call attention to your great work by using #PowerAppsCC and #PnPWeekly on Twitter.

Learn more
• Microsoft 365 Unified Sample gallery - https://aka.ms/community/samples
• Microsoft 365 Platform Community in YouTube - https://aka.ms/community/videos
• Microsoft 365 Platform Community - http://aka.ms/community/home
• Microsoft 365 Platform Community Blog - https://aka.ms/community/blog

A

A

Technology Innovation at Texas, State, University and my pronouns: are he him or L for those of you that speak Spanish, um let's quickly get into it? So, yes, like David, said the main issue that I was trying to work with. Here is burnout, which is a common problem in a variety of jobs and developing a couple of Alternatives, simple power apps.

A

That would help users with this problem, so the whole solution that was proposed was to help people identify and highlight positive moments that we mostly experience in our lives so that we can learn the value and the benefits of dedicating time for reflection.

A

So, let's take a look at a couple of the solutions that we came up with. One of them was to let users think that actions can actually lead to positive developments in our lives and the other one is how can refocusing after reflecting really change our mindset about what our lives are about, what our lives are like and what we can do with our with our own powers. So we all know that uh you know better. Together is the name of the game, so this actually relies primarily on SharePoint lists and power.

A

Apps, there's a power automate that uh can go with it, instead of showing the apps I'm actually going to show screenshots in some of the ways in which I wire the components, because it's not that scary I am one of those early developers that have been teaching myself thanks to the community, uh so I've always been a little bit on the slow side of things. But uh you know this is this is really easy. So here's a look at the first app.

A

Basically, that app shows a wellness prompt at the beginning, and then it shows a series of cards that allow the user to see where they were on any given day with their energy points and what actions they took. The whole idea behind this app is to either look at your feelings and well to look at your energy or feelings on the scale from one to five and if you're feeling your energy being between three and one.

A

That means you're, probably not in the best place, and so there is a prompt for you to take some action and underneath, as a box, to enter a reflection of this action you you might take to feel better.

A

On the other hand, if you feel energetic and feel like you're in a good point, it's a good time to reflect on the kinds of things that you did to take you to that space, and we provide some actions uh on the list that lets. You recap what you might have done to make to get you there.

A

This other app actually looks at what happens before and after you reflect how you're feeling. Similarly, here we have a gallery that shows you for any given day where you were prior to reflection and where you were post reflection, and it gives you a little built-in chart that highlights the movement for every day that you engage with the app so it starts. We didn't want people to get to see the whole screen.

A

It starts just with you evaluating your energy, and once you do your energy evaluation, you get a daily prompt uh for reflection and we make it relatively short, no bigger than a tweet, so 248 characters, and once you start typing, like my favorite reflection, is the zombie ipsum Lauren ipsum to go with, and you reach a certain number of characters. You get prompted to re-evaluate your energy and then submit your reflection.

A

So what are these SharePoint lists that are part of the system? I created three SharePoint lists the well. First, one is the wellness tips, which is a read-only list that I make available to all of our users. The second one is a Reflections prompt. That is also a read-only list that is available to all users and then.

A

Thirdly, there is your personal reflection list that varies by project, but sometimes can include images right into the list, and so the fact that SharePoint has been made uh capable of both reading and writing images through powerapps has been an awesome uh development.

A

These are some of the functions that I, throw and and properties that I threw into the mix uh the visible property. Also, the variable property, so usually, visibility is set to false until something happens, the Len function, which counts the characters inside so boxes. The first function, which uh pulls the first item off a table. The shuffle function that shuffles content of a table if statements items and on change.

A

So this is the way the random Wellness tip gets delivered to the users. There's a list of random Wellness tips and the label at the top of the screen is basically of the result of shuffling that Wellness list and then putting the first one of that shuffled deck at the top of that screen.

A

um Then how do we provide the random prompt for the reflection?

A

We start out with everything else blank in the screen, and then we use or I use the unchanged property for the energy slider, and once that slider changes, then it will go and feed not only the daily prompt, but it will then make the reflection uh window or the fresh reflection input box appear and then, finally, after you type a certain number of characters, then we make the energy after visible and then also the submit icon, visible.

A

Similarly, uh instead of letting the user create their own prompt, we provide the prompt essentially again with the first Shuffle of the reflection prompts, and we make that only a view item that gets saved along with the data when the user submits his or her or their reflections for the drop down items and the one that we either prompt you to do a reflection or reflect on the things you have done.

A

If your energy levels are below three, the the drop down items come from one list, but if your energy level is above four, then your drop down items get changed to another list that helps you recap the actions you might have taken. uh That would lead you to that. And finally, um you know if there is there is this chart component?

A

That's a simple chart component, one of the uh components that comes with standard powerapps, and we just point that to uh the date and then to your uh to your energy levels, pre and post reflection. In this particular case.

A

um This is an optional component that I have built to it that basically uses power automate to look at the list of entries in the morning and if there hasn't been an entry that is any different. That is. If you haven't made an entry in the last three days, then it will send you a gentle reminder, a friendly reminder, either via mobile or yeah your email, whatever the user chooses to do next.

A

So this is the way you can get in touch with me, I'm, happy and and privileged to uh to be able to share this with you, and you know, I'm open to questions.

B

Awesome thanks Carlos, we will have the questions go into the chat just for purposes of keeping the demos moving along, uh but this is really fantastic. I love what you've done here with the technology. It's really a perfect example of doing good with tech. uh We do live in a world- that's been topsy-turvy, the last couple of years and here you're using the technology to provide awesome opportunity to have Wellness spread about in our community in our world. So thank you for bringing this to us today and demoing it.

B

We will have a dedicated space for folks to communicate with you after the call we'll talk about that at the end, but thank you so so much really great stuff, great job on the presentation as well.