I am using SharePoint as my datasource and using Modern Table control to display my Data from SharePoint list in Grid. When there are some records in List, then those records are displayed in Modern Table. Problem starts, when there are no records in my SP List, loader inside Modern Table loads forever.
Below is my code:
I load data on OnSelect of button on First Screen and use colGridData on another to display data in Grid on some other table
// Load Grid data
ClearCollect(
colGirdData,
Filter(
'My Child SP List',
'My Child SP List'.Id = ParentList.Selected.ID
)
);
Items Property: ForAll(Sequence(CountRows(colGirdData)), Patch(Last(FirstN(colGirdData, Value)), {'Sr. No': Value}))
//Here ForAll, Sequence Patch functions are used just for adding Serial No to my collection
My scenario is, I have two lists. One, Projects list (Parent), second Tasks List(child). Tasks list has a lookup column to Projects list.
