Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Service | Customer Service, Contact Center, Fie...
Suggested answer

Prevent Work Oder Service line order field duplicate number

(0) ShareShare
ReportReport
Posted on by 356

I have customization that creates work order service lines when time entry is created. When I mark booking to complete, time entry gets created which then creates the work order service lines. I notice line order having duplicate number associated with it. Is there a way to force line order having unique values? I tried to update line order number through plugin code and/or power automate flow but that didnt help.

Please let me know if anyone faced this issue and the resolution.

Thank you,

  • Dhasara Devi G N Profile Picture
    356 on at
    RE: Prevent Work Oder Service line order field duplicate number

    Thank you Abdul Wahab for your response. I do not want to create an alternate key as the current integration from CE to FSC through logic apps uses line order from Work Order Service and it fails integrating data as there are duplicate line order numbers. We are in a situation where we do not want to change the integration code but prevent line order number getting duplicate number assigned.

  • Suggested answer
    Abdul Wahab Profile Picture
    12,085 Moderator on at
    RE: Prevent Work Oder Service line order field duplicate number

    Hi Devi Gana,

    You can handle the situation by creating keys in the Work Order Service table.

    pastedimage1676005260060v1.png

    For more details: 

    1. https://learn.microsoft.com/en-us/power-apps/developer/data-platform/define-alternate-keys-entity
    2. learn.microsoft.com/.../define-alternate-keys-reference-records

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Ramesh Kumar – Community Spotlight

We are honored to recognize Ramesh Kumar as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard > Service | Customer Service, Contact Center, Field Service, Guides

#1
Muhammad Shahzad Shafique Profile Picture

Muhammad Shahzad Sh... 51 Most Valuable Professional

#2
Ramesh Kumar Profile Picture

Ramesh Kumar 42

#3
David Shaw_UK Profile Picture

David Shaw_UK 27

Featured topics

Product updates

Dynamics 365 release plans