You’re offline. This is a read only version of the page.
Announcements
Hello Powerapps community-
I am new to powerapps so i am hoping someone can help me to hopfully an easy question(s).
I created an app , thats purpose is to collect employee feedback. Employees go into the app and answer the questions we are looking for feedback on. When they submit, the app is suppose it collects all the text feedback and puts it into an excel file (stores on Onedrive for Business). When i do it, it works. i share the app with my peers they can access it. They cannot submit their feedback, i did share the excel file with them.
1) Do they need access to the excel file to be able to submit?
2) Is there a better solutions, so i do not need to give employees access to the excel file to submit?
Any suggestions help - below is a copy of the collect coding for when an employee submits the the feedback .
If(!IsBlank(LookUp(Responses,Username=User().FullName,Responses)),UpdateIf(Responses,Username=User().FullName,{ResponseId:ResponseId, Answer1:Radio1.Selected.OptionText,Answer2:Replace(Concat(Listcollect,OptionText & ", "),Len(Concat(Listcollect,OptionText & ", "))-1,1," "),Answer3:TextInput2.Text, Answer4:TextInput3.Text,Answer5:TextInput1_1.Text,Username:User().FullName}),
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:TextInput2.Text, Answer4:TextInput3.Text,Answer5:TextInput1_1.Text,Username:User().FullName})}));Navigate(Finish_Screen,ScreenTransition.Fade)
Hi
When you "shared" the apps, you need to allow them to "shared the same excel".
Please read this article.
https://powerapps.microsoft.com/en-us/tutorials/share-app-data/
TQ
Share
Report
All responses (
Answers (
2,944
