You’re offline. This is a read only version of the page.
2
I have built a flow, that when a student signs into a class using a form that data is sent to Google Sheets and then my flow creates a document in word using a template that creates a certificate of attendance for that student. However, I need each certificate numbered uniquely and individually and sequentially. The spreadsheet logs each entry numerically and sequentially with an "ID" number, and I could easily use this ID number for the certificate number. However, because I just started using this system, the entry numbers are too low. I need to add 12950 to each entry number. I have tried using the add function without success. Any advice would be much appreciated.
Double check that you are adding that step from within the "apply to each" loop.
I apologize I am fairly new at this. When I try that I get "the expression is invalid"
When I try expression>add>then click over to dynamic, all the dynamic entries are gone and all I can see is "records" and "records value"
Hi there. When you say you've tried using add without success, are you getting an error or unexpected results? It may not be interpreting the ID field as a number, so an expression that converts that field to an integer (number) before doing the math might work. Something like this:
add(12950, int(<Dynamic field for ID>))
Give that a go and let us know how that works.
-Ed
If you liked this reply, please give it a thumbs up! If this reply has answered your question or resolved your challenge, please consider marking it as a Solution. This helps other users find it more easily via search.
#1
Michael E. Gernaey
497
Super User 2025 Season 1
#2
David_MA
436
Super User 2025 Season 1
#3
Riyaz_riz11
244
Super User 2025 Season 1
Share
Report
All responses (
Answers (
