Getting blank entries in SharePoint list while submitting data from data table along with text input filed

[RKPillai]

Hi all,

I am getting blank entry while submitting the data from form which has data table as well. Below is the screenshot of form.

Below is the screenshot of sharpoint list.

I am using below formula in submit button

Patch(
'PCProcurementForm- R and D',
Defaults('PCProcurementForm- R and D'),
{
Title: Title_1.Text,
'Reference No': Refrence_No_1.Text,
Requestor: Requestor_Name_4.Text,
'Create Date': Date_created_2.SelectedDate,
Quarter: Quarter_DD_2.SelectedText.Value,
'Requestor Email': Email_2.Text,
'Legacy Entity': 'Legacy Entity_2'.SelectedText.Value,
'Country Name': Country_Name_2.SelectedText.Value,
'Keyboard Legends':'Keyboard Legend_1'.SelectedText.Value
}
);
Patch(
'PCProcurementForm- R and D',
ForAll(
Coll_PCdemand As aCol,
{
Title: aCol.Tittle,
'Reference No': aCol.'Reference No',
Category: aCol.Category,
Model: aCol.Model,
Requirement: aCol.Requirement
}
)
);

Any help would be highly appreciated.

[ShaheerAhmad]

From the provided information, it seems that you are experiencing issues with getting blank entries in SharePoint while submitting data from a form that includes a data table and text input fields. Here are a few suggestions to troubleshoot the problem:

1. Check the data table source: Verify that the data table is correctly bound to a data source and that the data is being displayed correctly in the table. Ensure that the data table's Items property is set to the correct data source or collection that contains the data.

2. Verify text input field values: Double-check that the text input fields are properly connected to the respective data table columns or fields. Ensure that the text input controls have the correct Default or Text property set to retrieve the values from the data table.

3. Validate data before submission: Add data validation to your form to ensure that the required fields have values before submitting. You can use functions like IsBlank or IsEmpty to check if the text input fields are empty or if the data table has any missing values.

4. Verify the Patch function: Review the Patch function you're using to submit the form data to SharePoint. Check that the column names in the Patch function match the column names in your SharePoint list. Also, ensure that the Patch function is executed after the data table is updated with the latest values.

5. Debug and display values: To help troubleshoot, you can add temporary labels or notifications to display the values of the text input fields and data table columns before submitting the form. This will help you confirm whether the values are correctly captured and passed to the Patch function.

6. Test with simplified form: Create a simplified version of your form without the data table and only include the text input fields. Test if the data is correctly submitted to SharePoint using this simplified form. If it works as expected, gradually add the data table and additional components back to the form, testing at each step to identify any issues.

7. SharePoint list column settings: Check the column settings in your SharePoint list, such as required fields or specific data types. Ensure that the column settings align with the data you're trying to submit from the form.

8. SharePoint list permissions: Verify that the user submitting the form has the necessary permissions to create or edit items in the SharePoint list. Check the user's permissions and the SharePoint list's permission settings.

By following these steps, you should be able to identify the cause of the blank entries in SharePoint and resolve the issue.