SOLVED

PowerApps: Error Submitting a Form

Copper Contributor

Hello,

I am playing around in PowerApps trying to learn how to create forms that write back to an excel file. I was able to successfully do so for a few entries, but have come across this "Network error when using Patch function. The requested operation is invalid." Has anyone had trouble with this error and found a way around it? Thanks! 

 

zlasek_0-1689093632872.png

 

1 Reply
best response confirmed by zlasek (Copper Contributor)
Solution

@zlasek Are any of the excel columns formatted with specific format like Number / Date, etc?

 

If yes, make sure you are passing correctly formatted values to the excel column from your app.

 

Example: If column is formatted as a number and you are passing date value to it, it might not work and throw errors.


Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.

1 best response

Accepted Solutions
best response confirmed by zlasek (Copper Contributor)
Solution

@zlasek Are any of the excel columns formatted with specific format like Number / Date, etc?

 

If yes, make sure you are passing correctly formatted values to the excel column from your app.

 

Example: If column is formatted as a number and you are passing date value to it, it might not work and throw errors.


Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.

View solution in original post