Skip to main content

Notifications

Finance | Project Operations, Human Resources, ...
Answered

Power App to Dynamic 365

(0) ShareShare
ReportReport
Posted on by 253

Hi!

I would like to request some favor. Recently I need do a prototype to represent our key users to understand about power app and it can automatically to fullfill in D365 but when I do a power automate with some criteria to fullfill I don't know an Entoty, Object ID Can someone guide me how to do.

6607.pastedimage1681271569500v1.png

Best regards,

  • Mohit Rampal Profile Picture
    Mohit Rampal 12,552 Super User 2024 Season 1 on at
    RE: Power App to Dynamic 365

    Please mark answer/s verified that worked for you.

  • Mohit Rampal Profile Picture
    Mohit Rampal 12,552 Super User 2024 Season 1 on at
    RE: Power App to Dynamic 365

    You can generally find the name of entity from D365 F&O forms when you click on Open in Excel and field names can be found from right clicking field and field information (Although form control name can be different from table field name, in that case you would need help from F&O Developer)

  • Chomchanok Profile Picture
    Chomchanok 253 on at
    RE: Power App to Dynamic 365

    Thank for all,

    Now I can update data in D365 that I want,I was wondering if you could assist me in finding the name of an entity and its corresponding field in D365. Can you please advise me on how to go about this?

    Thanks

    Thanakorn

  • Verified answer
    Mohit Rampal Profile Picture
    Mohit Rampal 12,552 Super User 2024 Season 1 on at
    RE: Power App to Dynamic 365

    As Customers are legal entity specific so you need to provide dataAreaId as well. Please check Andre's blog as suggested and let us know if any issues.

  • Verified answer
    André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 291,965 Super User 2025 Season 1 on at
    RE: Power App to Dynamic 365

    Hi Thanakorn,

    The error message tells you that you need to include the dataareaid as first field in the object ID. This is the reference to the legal entity in Dynamics 365 Finance. You can read more about the Object ID in my blog: Let your Operations Flow - Part 3 (dynamicspedia.com)

  • Chomchanok Profile Picture
    Chomchanok 253 on at
    RE: Power App to Dynamic 365

    Dear Mohit

    I try to follow your example but I still got error.  "Only 1 of 2 keys provided for lookup, provide keys for dataAreaId,CustomerAccount.
    clientRequestId: 80aaed42-7940-449f-a6b8-6bb02a00fb9b".

    On this part I try to put D365 Customer ID to identify the record that I would like to change. Do you have some idea on this issue?

    pastedimage1681544396289v1.png

    pastedimage1681544490685v2.png

    pastedimage1681544534249v3.png

    pastedimage1681544617900v4.png

  • Suggested answer
    Mohit Rampal Profile Picture
    Mohit Rampal 12,552 Super User 2024 Season 1 on at
    RE: Power App to Dynamic 365

    Hi, Please check this video on how to create D365 F&O Customer from Power Automate. It will provide you all details like data entity name is CustomersV3 etc. Object Id is unique index to find record and in CUstomerV3 data entity, object Id is 'Customer account'. If still any issues, please let us know.

    www.youtube.com/watch

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,965 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 230,836 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans