Creating an app that shows daily employee satisfaction with a survey

[Anonymous]

Hello everyone,

So I would like to create an app where employees can vote daily on how they feel (options between very good to very bad). 

On this app there should be something like an emoji too that changes it's moods regarding to what employees feel at the moment.

Can I implement something like this?

Thank you very much.

[v-albai-msft]

Hi @Anonymous,

Do you want to use a emoji to record the mode within your app?

I did a test for you, check if this can achieve your purpose.

1. I have a list with a Text column called “mode”. My app is generated by this list.

2. Go to the app, Within the Edit screen, set the OnVisible property of the screen to following:

UpdateContext({Emoji: Blank()})

3. Unlock the mode DataCard, remove the Original TextInput box from the Data card, then add below three Emoji icons: Sad, Neutral and Smile.

Set the OnSelect property of the Sad icon to following:

UpdateContext({Emoji: "Sad"})

Set the Color property of the Sad icon to following:

If(Emoji= "Sad",RGBA( 255, 0, 0, 1 ), RGBA(0, 18, 107, 1))

Set the OnSelect property of the Neutral icon to following:

UpdateContext({Emoji: "Neutral"})

Set the Color property of the Neutral icon to following:

If(Emoji= "Neutral",RGBA( 255, 165, 0, 1 ),RGBA(0, 18, 107, 1))

Set the OnSelect property of the Smile icon to following:

UpdateContext({Emoji: "Smile"})

Set the Color property of the Smile icon to following:

If(Emoji= "Smile",RGBA( 154, 205, 50, 1 ),RGBA(0, 18, 107, 1))

4. Set the Update property of the mode DataCard to following:

Emoji

This time, when user do the survey, they can choose a emoji for their mode, and the mode result will be kept as a Text in your DatadSource/Gallery.

Besides, you can also edit the mode DataCard in your DetailedScreen, remove the Original TextInput box from the Data card, and add above three emoji icons, set their Visible property to below formula(each formula for each icon):

If(ThisItem.raiting="Sad",true)

If(ThisItem.raiting="Neutral",true)

If(ThisItem.raiting="Smile",true)

Result like below:

Best regards,

Allen

[Anonymous]

First of all, thank you very much that you explained everything so detailed that I was able to understand it.

I should have said this maybe in advance but I want to integrate this App into a Teams Channel. So only the users in the Teams Channel should be able to vote on their mood. Is there any other way than creating a list on SharePoint in this case for each user? Sounds a bit like an effort as we have so many people in this Teams Channel. Second of all I wanted to display at the end ONE emoji that should show the general mood of all employees. So if 10 people voted they are veray happy and 10 people voted they are very sad the emoji should have a neutral face. The voting should be done anonymously. So I dont want to see which user selected which emoji (data privacy), I am interested in the overall mood of my employees.

Thank you very much in advance for your help! 

[v-albai-msft]

Hi @Anonymous ，

The only thing I can think of is to create a collection to store the results of the votes. Only patch vote results into this collection. 

Then, count this collection with different text(happy, sad), and show different results based on the count number.

What's more, I think you just want to focus on the overall mood of all your employees over a period of time, so you should clear this collection every 24 hours. You can use a Timer control to help you clear collection on time. For example, set the Duration property of the Timer control to(24 hours):

86400000

Set the AutoStart and Repeat property of the Timer control to following:

true

Set the OnTimerEnd property of Timer control to following:

Clear(Collectiontest)

Best regards,

Allen

[Anonymous]

Hello Allen,

That sounds great. But how do I do it now? Would you PLEASEEEE so kind to give me a step-to-step solution like above? That would be incredible.

Thank you very much in advance.

Best Regards

Emre

[v-albai-msft]

Hi @Anonymous ,

I have a new solution that may be better for you. Using a SharePoint list---with only one list item, each time user submit their mode, edit this existing item.  

Here is the detailed steps:

1. Create a new list, add a Text column called “mode”, and three Number columns called “Sad”, “Neutral” and “Smile”. Create a new list item as below(then all submit action will edit this unique item):

2. Add a edit form, with only mode DataCard, add three emoji using steps mentioned in my first reply(Screen: OnVisible= UpdateContext({Emoji: Blank()})).

3. Add a button, set it to below:

If(Emoji="Sad",Patch(list9,First(list9),{mode:Emoji,Sad:First(list9).Sad+1}),
Emoji= "Neutral",Patch(list9,First(list9),{mode:Emoji,Neutral:First(list9).Neutral+1}),
Emoji= "Smile",Patch(list9,First(list9),{mode:Emoji,Smile:First(list9).Smile+1})
)

4. Add a Label outside the form, set its Text to:

If(First(list9).Sad>First(list9).Smile,"Sad",
First(list9).Sad=First(list9).Smile,"Neutral",
First(list9).Sad<First(list9).Smile,"Smile")

Note:

If you want to focus on the overall mood of all your employees over a period of time, for example 24 hours, you should reset the value of three Number columns to “0”(item created in step1), no matter manually editing the list item or update this list item using a Timer control.

Best regards,

Allen

[Anonymous]

Hi Allen,

thank you very much. A few questions on your solution, which I was not able to reproduce:

Is the Button added 3 added inside the data card or in the screen? Is the formula to the button added to "OnSelect" ? I added the three emojis but when i run the app they disappear. I see exactly the same window as you but without the emojis.

Best Regards 

[v-albai-msft]

Hi @Anonymous ,

1. You should add these three button inside the datacard. Remember to change the Update property of mode_DataCard.

2. You should put the formula into OnSelect property and Color property(of course you can only set OnSelect property, and do not set Color property).

Besides, remember to do below action:

Best regards,

Allen

[Anonymous]

Hello Allen,

I did all of that but it still does not work somehow. Please view attachment

[v-albai-msft · Accepted solution]

Hi @Anonymous ,

Seems you are missing below step:

Best regards,

Allen