Reduce requests to your data store for a master-detail functionality - #ARCHIVED#

Posted on by
This content has been archived. It may no longer be relevant.  

The embedded video shows a method to significantly reduce the amount of requests to a data store by not using an entity/table/list for the details in a master-detail business solution. This could be useful because the available amount of requests per account depend on your licensing: https://docs.microsoft.com/en-us/power-platform/admin/powerapps-flow-licensing-faq

The demo app can be found on my GitHub repository: 2020 / Reduce requests to your data store for a master-detail functionality / Reduce requests to your data store for a master-detail functionality.zip

In the demo, SharePoint is used as a data store, but this could also be the Common Data Service (CDS), SQL Server etc..

Below, some code fragments from the demo are shown below.

Patch(coll_Products, ThisItem, {Amount: Value(ti_gall_4.Text)})
ClearCollect(coll_Products2, AddColumns(Filter(coll_Products, !IsBlank(Amount)), "Concatenate", Concatenate(ProductID, "|", Text(Amount))));
UpdateContext({var_Products: Concat(coll_Products2, Concatenate, ";")});
Patch(Orders, Defaults(Orders), {Title:"Order", OrderID:Text(GUID()), Products:var_Products});
ClearCollect(coll_OrderProducts, Split(ThisItem.Products, ";"));
LookUp(Products, ProductID = First(Split(ThisItem.Result, "|")).Result).Title

Print 🖨