Hi all,
I am making an app which exists off multiple screens with on each screen a form. All the forms are linked to an excel sheet "MasterData" on my onedrive. If I use a submit button and the function "SubmitForm(BasicInfo)" it creates a new row with this data filled in but all other data (from the other screens and forms) is left blanc. When I submit other forms it creates a new row for every form I submit. This is not what I want. I have the same behavior when I create a collection via this method.
I tried this:
Collect(NewIssueReported;BasicInfoForm.Updates;PlateInfoForm.Updates;ProblemLocationForm.Updates;ExposedForm.Updates;ProcessedForm.Updates;PrintedForm.Updates;EscalationForm.Updates)
or
SubmitForm(BasicInfoForm) && SubmitForm(PlateInfoForm) && SubmitForm(ProblemLocationForm)&& SubmitForm(ExposedForm)&& SubmitForm(ProcessedForm)&& SubmitForm(PrintedForm)&& SubmitForm(EscalationForm)
I want to collect all the form's data and than patch or submit the entire collection to my excel sheet so that all the form's data is just one single row in my MasterData file.
Anyone have any experience here?
I followed the video from Reza ((1) Multiple Screen Form Control in Power Apps - YouTube) but with an excel sheet instead of sharepoint.
