Get a record dynamics Operations

[Anonymous]

Hello

I wish to retrieve the data from a table in Dynamics 365FO. In my case it is the account number for all customers, which I believe can be found in the CustomersV3 entity.

I am able to select the CustomersV3 when I use the action "get record", but I am not able to specify which collumn is to be retrieved. Does anybody know how I am able to retrieve this information?

Kind regards,

Ivan Larsen

[v-yuazh-msft]

Hi @Anonymous,

Could you please share a screenshot of the configuration of your flow?

I have made a test on my side to get all the Account Number from a Account entity as below:

 

You could refer to my screenshot to create your flow to get all customers from CustomersV3 entity.

Best regards,

Alice

[Anonymous]

Thanks for your response Alice!

I am having some issues with your solution since you are refering to Dynamics 365 and not Dynamics 365 for Operations, and the one for Operations does not have a "list records"-function. Do you know if that matters?

Kind regards

Ivan

[v-yuazh-msft · Accepted solution]

Hi @Anonymous，

You could use the "Get records" action of Dynamics 365 for Operations connector:

 

Best regards,

Alice

[GabrielStJohn]

Hello, @Anonymous!

Thank you for posting on the Flow Community Forum! Have you had an opportunity to apply @v-yuazh-msft‘s recommendation to adapt your Flow? If yes, and you find that solution to be satisfactory, please go ahead and click “Accept as Solution” so that this thread will be marked for other users to easily identify!

Thank you for being an active member of the Flow Community!

-Gabriel
Flow Community Manager

[dynamiacs]

Did the solution works for you?

Can you apply this?