Hello, I am in the process of designing an audit app for my employer, I'm new to power apps and have been completing Microsoft and Udacity training programmes to teach myself how to create the app. I am also following a video on YouTube too see how another person designed their audit app and implementing some of his techniques within my app. I have made multiple tables on excel for the use of cascading drobox's, retrieving data (audit info, questions etc.) and tables for the answers to be stored in once an audit is complete. I have got to the part where I am entering a submit button and having some errors within my coding for the 'onSelect'. I believe its to do with the app being able to retrieve the selected value from the drop box and store it in the collection/tables. I will include a copy and paste of my code along with a screenshot. Any help, would be appreciated. Thanks
Set(IDAuditVar,Patch(AuditInfo,Defaults(AuditInfo),
{
Author:AuthorName.Text,
Company:Text(CompanyDropbox.Selected.Value),
Audit:Text(AuditNameDropbox.Selected.Value),
Location:Text(LocationDropbox.Selected.Value),
Created:NowVar
}).ID);
ForAll('ManagerH&SauditGallery'.AllItems,
UpdateIf(ManagerHScol,ID=Value(IDGal.Text),
{
AuditID:IDAuditVar,
Answer:AnswerOptions.Selected.Value,
Comment:CommentBox.Text,
NumberOfImages:0
}));
Collect(ManagerHSauditQuestion,ManagerHScol)
;
ForAll(PictureCol,
Patch(ManagerHSauditQuestion,Defaults(ManagerHSauditQuestion),
{
AuditAnswerId.Question,
Picture:Iamge,
AuditId:IDAuditVar
}));
ClearCollect(ManagerHScol,ManagerHSauditQuestion);
Clear(PictureCol);Reset(LocationDropbox);Reset(CompanyDropbox);Reset(AuditNameDropbox)
