Hi @Anonymous ,
Could you explain why you are using this piece of code?
Is it to get the columns of the data source?
If the data source contains data, it will also be collected and entered into colSPlist.
In this way, when you are in Forall, the data that has been submitted to the data source will appear.
The second question:
From the screenshot you provided, we can see that some fields are empty.
In the code you provided, the data is not collected into colSPlist.
The Patch() you use is just the data source to submit the data to , but it is not collected into ColSplist, so when you use flow to submit, no data will appear.
It is suggested here to fill in some attributes when you add each piece of data
's OnSelect:
Collect(
colSPlist,
{
'Employee Name':User().FullName,
'Mail ID': User().Email,
'Entity ': Office365Users.UserProfileV2(User().Email).companyName,
MaterialCode: ComboBox1_1.Selected.Result,
Type: DataCardValue5_1.Text,
Description: DataCardValue6_1.Text,
HSNCode: DataCardValue7_1.Text,
Make: DataCardValue8_1. Text,
UOM : DataCardValue9_1.Text,
Unit: DataCardValue10_1.Text,
Quantity: DataCardValue11_1.Text,
Amount: DataCardValue2_1.Text
}
); ResetForm(Form1_1)
's OnSelect
ForAll(
colSPlist,
Patch(
'PR INTENT LIST',
Defaults('PR INTENT LIST'),
{
'Employee Name': User().FullName,
'Mail ID': User().Email,
'Entity ': Office365Users.UserProfileV2(User().Email).companyName,
'Material Code': ThisRecord.'Material Code',
'Type ': ThisRecord.'Type ',
Description: ThisRecord.Description,
'HSN Code ': ThisRecord.'HSN Code ',
'Make ': ThisRecord.'Make ',
UOM: ThisRecord.UOM,
'Unit Rate ': Value(ThisRecord.'Unit Rate '),
'Quantity ': Value(ThisRecord.'Quantity '),
Amount: Value(ThisRecord.Amount)
}
)
);
PRIntentTestScenarioFlow.Run(
JSON(
colSPlist,
JSONFormat.IncludeBinaryData & JSONFormat.IgnoreUnsupportedTypes
)
);
Clear(colSPlist)
Best Regards
Cheng Feng
