How to use Get Records (Dynamics 365) inside Select Array ?

[Praveenpk365]

Hey Guys,

I'm new to the flows. I trying to connect flow with Dynamics 365 data. I got stuck with below when I'm building,

If you see snaps below, in "Select" Array, the field Account# is Lookup type in Quote Entity. Currently It is returning value as GUID. I want to access the related entity data, which means Account Name. Is there any possibility to use Get Record operation inside Select Array or any other way to achieve this ?

Can see my full flow configuration in the below thread

https://powerusers.microsoft.com/t5/Connecting-To-Data/Issue-in-Grouping-with-Dynamics-CRM-data/m-p/...

Thanks,

Praveen

[abm]

Hi @Praveenpk365 ,

After querying the list records iterate the records in a loop. Then use the Get Record flow action. Use the combined results from list and get to construct the select array

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up.

Thanks

[v-bacao-msft · Accepted solution]

Hi @Praveenpk365 ,

If you want to reference the field values in the lookup entity, using Select does not work.

You could refer to the configuration below.

• Use array variables to store the information you need instead of through Select.
• Use Get record action to get the field value specified in the lookup entity.
• Besides, If you want to filter records, you could add a condition above the Append to array action.

Image reference:

Hope it helps.

Best Regards,