Trying to replicate an invoice number generation formula :/

(0) Share

Report

Posted on by rockhoundXX

Hi Community,

still fairly new and yet trying to implement a time tracking and invoicing tool with PowerApps.

This youtube video is the reference from Minute 19:00 onwards.

PowerApps- Generate Billing Invoices/Auto Generate Invoice Numbers - YouTube

The first question for me is why do I need semicolons to get my functions to work and in the video it is only commas for the function attributes? I guess I am missing something here?

This is the formula from the video:

StundenzettelNR is my field value withe generated invoice Number in this case.

When I try to use commas for the function attributes it does not work but semicolons work but throw other errors:

Can somebody help me or guide me here?

I know the formula error help but I tried to change a number of things and it does not work.

Thank you all in advance 🙂

Categories:

Building Power Apps

I have the same question (0)

All responses (7)

Answers (0)

Sort by

eka24 20,925 on at

Like (0)

Report
Copy link

Link copied!

Change the comma in the last portion of the formula to:

Text(Right(StundenzettelNR ; 4)+1))})

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

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.

Consider Checking My Youtube Channel

Was this reply helpful? Yes No
timl 36,785 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@rockhoundXX

It looks like you're using German. The German syntax uses semi-colons as the argument separator symbol in formula, rather than commas.

This is because unlike English, the German number format uses a comma as the decimal point separator symbol for numbers. If you were to separate function arguments with a comma, there would be no way for you to pass a decimal number.

In your example, the reason for the error is because this comma should be a semi-colon.

Was this reply helpful? Yes No
rockhoundXX 55 on at

Like (0)

Report
Copy link

Link copied!
Thank you for your responses, thats great to understand that german formatting is different.

Still after semicolons I get an error here:

The variable StundenzettelNR is a variable that needs to be displayed in a form field. Therefore I put in a form field.
It seems that this variable needs to be defined before hand and this the reason for the formula error?

Set(StundenzettelNR; First(Filter('Zeiterfassung-Stundenzettel-NR';ID=1).Title); UpdateIf('Zeiterfassung-Stundenzettel-NR';ID=1;{Title:Concatenate("DINGER-2021-";Text(Right(StundenzettelNR;4)+1))})

Any help is appreciated 🙂 Thank you 🙂

Was this reply helpful? Yes No
rockhoundXX 55 on at

Like (0)

Report
Copy link

Link copied!

Any other idea left? 🙂
I dont know what's the problem with my variable here?

Was this reply helpful? Yes No
R3dKap 1,594 on at

Like (1)

Report
Copy link

Link copied!
If your StundenzettelNR field is a number, you need to convert it to a string before using the Left() function.

Try this:

Set(StundenzettelNR; First(Filter('Zeiterfassung-Stundenzettel-NR';ID=1).Title); UpdateIf('Zeiterfassung-Stundenzettel-NR';ID=1;{Title:Concatenate("DINGER-2021-";Right(Text(StundenzettelNR);4)+1)})

Was this reply helpful? Yes No
rockhoundXX 55 on at

Like (0)

Report
Copy link

Link copied!
So thanks for the help so far, it turns out that between the two actions in the formula only one semicolon is not sufficient, but rather two so ;; did the trick here (German powerapps localization).

However the desired button with the formula does not change the last four digits and increments it as desired.
When I do paste out the Right function below into a seperate label for testing, it does increment it, but from 1 to 2 and not from 0001 to 0002 as below:

(Right(StundenzettelNR;4)+1

So in result, the button does unfortunetely nothing as the number stays on 0000
Could it be a formatting issue here for the desired text?
Current code looks like this:

Set(StundenzettelNR; First(Filter('Zeiterfassung-Stundenzettel-NR';ID=3)).Title);; UpdateIf('Zeiterfassung-Stundenzettel';ID=3;{Title:Concatenate("Std.Zettel-Nr-";Text(Right(StundenzettelNR;4)+1))})

Was this reply helpful? Yes No
R3dKap 1,594 on at

Like (0)

Report
Copy link

Link copied!
You're right... Here is the fixed code (I haven't tested it on my side though):

Set(StundenzettelNR; First(Filter('Zeiterfassung-Stundenzettel-NR';ID=1).Title);; UpdateIf('Zeiterfassung-Stundenzettel-NR';ID=1;{Title:Concatenate("DINGER-2021-";Text(Right(StundenzettelNR;4)+1;"0000")})

Just needed to format the result number into a 4 digit number... 😉

Was this reply helpful? Yes No