Increment Number based on Day

(0) Share

Report

Posted on by PowerDigitize_1

How can I reset the incremental number to 1 when the day changes to next day.

1 = incremental number (batch number of the day)

when the day changes to say tomorrow, increment number should again start from 1. During the day it should increment +1.

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

WarrenBelz 154,399 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
Hi @PowerDigitize_1 ,

One way would be a reference list (one record only) with a date and a number. Test for the date

With( {wRef:First(ReferenceList)}, If( wRef.DateField = Today(), Set( YourNumber, wRef.NumberField ); Patch( ReferenceList, {ID: wRef.ID}, (NumberField: wRef.NumberField + 1} ), Set( YourNumber, 1 ); Patch( ReferenceList, {ID: wRef.ID}, (NumberField: 1} ) ) ) )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Visit my blog Practical Power Apps

Was this reply helpful? Yes No
Hmaldonado 21 on at

Like (0)

Report
Copy link

Link copied!
I tried this approach but when the day changes, does not update the date in the ReferenceList?

With ( {wRef:LookUp(ReferenceList,Title=ComboBoxWithTitles.Selected.Value)}, If (wRef.DateField=Today(), Set(VarSequence,wRef.NumberField);Patch(ReferenceList,{ID:wRef.ID},{NumberField:wRef.NumberField+1}), Set(VarSequence,1);Set(VarReference,wRef.Title); ) );
How i can overcome that?

Was this reply helpful? Yes No
Hmaldonado 21 on at

Like (0)

Report
Copy link

Link copied!
I found the answer, the problem is that I need to update the date and the numberfield to 2 since 1 is used in the code.

ith ( {wRef:LookUp(ReferenceList,Title=Dropdown.Selected.Value)}, If (wRef.DateField=Today(), Set(VarSequence,wRef.NumberField);Patch(ReferenceList,{ID:wRef.ID},{NumberField:wRef.NumberField+1}), Set(VarSequence,1);Set(VarReference,wRef.Title);Patch(ReferenceList,{ID: wRef.ID}, ({NumberField: 2}),({DateField: Today()})) ) );

Was this reply helpful? Yes No