Unanswered

Increment a serial number in dataverse

(0) Share

Report

Posted on by Jakob_hjort

Hello Community

I'm a brand new user of powerapps and powerautomate. I'm trying to a make a system that track tools.
I've made 3 tables (Employees, Tools, and OverviewTools). The idea is to make a toolbox that consist of many different tools, depending on which appartment you will work in.

So when you press the button "Opret" (the trigger) collects the type of tool (EL) and a employee (Blacked out), you have selected and and the flow should then create a new row in the OverviewTools table. so far i got the increment variable intialized but the the dublicates and do not start from the last used number. can you help me?

My flow looks like this:

I've got another issue, that i will not post my the users, it gives this error: ')' or ',' expected at position 4 in '(xxx@xxxx.dk)'.

Hope you can help me out.

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

v-jefferni on at

Like (1)

Report
Hi @Jakob_hjort ,

You should use a Compose action under List rows, get the last record's serialnumber value and get the number via an expression:

string(add(int(substring(last(outputs('List_rows')?['body/value'])?['Serienummer'],2)),1)

The increment variable is not needed. And 'Add a new row' action should be out of Apply to each, input U and follow it use the Compose output to populate the Serienummer field.

Best regards,

Was this reply helpful? Yes No
Linn Zaw Win 2,996 on at

Like (0)

Report

@Jakob_hjort

For another issue, if the Employees parameter is optional and if it can be empty, you will have to set the lookup dynamically using an expression as in the blog post below.

https://linnzawwin.blogspot.com/2020/07/how-to-set-lookup-fields-with-null.html

Was this reply helpful? Yes No
Jakob_hjort 49 on at

Like (1)

Report
Thanks for the help and advices. I finnaly had time to get back to it. Though i could not make
string(add(int(substring(last(outputs('List_rows')?['body/value'])?['Serienummer'],2)),1)
to work for some reason, unknown, clearly my automate skills!! 😛 i did make a work around. In my dataverse table i made a column with autonumber wich did the job for me, aswell it didn't need to be sorted ascending anyway. About the name problem. Ive solved the problem by following Power automate Dataverse Lookup - How to write to the hard column - YouTube.

Was this reply helpful? Yes No