Hi @Vishal2 ,
Do you set up a canvas app to achieve your needs?
How do you list these Checkboxes? One by One? or Using Gallery control?
Based on the needs that you mentioned, I agree with @KrishnaV 's thought almost. Just as you mentioned, you should set up a Flag column in your SP List to store the current Progress status --
0- form is new so new record
1- form has been started but not yet completed
2- form is finished and the record is complete and saved in list.
Note: I assume that the Flag column is Number type column in your SP List.
I have made a test on my side, please take a try with the following workaround:
Set the OnStart property of the App to following:
If(
!IsBlank(LookUp('Your SP List', 'Created By'.Email = User().Email && Flag = 1)),
EditForm(Form2);Navigate(Screen2, ScreenTransition.None, {ItemID: LookUp('Your SP List', 'Created By'.Email = User().Email && Flag = 1).ID})
)
Note: The Form2 represents the Edit form in your Screen2
Within your first Screen, set the OnSelect property of the "Next" button to following:
SubmitForm(Form1)
set the OnSuccess property of the Form1 to following:
Patch(
'Your SP List',
Form1.LastSubmit,
{
Flag: 1
}
)
Within your Screen2, set the Item property of Form2 to following:
If(
!IsBlank(ItemID), // ItemID variable is passed from the OnStart property of App
LookUp('Your SP List', ID = ItemID)
)
add a "Submit" button in Screen2, set the OnSelect property to following:
SubmitForm(Form2)
set the OnSuccess property of the Form2 to following:
Patch(
'Your SP List',
Form2.LastSubmit,
{
Flag: 2
}
)
Please consider take a try with above solution, check if the issue is solved.
Best regards,
