Skip to main content

Notifications

Announcements

No record found.

Dynamics 365 general forum
Suggested answer

How to create a record against many records

Posted on by 310

Currently I have a couple of users who would create many new fields on the Account table/entity for temporary use, this has to stop unfortnately and I'm am trying to figure out a way they can instead create temporary records against (regards to) a list of Accounts but I'm stuck.

I can show them how to create one record easily using the main form below but how can they do this in bulk against a list of accounts?  They use advance find to aquire the list of accounts they would use.

They need to select an Acount (lookup) and a Audience record (lookup):
pastedimage1676929354926v1.png

Categories:
  • Leah Ju Profile Picture
    Leah Ju Microsoft Employee on at
    RE: How to create a record against many records

    Hi Partner,

    Have any updates?

    Please feel free to contact me if you have any questions!

    Could you click 'Yes' under title to close the thread if my answer is helpfu!

    Thanks in Advance! :)

  • Suggested answer
    Leah Ju Profile Picture
    Leah Ju Microsoft Employee on at
    RE: How to create a record against many records

    Hi G.Vetere,

    Yes, because there is no explicit requirement for Audience records, the flow would need to be changed manually.

    Alternatively, you could consider adding a flag field to the Audience table, using it as a condition in flow to filter to the required records, and then using it to create/ update temporary records.

    --Create one new column

    pastedimage1677133548589v1.png

    --Add 'List rows' between original two steps:

    pastedimage1677134086160v2.png

    --Using dynamic guid from 'List rows' action(Apply to each can be added automatically)

    pastedimage1677134182606v4.png

    Test:

    Make new record's flag is true, and other records are false.

    pastedimage1677134252530v5.png

    Run the flow:

    pastedimage1677134410384v6.png

  • G.Vetere Profile Picture
    G.Vetere 310 on at
    RE: How to create a record against many records

    Thats great, thank you

    The only sticking points which limits easy use for the user is the need to create/ update the flow each time a new Audience record is wanted, also the need to use the guid of the record.

  • Suggested answer
    Leah Ju Profile Picture
    Leah Ju Microsoft Employee on at
    RE: How to create a record against many records

    Hi G.Vetere,

    I have made some changes based on the latest information you have provided.

    1.i'll add the list is not static and changes with different logic entity’s plural name

    --Account view > Flow > Create a flow:

    pastedimage1677044285584v1.png

    --'When a record is selected' trigger, and 'Add a new row' action

    pastedimage1677044437825v4.png

    pastedimage1677044459767v5.png

    2.use the same Audience record for all Accounts

    --entity’s plural name(GUID)

    pastedimage1677044496816v6.png

    Test:

    Edit filters on the view to get list you need:

    pastedimage1677045390683v7.png

    Then select records to run the flow:

    pastedimage1677045441255v9.png

    pastedimage1677045424384v8.png

  • G.Vetere Profile Picture
    G.Vetere 310 on at
    RE: How to create a record against many records

    Hiya,  the Audience field is not linked to Account, and yes they would use the same Audience record for all Accounts in the list they produce, also i'll add the list is not static and changes with different logic

  • Suggested answer
    Leah Ju Profile Picture
    Leah Ju Microsoft Employee on at
    RE: How to create a record against many records

    Hi G.Vetere,

    1.You can import bulk data from excel:

    https://www.cloudfronts.com/blog/dynamics-crm/import-bulk-data-using-excel-template-in-microsoft-dynamics-365-crm/ 

    2.Or you can create records automatically through power automate:

    (1)Go to Power Automate to create one instant flow:

    pastedimage1676947273238v1.png

    (2)List rows--retrieve account records you need:

    pastedimage1676947357899v2.png

    --You mentioned: They use advance find to aquire the list of accounts they would use.

    So you can download fetch xml, copy and paste in the flow, 

    pastedimage1676948698340v3.png

    pastedimage1676948744480v4.png

    (3)Add a new row:

    pastedimage1676958001249v5.png

    Test:

    pastedimage1676958020158v6.png

    pastedimage1676958040847v7.png

    =========================

    For your Audience field, I'm not sure what you are basing the populating on:

    Is it the same value for each record, or different values for different records? Is it linked to account?

    You can try to design your own flow to add more steps. Or you can provide more information and let me know how I can help you.

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

Anton Venter – Community Spotlight

Kudos to our October Community Star of the month!

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Dynamics 365 Community Newsletter - September 2024

Check out the latest community news

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,564 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,651 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans