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

(0) Share

Report

Posted on by praveencrm

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/333927#M6034

Thanks,

Praveen

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (1)

abm abm 32,865 Most Valuable Professional on at

Like (0)

Report

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

Was this reply helpful? Yes No
Verified answer

v-bacao-msft on at

Like (0)

Report
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,

Was this reply helpful? Yes No