Skip to main content

Notifications

Dynamics 365 Community / Forums / Field Service forum / how to extract a vitua...
Field Service forum
Suggested answer

how to extract a vitual column from meta data in power automate

Posted on by 5

I would like to extract this column in power automate:

'_msdyn_account_value@OData.Community.Display.V1.FormattedValue'

I am only able to extract  'msdyn_account' as a column and compose a value which is an id value and not the string I would like to extract

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: how to extract a vitual column from meta data in power automate

    Hi jazz2,

    Formatted Value couldn't be got in the output of the Microsoft Dataverse trigger. However, you could get it in the Get a record and List records actions of Common Data Service (current environment) connector.

    So if you could add a step to get them.

    Screenshot-2022_2D00_02_2D00_24-092216.png

    Reference:

    https://linnzawwin.blogspot.com/2020/07/get-lookup-display-name-and-option-set.html

Helpful resources

Quick Links

Dynamics 365 Community Update

Welcome to the inaugural Community Platform Update. As part of our commitment to…

Dynamics 365 Community Newsletter - August 2024

Catch up on the latest D365 Community news

Community Spotlight of the Month

Kudos to Mohana Yadav!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 227,954 Super User 2024 Season 2

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans