Finance | Project Operations, Human Resources, ...

Logic App - Get A Record (Multiple Values for Object ID)

(0) Share

Report

Posted on by Community Member

Hello,

This is to report one of the issue I start seeing. It is 'Get a record' for Dynamics 365 Finance & Operation.

I am doing very simple action for now. Get a record for Customer Group of '90'.

Unique Identifier : CustGroupId

By using just CustGroupId , I was getting error related to keys. ( Only 1 of 2 keys provided for lookup, provide keys for dataAreaId,CustomerGroupId )

But then I started providing DataAreaId as well. I am doing it in the following way: usmf,90 ( I tried many combinations but no luck. i.e. Upper case, quotes, semi colon etc)

I know this used to work before but now I see this issue. Not sure if something got change in Data entity framework

Thanks in advanced.

I have the same question (0)

All responses (8)

Answers (0)

André Arnaud de Cal... 301,119 Super User 2025 Season 2 on at

Like (0)

Report

Hi Ronak,

When you mentioned you used quotes, did you try single quotes?

As workaround, you can also try to use variables and fill it with a string.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi Andre,

Thanks for your quick reply.

Yes, I tried single quotes ('usmf','90'). and also used variables approach ( variable1,variable2).

I tried within bracket too.

Thanks again.

Was this reply helpful? Yes No
Suggested answer

Mea_ 60,284 on at

Like (1)

Report

It says not found. When you connect via flow it uses default user company. So check if it is usmf in user settings.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

It is a good point. I can try to change my default company and see if that resolves.

FYI, I was able to get a record where there is only one Key. i.e. Workers, LegalEntities. The issue starts when you have more than one key combination. i.e. dataAreaId,CustGroupId together.

I think something have got changed recently as I was able to work with this before.

Thanks again for your reply.

Was this reply helpful? Yes No
André Arnaud de Cal... 301,119 Super User 2025 Season 2 on at

Like (0)

Report

Hi Ronak,

The workers and legal entities are not linked to a company. So, it could be indeed the default legal entity on your user settings like Ievgen mentioned.

Was this reply helpful? Yes No
Suggested answer

Ronak Brahmbhatt 70 on at

Like (1)

Report

Hello,

I am reactivating this thread as I needed the help again as I was working on similar kind Power Automate / Flow.

The issue is resolved now. All you have to do is: dataAreadId,CustomerGroupId (Just comma between two values, No quotes, No semicolon).

Hope this will help someone in future.

Thanks everyone for your input.

Best,

Ronak

Was this reply helpful? Yes No
Nitin Rajan 20 on at

Like (0)

Report

Hi Ronak,

I am also in a similar situation. I didn't understand the difference from your initial question and the final solution. In the initial question you are using 'usmf,90' that is dataareaid, custgroupid in the solution also it says the same. Can you give some additional inputs.

Was this reply helpful? Yes No
André Arnaud de Cal... 301,119 Super User 2025 Season 2 on at

Like (0)

Report

Hi Nitin,

Note that Ronak was not the person who started the question. I'm not able to understand what exactly you are asking now. Can you elaborate on your question?

Was this reply helpful? Yes No