Jul 11 2023 09:43 AM
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!
Jul 12 2023 03:04 AM
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.
Jul 12 2023 03:04 AM
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.