cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Garak0410
Helper I
Helper I

Conditional Increments

I created a simple PowerApps applications (with some tips from the awesome people in this forum) and management loves it.


They have asked for an enhancement that I am seeking some help with. 

 

Here's what the table looks like:

 

powerAppsTable_01.jpg

 

This is the data entry screen: 

 

powerAppsTable_02.jpg

 

What we would like to do is for the revision number default as 1 unless the JOB Number and Department equal to a past entry and then if so, increment the revision number by one.

 

Any suggestions on how to code this?

Thanks...

12 REPLIES 12

@Garak0410 

Does your list have an ID that doesn't change even if the Job# is modified?  Please see my blog post for why this is important. https://powerusers.microsoft.com/t5/News-Announcements/Relational-Database-Principles-and-PowerApps-... 


@Drrickryp wrote:

@Garak0410 

Does your list have an ID that doesn't change even if the Job# is modified?  Please see my blog post for why this is important. https://powerusers.microsoft.com/t5/News-Announcements/Relational-Database-Principles-and-PowerApps-... 


No...it is a pretty basic table:

power_apps_revision_08.jpg

 

And I will check out your article...

I know many have suggested moving this data to a SharePoint list but even do this say, SharePoint gives me a headache...I've never been able to successfully use it for anything. 

@Garak0410 

SharePoint has its disadvantages but it is still better than building an app around Excel OnLine.  Particularly if your app is going to expand the number of items or if it is going to be used by more than one person at a time.   http://powerappsguide.com/blog/post/how-well-does-powerapps-cope-with-large-excel-files 

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

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