Unanswered

Problem inserting row in MySQL using Power Automate

(0) Share

Report

Posted on by Community Power Pla...

Hi,

Really looking for some help with this one as it could be massive if I get this corrected!

I have created a flow triggered from a PowerApps button that gets a text file from a sharepoint and then splits that text file into an array.

The items from the array are then meant to be inserted into the MySQL database. So far when I run the test of the flow I can see that it is inserting to the correct columns however, I keep getting the below error.

We can't update the value. The operation or its arguments aren't supported by the value.\r\n inner exception: We can't update the value. The operation or its arguments aren't supported by the value.\r\nclientRequestId: 83dc2a66-17b9-4977-9793-4601b1b8982b",

Help would be massively appreciated!

Categories:

Using connectors

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

Sutherland on at

Like (0)

Report

Re: Problem inserting row in MySQL using Power Automate

Good day MILNEAGE,

It's '\r\n' inner exception as you mentioned in your post where these '\r\n' character in your text file cannot be supported. Could you clear all these special character in your text file and try to import into SQL DB again.

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Re: Problem inserting row in MySQL using Power Automate

@Johnnyg Apologies for not responding I moved on from the issue as I could develop other parts but I am looking at it again and I am still getting the problem.

It appears as if when I split my variable it is adding this expression to the text string however when I removed what I thought was the troublesome data I am still getting the error.

Any other ideas ?

Was this reply helpful? Yes No