Navigate to success screen after submitting the last item in gallery

[PowerAppNoob]

I have a gallery which i use to populate data in a form. This is what I want to achieve:

1. I select  Item 1 in the gallery.

2. The upper part of form gets populated with data coming from Sharepoint List.

3. User edits the lower part of the form.

4. Once done, user clicks the submit button.

5. Item 1 in the gallery disappears and gallery shows the 'unprocessed items' until all items have been processed and submitted.

6. On the submission of the last item in the gallery, the screen navigates to a SuccessScreen.

Steps 1 to 5 are already done. How can I achieve Step 6? Any help would be appreciated.

[Drrickryp]

@PowerAppNoob 

Put your Navigate(success_screen) function in the OnSuccess property of the form being submitted.

You could skip the navigation and just put Notify("your message here", Success) in the OnSuccess property.

[PowerAppNoob]

It seems that the formula works everytime click on submit. What i would like to achieve is for the screen to navigate to success screen only after I submit the last item in the gallery. So in my app's case,

Select Item 1>Populate Form>Click Submit >Item 1 disappears

Select Item 2>Populate Form>Click Submit >Item 2 disappears

Select Item 3>Populate Form>Click Submit >Item 3 disappears

Select Item 4>Populate Form>Click Submit >Item 4 disappears

Select Item 5>Populate Form>Click Submit > Navigate to SuccessScreen

Thank you in advance!

[Drrickryp]

@PowerAppNoob

In the OnVisible property of the screen 

Set(no,CountRows(Gallery.AllItems);
Set(Counter,0)

In the OnSuccess property of the form,

Set(counter:counter+1);
If(no=counter,Navigate(scrSuccess))

[RandyHayes]

@PowerAppNoob 

Or skip the variables with this in the OnSuccess:

If(CountRows(Gallery.AllItems)=0, Navigate(scrSuccess))

[PowerAppNoob]

I tried this but it didn't work. There is a Red X error both on the Screen and the form.

[PowerAppNoob]

Should this be on the Screen or the Form?

[Drrickryp]

In the On Success property of the form. Replace the name of your gallery and your screen in the formula.

[PowerAppNoob]

It didn't work. Could it be because i have a filter in the gallery? That means, if i filter an item in the gallery (let's say there are 5 results of the filter), the formula won't work since i have not processed those which are not included in the filter result?

[RandyHayes]

@PowerAppNoob 

The Gallery will have no impact on your formula at all. 

You should have (on the OnSuccess action of your Form) the following formula:

If(CountRows(Gallery.AllItems)=0, Navigate(scrSuccess))

Replace "Gallery" with your Gallery name and scrSuccess with the name of the screen you wish to navigate to.

If you are receiving an error, please post back with the error information and a screenshot of the error in context to the formula.