You’re offline. This is a read only version of the page.
945
Hi,
In my app, under 1 screen, I have 2 datasource which is 1 is the parent (header) and the other is its child (detail). I put the header in a form and the detail in a gallery.
Btw, this is a canvas app that embed to Model-driven form, so the header is actually will get the record from ModelDrivenFormController.
In that gallery (details) - items property I already put something like this :
Share
ReportSortByColumns(Filter('Order Details', 'OrderID' = CurrentOrder.'Order ID'),"mscrm_linenumber")so it will be populated with only the records (rows) of the order id in header form.
It is running correctly, but one problem is, when the 1st time this app is loading (open), this gallery detail looks firstly showing all my detail tables. It is change quickly to the related rows based on the formula, but in a few second (probably only half second) before that, I can see it was showing all my records first.
How to fix this ? or is there any trick to not make this happened ?
Thanks
Hi @Axal ,
You could try this formula:
All responses (
Answers (
If(CountA(Filter('Order Details', 'OrderID' = CurrentOrder.'Order ID').'Created By')=CountA('Order Details'.'Created By'),Filter('Order Details', false ),SortByColumns(Filter('Order Details', 'OrderID' = CurrentOrder.'Order ID'),"mscrm_linenumber"))
Best Regards,
Wearsky
