Showing results for 
Search instead for 
Did you mean: 
Advocate I
Advocate I

PowerApps issue with Form Mode

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,
    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)))),






Advocate I
Advocate I


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

Advocate I
Advocate I

Please help ...

Helpful resources

2022 Release Wave 1 760x460.png

2022 Release Wave 1 Plan

Power Platform release plan for the 2022 release wave 1 describes all new features releasing from April 2022 through September 2022.

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Top Solution Authors
Top Kudoed Authors
Users online (1,762)