Service | Customer Service, Contact Center, Fie...

Different Sequence of Auto-Numbering within One Entity

(0) Share

Report

Posted on by Manny Floyd

Hello All,

I have multiple country names in one entity. I want records of each country to start with it's own auto-number sequencing.

I used XRM tool but but it gives me auto numbering for all records.

For example, country UK records should start with 1001, 1002, 1003,....

county Japan records should start with 1001, 1002, 1003,...

You get the point. Also, I am not using canvas power apps, I do not have auto number data type

I have the same question (0)

All responses (20)

Answers (0)

Suggested answer

LeoAlt 16,331 Moderator on at

Like (1)

Report

Hi Partner,

Unfortunately there is no OOB way to do this.

You could use Power Automate instead, here are the steps.

1.Create a new Flow and set its trigger condition to when creating a new record.

2.Create a list records action to list all the entity records whose country equals the current new created one.

3.Create a condition to check if the list records result is 0. If is 0, it means there is no other records with the same country you are creating, then add another condition to check the current country to set different number based on different countries. In my case, I set China to 1001 and Japan to 2001.

To get the result of list records, please use length(body('action name')?['value']).

4.If the result of list record is not 0, then create an update action to update the auto-number field. Here I used the Name field as auto number field, so I need to convert it from string to int first, and then +1 for this field to get new number for new record.

Best Regards,

Leo

Was this reply helpful? Yes No
Manny Floyd 50 on at

Like (0)

Report

Hi Leo, thanks for your reply.

I am getting this error on filter query

"Order By Property must be of type EdmProperty"

Was this reply helpful? Yes No
Manny Floyd 50 on at

Like (0)

Report

Hi - seems like Created On ( Date and time) is not liked by Order By

Was this reply helpful? Yes No
Suggested answer

LeoAlt 16,331 Moderator on at

Like (1)

Report

Hi Manny,

Sorry for that issue, you should change the field to manually filling like I showed below, and then it will work well.

Regards,

Leo

Was this reply helpful? Yes No
Manny Floyd 50 on at

Like (0)

Report

Hi Leo, thank you so much - that worked.

question :

What goes in : length(body('action name')?['value']). ??? I have a demo next week and our developer is out sick, that's why I am asking questions - want to keep customer happy (-;

Was this reply helpful? Yes No
LeoAlt 16,331 Moderator on at

Like (1)

Report

Hi partner,

length(body('action name')?['value']) is used to get the count of the records that from the "List Records" action.

The "Action Name" is the action name you want to use, in our case, the action name is "List_records". And you could also get this by the following steps.

1.Choose Length function first.

2.In the brackets, select the "Value".

Best Regards,

Leo

Was this reply helpful? Yes No
Manny Floyd 50 on at

Like (0)

Report

An action failed. No dependent actions succeeded. What is inside int in last step?

I think I am using incorrect values in int expression. Please help

Was this reply helpful? Yes No
Manny Floyd 50 on at

Like (0)

Report

If I try to convert "name" to int, it gives me an error

If I use Country Value to Int, on Name field it gives me 0+ 1 for China, 1+ 0 for Japan

Can you help me with Int function ?

see below

Was this reply helpful? Yes No
Suggested answer

LeoAlt 16,331 Moderator on at

Like (0)

Report

Hi partner,

You should use add() expression to do plus action.

And if the Entity Number field is a string field, you should use "

add(int(outputs('List_records')?['body/new_name']),1)

"

Best Regards,

Leo

Was this reply helpful? Yes No
Manny Floyd 50 on at

Like (0)

Report

Hi Leo, still same error. Not sure what I am doing wrong.

In Condition 2 I have new_countryname value is equal to 1

is it correct?

Was this reply helpful? Yes No