Network Error when using Patch function: The requested operation is invalid, in teams power apps.

Question

I built a team power app with an edit form and a SharePoint list as the data source. I used the SubmitForm and ResetForm functions on the submit button. In the form, I have a date and time field. If we fill out all of the fields, data is submitted; however, if we leave the date and time fields blank, an error is generated. My requirement is that date and time fields be in view or edit mode depending on the logged-in user. The datetime field in the form is similarly not required field.

All of the columns in the SharePoint list are No required columns.

Please suggest any solution.

Thanks

Answer 1

Hello Jayesh P,

I am Ibhadighi and I would happily help you with your question. In this forum, we are Microsoft consumers just like yourself.

The error message "The requested operation is invalid" in Teams Power Apps often occurs when there's a mismatch between the data type expected by the SharePoint list and the data you're trying to submit. In your case, it appears that the datetime field in the form is causing the issue when it's left blank.

Here are some steps you can take to troubleshoot and potentially resolve this issue:

1. Check Data Type Compatibility: • Ensure that the data type of the date and time field in your SharePoint list matches the data type expected by the Power App form. If the SharePoint column is set to expect a datetime value, make sure your form field is also configured as a datetime field.
2. Default Values: • If the date and time fields are not required and can be left blank, consider setting default values for these fields in your form. You can set a default value to be an empty datetime value.
3. Patch Function Syntax: • Double-check your Patch function syntax. When using Patch to submit data to SharePoint, make sure you're specifying the correct columns and data types. Ensure that you're using the Patch function correctly for both scenarios (when the date/time is filled out and when it's left blank).
4. Formula Validation: • Add validation to your Power App form to ensure that the date and time fields are correctly formatted before submission. For example, you can use the IsBlank function to check if a date and time field is empty before using the Patch function.
5. Required Field Property: • Even if your SharePoint columns are not set as required, ensure that the corresponding fields in your Power App form are not marked as required. You can check the "Required" property of the fields in the EditForm.
6. Data Source Schema: • Sometimes, refreshing the data source schema can help resolve issues related to data type mismatches. In the Power Apps Studio, go to the "Data sources" pane, select your SharePoint data source, and choose "Refresh." This can update the schema and potentially resolve data type issues.
7. Data Card Properties: • Check the properties of the data card that corresponds to the datetime field in the EditForm. Ensure that its "Update" property is correctly configured to update the SharePoint column.
8. Error Handling: • Implement error handling in your Power App to capture any specific error messages returned by SharePoint. This can provide more detailed information about what might be causing the "invalid operation" error.
9. SharePoint List Configuration: • Review the configuration of your SharePoint list to ensure that it doesn't have any validation rules or settings that might be causing issues.
10. Testing in Preview Mode: • Test your app in the Power Apps Studio's Preview mode to see if it generates any more specific error messages that can help identify the issue.

By following these steps, you should be able to identify and address the issue causing the "The requested operation is invalid" error in your Teams Power App when working with date and time fields in SharePoint.

Best regards, IBHADIGHI