/* _______________________________ */
/* On click of button below code execute */
/* _______________________________ */
Set(
userloc,
Filter(
'[dbo].[IA_TSA]',
SM_USERID = lbUserId.Text
)
);
Set(
varLocList,
Concat(userloc,LOC_I,", ")
);
Set(
varSMCodeList,
Concat(userloc,SM_C,", ")
);
Navigate(ScrCreateICTRequest)
/* _______________________________ */
/* Filter data source depending on the list varSMCodeList, varLocList */
/* _______________________________ */
Sort (GroupBy(
Filter(
'[dbo].[IA_VOR]',
varSMCodeList in SM_C &&
varLocList in LOC_I
),
"ORDER_I",
"CUST_I",
"ORD_CREATE_DATTIM_D",
"SM_C",
"Other"
),ORD_CREATE_DATTIM_D,Descending)
Issue: When the list variable varSMCodeList, varLocList return multiple values NO RECORD FOUND. Works well for single values.
varSMCodeList = “A8”, “X0” && varLocList = “111”, “22X”, “333” X
varSMCodeList = “A8” && varLocList = “111” OK
