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)

Manny Floyd 50 on at

Like (0)

Report

RE: Different Sequence of Auto-Numbering within One Entity

Thank you all. I actually used Plugin and it's working like a charm. Now my next task is how to fetch a field value of previous record. For example if Country Japan has value 20, I want next record to pre-populate Country Japan with value 20

Was this reply helpful? Yes No
Suggested answer

a33ik 84,331 Most Valuable Professional on at

Like (0)

Report

RE: Different Sequence of Auto-Numbering within One Entity

Plugin approach will work for sure. Before going that path you should check if you can create that attribute through the code - jonasr.app/.../ I didn't do any work of that kind with on-prem for ages so I don't know if this possibility reached the on-prem platform. Good luck.

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

Like (0)

Report

RE: Different Sequence of Auto-Numbering within One Entity

Hi Andrew, on-prem. I am looking at plug-in approach now. It seems like nothing else will work. Let me if any other options I have.

Was this reply helpful? Yes No
a33ik 84,331 Most Valuable Professional on at

Like (0)

Report

RE: Different Sequence of Auto-Numbering within One Entity

Manny,

Are you online or onprem?

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

Like (0)

Report

RE: Different Sequence of Auto-Numbering within One Entity

Hi Andrew, yes, I looked at that before. At first, I was very excited but then noticed that I do not have data type "auto-number"

I am in model driven app. It's sometimes confusing to see different types of power-apps/licenses especially for a beginner like me.

Was this reply helpful? Yes No
Suggested answer

a33ik 84,331 Most Valuable Professional on at

Like (1)

Report

RE: Different Sequence of Auto-Numbering within One Entity

Hello,

Check this post - jonasr.app/.../

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

Like (0)

Report

RE: Different Sequence of Auto-Numbering within One Entity

Good Morning Leo,

new_entryno field is string. see below.

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

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

Like (0)

Report

RE: Different Sequence of Auto-Numbering within One Entity

Hi Manny,

What's the content in the int expression in your Flow?

Regards,

Leo

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

Like (0)

Report

RE: Different Sequence of Auto-Numbering within One Entity

Hi Venkata,

any existing plugins I can use?

Was this reply helpful? Yes No
Suggested answer

venkatsr User Group Leader on at

Like (1)

Report

RE: Different Sequence of Auto-Numbering within One Entity

Hi,

If flow does not helps you then go with an plugin ,definitely you can achieve this.

Was this reply helpful? Yes No