Answered

When entering data into an sql table an extra enter is added to the values

(0) Share

Report

Posted on by gan

Hi all,
I have a problem, I made a webscraper with powerautomate desktop and I need to enter the collected data into an sql table, however when I do this, it seems to add an enter after the values. You are unable to see this just by looking at the table, however if you try to search for a certain value in the table it will only find it if you put the second quotation mark on the next line.

Does anyone know of a way to solve this? This issue is causing quite some trouble as it stops powerapps from recognizing the items that where entered through the RPA.

Categories:

Power Automate Desktop

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Verified answer

Unknown geen idee 1,757 on at

Like (1)

Report
Copy link

Link copied!

Dear Gan,

Maybe a useful suggestion to run the scraped data first through a 'trim' or similar action ... basically any action by which you can 'convert' your scraped data to a clean string to use into your sql table.
I have never encountered such a situation in PAD so I am not sure what the exact action should be, but I am sure there is something suitable.

Happy flowing,
Koen

Was this reply helpful? Yes No
gan 28 on at

Like (0)

Report
Copy link

Link copied!

Thank you, using a trim action actually resolved the issue.

Was this reply helpful? Yes No