Employee Engagement Survey Mod

[iPhoneBeta]

I am not a programmer, so bare with me...

I have an app based on the Employee Engagement Survey that I have modified to fit my needs except for one step.

For each new 'survey' that is completed and posted to the data file, it is not appended, but over-writes the existing data. How do i modify the program to append to the next available row in exel to keep a running log?

[Rebetcha]

I looked in on that template. At first glance it looks like all the answers are stored as a variable until the NEXT button on the screen with the last question. You should have a good look at the formula on that button. Did you change anything in that formula? The formula uses the patch function that can both create and update a record. The problem you are facing most likely is solved in this formula. More on the patch-function in this article: https://docs.microsoft.com/en-us/powerapps/functions/function-patch.

[iPhoneBeta]

Thanks Rebetcha for the link. To answer you question- No, I didn't modify that formula. Just to be sure, I tested the original unaldulatered Engagement Survey, and it also does not append the new data. 

[v-micsh-msft · Accepted solution]

Hi @iPhoneBeta,

This Survery won't create a new record for the same user in the Excel file.

Actually, it will first check to see if there is a record for the user logged in, if yes, this App will update the existing record.

The structure of the Next button under the Question 5 screen is as below:

If(!IsBlank(LookUp(Responses,Username=User().FullName,Responses)),

UpdateIf(Responses,Username=User().FullName,{Record}),

UpdateContext({NewSurvey: Patch(Responses,Defaults(Responses), {Record})}))

So if here you would like to just creating new record for the same user, then you can remove the If condition check and only leave the UpdateContext() part.

For example:

UpdateContext({NewSurvey:
   Patch(Responses,
         Defaults(Responses), 
         {ResponseId:Text(CountRows(Responses)+1), 
          Answer1:Radio1.Selected.OptionText,
          Answer2:Replace(Concat(Listcollect,OptionText & ", "),Len(Concat(Listcollect,OptionText & ", "))-1,1," "),
          Answer3:Text(Slider1.Value), 
          Answer4:If(Radio1_1.Selected.OptionText="No","No," & TextInput1.Text,Radio1_1.Selected.OptionText),
          Answer5:TextInput1_1.Text,Username:User().FullName})});
Navigate(Finish_Screen,ScreenTransition.Fade)

Copy and paste the code above should be OK to have the App only creating new records, instead of Updating the existing record.

Regards,

Michael

[iPhoneBeta · Accepted solution]

V-Misch- 

          Thank you for breaking out the solution. I had to remove one extra close parenthesis, but all else worked great.

Final code:

UpdateContext({NewSurvey:Patch(Responses,Defaults(Responses), {ResponseId:Text(CountRows(Responses)+1), Answer1:Radio1.Selected.OptionText,Answer2:Replace(Concat(Listcollect,OptionText & ", "),Len(Concat(Listcollect,OptionText & ", "))-1,1," "),Answer3:Text(Slider1.Value), Answer4:If(Radio1_1.Selected.OptionText="No","No," & TextInput1.Text,Radio1_1.Selected.OptionText),Answer5:TextInput1_1.Text,Username:User().FullName})});Navigate(Finish_Screen,ScreenTransition.Fade)