Power Platform Community Forum Thread Details

Hi,

I have a button and OnSelect, I have a SQL request to extract data via stored procedure. The code is as follows:

Attempt1 :

Set(
    colDWData,
   Datawarehouse.SelBailment(
    {MonthDate:20260131, DealerGroup:"", 
     ArrearsOnly: 0, SuspenseOnly:0,CalculateInterest: 0,  
    CurtailmentDueOnly:1, SortOrder:3,  IncludeAllCurtailment:0, ProductBailment: 1, ProductCapitalGrowth:0,  
    ExcludePaid:0,  ExcludeSmallValue:0,CurtailmentArrearsOnly:0,AgreementNumbers:""}
    ).ResultSets.Table1
);
Set(
    TypedTable,
    ForAll(
        colDWData,
        {
            DealerGroupExternalName: Text(ThisRecord.DealerGroupExternalName),
            CurtailmentDescription: Text(ThisRecord.CurtailmentDescription),  
            SortOrder: Text(ThisRecord.SortOrder),  
            AgreementNumber: Text(ThisRecord.AgreementNumber),  
            DealerGroupID: Text(ThisRecord.DealerGroupID)}));
    //        StartDate: DateValue(ThisRecord.StartDate),
 
Attempt2 :
Set(
    MyObject, // pull results into variable
  Datawarehouse.SelBailment({MonthDate:20260131, DealerGroup:"",     ArrearsOnly: 0, SuspenseOnly:0,CalculateInterest: 0,  
    CurtailmentDueOnly:1, SortOrder:3,  IncludeAllCurtailment:0, ProductBailment: 1, ProductCapitalGrowth:0,  
    ExcludePaid:0,  ExcludeSmallValue:0,CurtailmentArrearsOnly:0,AgreementNumbers:""}
    ).ResultSets
);
Set(
    table1, // put Table1 into table1
    MyObject.Table1
);
Set(
    TypedTable,
    ForAll(
        table1, // extract JSON from table1
        {  DealerGroupExternalName: Text(ThisRecord.DealerGroupExternalName),
            CurtailmentDescription: Text(ThisRecord.CurtailmentDescription),  
            SortOrder: Text(ThisRecord.SortOrder),  
            AgreementNumber: Text(ThisRecord.AgreementNumber),  
            DealerGroupID: Text(ThisRecord.DealerGroupID)}));
 
 
For both methods, no data is returned.  The pameters with a value of "0" are boolean.  Can anyone assist please.
 