Fix Power Automate Creating Blank SharePoint List Rows

Navigate to the Power Automate portal, select your specific flow from the 'My flows' list, and click on 'Edit' to view the workflow steps.

Scroll down to the 'Create item' (SharePoint) action and expand it to reveal the list of SharePoint columns.

Review each column field to ensure it contains the correct dynamic content token representing the corresponding form question.

If a field is empty or contains an incorrect token, click inside the field, delete any wrong data, and select the correct response token from the dynamic content menu on the right.

If you are using Microsoft Forms and do not see your questions in the dynamic content menu, ensure you have added the 'Get response details' action immediately after the trigger step.

From the Power Automate dashboard, click on your flow to view its details, then select a recent successful run from the '28-day run history' section.

Expand the trigger step (e.g., 'When a new response is submitted') and check the 'Outputs' section to confirm the form data was successfully captured by the flow.

Expand the 'Create item' action and look at the 'Inputs'. If the values shown here are null or empty strings, the mapping is incorrect. If the values are present but the SharePoint list is blank, the issue lies within the SharePoint list column configurations.

Navigate to your SharePoint list, click the gear icon to access 'List settings', and check the specific data type of each column (e.g., Single line of text, Number, Date and Time).

Ensure that the data type of the form response perfectly matches the SharePoint column. For instance, passing text into a Number column will result in a blank entry.

Either modify the SharePoint column to 'Single line of text' to accept all incoming formats, or use Power Automate's data operations (like 'Compose') to convert the form response to the required type before the 'Create item' action.