Skip to main content

Notifications

Customer experience | Sales, Customer Insights,...
Unanswered

workflow to update a "unique" entity number field

(0) ShareShare
ReportReport
Posted on by 99

Hello everyone,

We are in the process of doing a data migration to our SharePoint instance because we have about 70gb of attachments in our data blob currently, and before we make the move to CRM online we need to make our data blob smaller for the sake of cost. 

We are using the OOB opportunity entity that we renamed to Programs, within this entity is we store the attachments (.docx,.jpeg,.pdf).

I have created a flow using PowerApps to migrate the attachments for our DB to our SharePoint and it works well. My problem is that SharePoint needs a unique naming scheme because it does not like folders with duplicate names, which is preventing all the programs from coming over because unfortunately we have duplicate names for our programs. so instead of using the Opportunity ID for the unique program folder name in SharePoint ( users would have a hard time correlating the Opportunity ID on the SharePoint folder to the correct account in CRM. Opportunity Id only shows up in the URL of the "program" or opportunity you are on.) we created a field called "Program  #"  on the form, this field will serve as our Unique ID folder name so that the migration goes smoothly.

This brings me to where I need help! I need help creating a workflow to update all of 5000+ programs # fields that are held in this entity. starting from the number 1. 

I have already created a workflow to AutoNumber the program # field for future program creations

Could someone give me some steps on how to do this? I am using CRM 9.0 on premise, SharePoint on premise and flow using legacy data connectors. 

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

News and Announcements

Announcing Category Subscriptions!

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Verified Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,359 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,370 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans