Hi all,
I need to duplicate an opportunity, but I have sopme difficulty with lookup fields .... I follow this post reccomended in this community (https://linnzawwin.blogspot.com/2019/11/power-automate-how-to-set-lookup-field.html) but I don't understand what I'm doing wrong.
fields numerated are lookup fields (1st is a custom table)
Yes, you can run below url in your browser to get entitysetname of any entity.
Replace [ORG URL] with your instance and change transactioncurrency to any entity logical name
[ORG URL]/api/data/v9.0/EntityDefinitions(LogicalName='transactioncurrency')?$select=EntitySetName
Response will have entity set name as below.
{"@odata.context":""EntitySetName":"">XXXX.crm.dynamics.com/.../$metadatatransactioncurrencies","MetadataId":"5f2e7ae7-d327-49b5-a343-61d48f1bcd28"}
Thanks very much
it works now .... but without the xrmtoolbox, this is not identifiable in the tables with power apps ...
there is another way to know the "entity set name"?
Hi Die Pic,
Try using entity set name.
for currency : transactioncurrencies(xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx)
Similarly check entity set name of your custom entity using Xrmtoolbox www.xrmtoolbox.com/.../
Cheers,
Ketan
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.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Andrés Arias as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Daniyal Khaleel 141
DAnny3211 134
Abhilash Warrier 70 Super User 2025 Season 2