web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Patch in power apps

Power Apps

Answered

Patch in power apps

(0) Share

Report

Report

Posted on by Sumaira

642

Hello Community Experts,

I have a custom order entity in my CDS, I have some products in my custom product entity, also i have the OOB account entity,

When i create an order, how do i make sure that the order created is for that particular account and the cutom products are added to my orders list

Its very urgent task I'm struggling with this, i tried a lot to resolve

Kindly guide

Best Regards

Sumaira

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (3)

Answers Img

Answers (1)

Sort by

Verified answer

v-bofeng-msft Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @Sumaira :

Could you tell me:

What is the relationship between order\products\account?

Which record in the product (account) is associated with the newly created order and whether there are related matching rules?

If there is a one-to-many or many-to-many relationship between entities, you can try the Relate function to associate them.

I assume the relationship between order and account is N:1.Then try this code:

Patch(orders,Defaults(orders),{Name:"Order5"});/*Ceate a new order*/ Relate( LookUp(OOBaccounts,Name="Bof").orders, /*Specify account "bof"*/ Last(Sort(orders,'Created On',Descending)) /*Get the last created order*/ )

Best Regards,

Bof

Was this reply helpful? Yes No
Sumaira 642 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks I'll try it @v-bofeng-msft

Was this reply helpful? Yes No
v-bofeng-msft Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @Sumaira :
Has the problem been solved?
Is there anything else I can help?
If my post helps, then please consider Accept it as the solution to help others.Thanks
Best Regards,
Bof

Was this reply helpful? Yes No

Join the conversation