Power Platform Community Forum Thread Details

Can anyone assist pls:

I want to retreive data with comma separated from two columns.

Set(EditParticulars,LookUp( 'Expense Claim Request', ID=SharePointIntegration.SelectedListItemID, Particulars));
Set(EditParticulars,Left(EditParticulars,Len(EditParticulars) - 1));

Set(EditAmount,LookUp( 'Expense Claim Request', ID=SharePointIntegration.SelectedListItemID, Amount));
Set(EditAmount,Left(EditAmount,Len(EditAmount) - 1));

ForAll (
Split(EditParticulars, ","),
Collect (
CollRepSec,
{
Particulars: Text(Last (FirstN(Split(Result,",").Result).Result).Result)
}
)
);

ForAll (
Split(EditAmount, ","),
Collect (
CollRepSec,
{
Amount: Text(Last (FirstN(Split(Result,",").Result).Result).Result)
}
)
)