cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
freshyshreya
Post Patron
Post Patron

Formula not working everytime

Hi,

In the pic below,I am using the following formula to increment the previous value by 1 whenever a new form is submitted.

Last(DTA_Portal).'Opportunity ID2' + 1

 

But,sometimes the formula fails to work and whenever a new form is submitted the incremented number doesn't reflect in the SharePoint list as shown in the pic below.

freshyshreya_0-1632576338709.png

Is there any other formula or any other solution for this?

Please help!

 

1 ACCEPTED SOLUTION

Accepted Solutions
eka24
Super User
Super User

Try this:

If(Form4_1.Mode=FormMode.New,
First(Sort(DTA_Portal,ID)).'Opportunity ID2'+1,Parent.Default)

------------

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.

View solution in original post

1 REPLY 1
eka24
Super User
Super User

Try this:

If(Form4_1.Mode=FormMode.New,
First(Sort(DTA_Portal,ID)).'Opportunity ID2'+1,Parent.Default)

------------

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.

Helpful resources

Announcements
Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (4,712)