I think I have asked this before but with no Solution till now.
I have 6 forms and I need to change the status based on the submitted form.
The forms are ( initial request, fund certified, Pending correction, waiting order entry, waiting number entry,waiting order receipt)
I also have a screen gallery called home.
the status choice column has choices ( new, pending review, fund certified, pending correction, waiting on number entry, waiting order receipt, complete, and cancel.
I need to change each form based on the status column to view the status in SPO list.
I used the below Patch . it did work but it didn't change the Status.
Patch( 'LCSS Purchase Request', LookUp('LCSS Purchase Request', ID=1), { Status: DataCardValue3.Selected } );SubmitForm('Initial Request')
Also every time I move from screen to another I need all the modification been updated on the same record.
