PowerApps issue with Form Mode

[Faro]

Hello all,

I have a problem when running Customized form with PowerApps.

My form will automatically count up and assign a Tracking number when we create new item (FormMode = New) and will keep that number when the item is modified (FormMode = Edit).

The logic was basically like this:

If(FormMode = New, Count up and assign new number, Parent.Default)

It works perfectly except for 1 scenario when I access to the the list page and immediate click to open an item.

In that case, it suppose to be in View or Edit mode. But instead of keeping the Parent.Default number, it count up and assign a new Tracking number, it seems to recognize the stage of Form Mode is New in that very moment.

After that I tried to click another items and it works as normal.

I finally found that if I load the list page and wait for about 2 seconds before open any item, this issue won't be exist. I've informed my team to wait around 5 seconds to ensure there is no issue with the information.

Is it the issue of SharePoint or PowerApps?

Any recommend to resolve this issue? Really appreciate your help !

My code in the tracking number field:

If(SharePointForm1.Mode = FormMode.New,
    "EI"&Right(Text(Year(Today())),2)&"-"&
    If((Value(Last(Split(First(Sort(Export_Inquiry.Title,Title,Descending)).Title,"-")).Result) + 1) < 10,
        "000"&(Value(Last(Split(First(Sort(Export_Inquiry.Title,Title,Descending)).Title,"-")).Result) + 1),
        If((Value(Last(Split(First(Sort(Export_Inquiry.Title,Title,Descending)).Title,"-")).Result) + 1) < 100,
            "00"&(Value(Last(Split(First(Sort(Export_Inquiry.Title,Title,Descending)).Title,"-")).Result) + 1),
            If((Value(Last(Split(First(Sort(Export_Inquiry.Title,Title,Descending)).Title,"-")).Result) + 1)<1000,
                "0"&(Value(Last(Split(First(Sort(Export_Inquiry.Title,Title,Descending)).Title,"-")).Result) + 1),
                (Value(Last(Split(First(Sort(Export_Inquiry.Title,Title,Descending)).Title,"-")).Result) + 1)))),
    Parent.Default)

[Faro]

Up.

(just got unmarked from spamming .....)

[Faro]

Please help ...