web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps How to set a default v...

Power Apps

Answered

How to set a default value of Edit New Form only

(0) Share

Report

Report

Posted on by MIA27

2

I am developing an app in Teams power app

I am trying to use the below code on the default value of edit form field by this code,

(First(Sort(TblSvcHistories, LineNo, SortOrder.Descending)).LineNo)+1

this I applied to bring the Last Value +1 for my counting's requirement

It works fine and bring the correct result, But keep value applied all the time. even in the other records. Till it is closed.

BUT I want to value to be brought only if the form is in NEW mode. I mean while entering the new record

tried by FormName.FormMode check, but not work.

Please guide a correct way to approach the same formula for the requirment

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (3)

Answers Img

Answers (1)

Sort by

Samuel-Zhou 393 on at

Like (0)

Report
Copy link

Link copied!
Hi @MIA27 Try this code in Default,
If(Form1.Mode=1,(First(Sort(TblSvcHistories, LineNo, SortOrder.Descending)).LineNo)+1)

Was this reply helpful? Yes No
MIA27 2 on at

Like (0)

Report
Copy link

Link copied!

The code has not error, but the result is not required.
For new it bring the calculation as required,
But when the edit form is reset, or on the previous any old record, then record field value is blank, which it should not be.
Requirement is if new then fetch the calculation, for rest no need, it to be remained as it,
pls. check my below images and advise

Was this reply helpful? Yes No
Verified answer

Samuel-Zhou 393 on at

Like (1)

Report
Copy link

Link copied!
@MIA27 Try this,
If(Form1.Mode=1,(First(Sort(TblSvcHistories, LineNo, SortOrder.Descending)).LineNo)+1,Parent.Default)

Was this reply helpful? Yes No

Join the conversation