Answered

Formula not working on EditForm1

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

I have a 3 screen out of the box form that I am having just one issue with.

On EditForm1 I have the below formula. It is set so that if the form is new, it finds the last ID, then grabs the column FormIDNumber and adds 1 (this part works fine) but if I am just editing the current record, it will not pull it's Parent.Default. On EditForm1, I have the DefaultMode set to FormMode.Edit.

Formula

Concatenate("IRF-",Text(If(EditForm1.Mode=FormMode.New,First(Sort('IRF Center (New)',ID,Descending)).FormIDNumber + 1,Parent.Default)))

This is day 3 for me. 🙂 What am I missing?

Categories:

Building Power Apps

All responses (5)

Answers (2)

Sort by

Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

I actually wanted to add that it is seeing the correct FormIDNumber in the attached.
Verified answer

Pstork1 69,665 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
I've never been able to get IF() functions embedded inside other functions to work. I know its more cumbersome, but I think you need to format it this way.

If(EditForm1.Mode=FormMode.New,Concatenate("IRF-",Text(First(Sort('IRF Center (New)',ID,Descending)).FormIDNumber + 1)),Concatenate("IRF-",Parent.Default))
Verified answer

eka24 20,925 on at

Like
a
(1)

Report
Copy link

Link copied!

It's means resolved. Then you can mark it as The solution to close it.
------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

@Pstork1 !! That worked! Thank you so much. I got a double IRF-IRF-123 so i removed the last "Concatenate("IRF-" and left the ",Parent.Default) and it works perfectly. Thank you so much!
Pstork1 69,665 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

That would make sense if the IRF- prefix is part of the default. It wasn't completely clear from the original formula, but I figured the embedded IF() was the real problem. Glad its working.