Skip to main content

Notifications

Customer experience | Sales, Customer Insights,...
Suggested answer

Can I query another entity within a workflow run on the creation of a record for a separate entity.

Posted on by 107

Hi,

I have a Case entity.

Cases have a related entity Customer which are located in a council area which is recorded against each council. This council area has a value "Average wages" that is held in a separate entity Locations

I have field on the Case entity called "Case Average Wage". I want to populate it with the value from the Locations table when a new case is created. 

Case field:"Case Average Wage" >> Customer >> Locations field:"Average wages"

Is this possible to do from a background workflow?

i.e.

  1. get customer for case
  2. lookup location for customer
  3. get value for "Average wages"  from locations table
  4. set field "Case Average Wage" on the Case record to this value

Is this possible without using a plugin?

Thank you for your time,

Ollie

  • Suggested answer
    Amit Katariya007 Profile Picture
    Amit Katariya007 8,506 Super User 2024 Season 1 on at
    RE: Can I query another entity within a workflow run on the creation of a record for a separate entity.

    If you want to run when a record is created using +New button then u can also use JS. Else Plugin will be only solution.

  • Suggested answer
    Amit Katariya007 Profile Picture
    Amit Katariya007 8,506 Super User 2024 Season 1 on at
    RE: Can I query another entity within a workflow run on the creation of a record for a separate entity.

    Then plugin will be the last option for you. 

  • Suggested answer
    Pradeep Rai Profile Picture
    Pradeep Rai 5,490 Super User 2024 Season 2 on at
    RE: Can I query another entity within a workflow run on the creation of a record for a separate entity.

    Then you have to use plugin.

  • Oliver_McErlane Profile Picture
    Oliver_McErlane 107 on at
    RE: Can I query another entity within a workflow run on the creation of a record for a separate entity.

    Unfortunately we are not in the cloud, therefore cannot use PowerAutomate

  • Suggested answer
    Amit Katariya007 Profile Picture
    Amit Katariya007 8,506 Super User 2024 Season 1 on at
    RE: Can I query another entity within a workflow run on the creation of a record for a separate entity.

    Workflow will be having some limitations with 2nd reference...so you can use power automate or plugin which will be ideal and practical solution

  • Suggested answer
    Pradeep Rai Profile Picture
    Pradeep Rai 5,490 Super User 2024 Season 2 on at
    RE: Can I query another entity within a workflow run on the creation of a record for a separate entity.

    Hi,

    In the workflow you can not retrieve the records.

    Please use power automate for the same.

    You can perform all required action in power automate.


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

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 Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,188 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans