With({pInput: ParseJSON(pJSON)},Switch(pRepo,“ABB”,ClearCollect(col_ABBs,//remove just Value columnDropColumns(AddColumns(Table(ParseJSON(JSON(storedprocs_ABBsR4.dbospabbfinderr4(//Parameters:{filterabbstatus: Text(Coalesce(Text(pInput.abbstatus),“”)),filterproduct: If(IsBlank(_SelectedProductID),Text(Coalesce(Text(pInput.product),“”)),_SelectedProductID),filtersector: Text(Coalesce(Text(pInput.sector),“”)),filterindustry: Text(Coalesce(Text(pInput.industry),“”)),filtersituation: Text(Coalesce(Text(pInput.situation),“”)),search: Text(Coalesce(Text(pInput.search),“”)),filterproductgroupl0: Text(Coalesce(Text(pInput.productgroupl0),“”))}).ResultSets)).Table1),//ColumnNamesabbid,Text(Value.abbid),abbname,Text(Value.abbname),abbdescription,Text(Value.abbdescription),abbstatus,Text(Value.abbstatus),downloadcount,Value(Value.downloadcount),viewcount,Value(Value.viewcount),abbnumber,Text(Value.abbnumber),ppturl,Text(Value.ppturl),abbshortdescription,Text(Value.abbshortdescription)),Value)),“DataCatalogue”,ClearCollect(_dataCatalogueLib,//remove just Value columnDropColumns(AddColumns(Table(ParseJSON(JSON(storedprocs_DCLibR4.dbospdatacataloguelibraryr4(//Parameters{filteraccess: Text(Coalesce(Text(pInput.access),“”)),filterdatasourceprovider: Text(Coalesce(Text(pInput.datasourceprovider),“”)),filterindustry: Text(Coalesce(Text(pInput.industry),“”)),filterlicense: Text(Coalesce(Text(pInput.license),“”)),filtermemberfirm: Text(Coalesce(Text(pInput.memberfirm),“”)),search: Text(Coalesce(Text(pInput.search),“”))}).ResultSets)).Table1),//ColumnNamesrecordid,Text(Value.recordid),datasourcetitle,Text(Value.datasourcetitle),datasourceshortdescription,Text(Value.datasourceshortdescription),vendorlogo,Text(Value.vendorlogo),licensedmemberfirm,Text(Value.licensedmemberfirm),country,Text(Value.country)),Value)),“Credential”,ClearCollect(col_CredentialsFeeRangeTable,//remove just Value columnDropColumns(AddColumns(Table(ParseJSON(JSON(storedprocs_CredsR4.dbospcredentials1r4(//Parameters{feerangeorduration: 1,filtermaxduration: Text(Coalesce(Text(pInput.maxduration),“”)),filterminduration: Text(Coalesce(Text(pInput.minduration),“”)),filterproduct: If(IsBlank(_SelectedProductID),Text(Coalesce(Text(pInput.product),“”)),_SelectedProductID),filtersector: Text(Coalesce(Text(pInput.sector),“”)),filterindustry: Text(Coalesce(Text(pInput.industry),“”)),filterregion: Text(Coalesce(Text(pInput.region),“”)),search: Text(Coalesce(Text(pInput.search),“”))}).ResultSets)).Table1),//ColumnNamescredentialid,Text(Value.credentialid),projectname,Text(Value.projectname),projectyear,Text(Value.projectyear),leadpartner,Text(Value.leadpartner),projectdescription,Text(Value.projectdescription),projectduration,Text(Value.’projectduration(weeks)’),feerange,Text(Value.feerange),memberfirm,Text(Value.memberfirm),credentialurl,Text(Value.credentialurl),product,Text(Value.product),sector,Text(Value.sector),subsector,Text(Value.subsector),industry,Text(Value.industry),region,Text(Value.region),leadmemberfirm,Text(Value.leadmemberfirm)),Value)),“DocumentLibrary”,ClearCollect(col_DocumentLibrary,//remove just Value columnDropColumns(AddColumns(Table(ParseJSON(JSON(storedprocs_DocsR4.dbospdocumentlibraryr4(//Parameters{filterproduct: If(IsBlank(_SelectedProductID),Text(Coalesce(Text(pInput.product),“”)),_SelectedProductID),filterphase: Text(Coalesce(Text(pInput.phase),“”)),filteryourneed: Text(Coalesce(Text(pInput.yourneed),“”)),filterassettype: Text(Coalesce(Text(pInput.assettype),“”)),filterdocument1: Text(Coalesce(Text(pInput.document1),“”)),filterproductgroup2:…