Store error messages and location in database

(0) Share

Report

Posted on by TelmoERF96

170

Hello everyone,

In my flow I am capturing whenever an error occurs and storing it in a list this way

And when I expand each item on the list I get something like this, like this I can only insert the location into the table

I am using a For Each to insert each line of the list into my table in SQL Server this way

But this way I only insert the Location, how can I manipulate the Error so I can insert both the Location and the Error Message?

Thanks in advance,

Telmo Ferreira

Categories:

Power Automate Desktop

All responses (3)

Answers (1)

Sort by

Verified answer

Agnius Bartninkas Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

The %Error% variable that you get via the Get last error action is actually an object and you can access the values in it as properties of the object.

So, if you have it as %CurrentItem%, you can access the name of the sub-flow as

%CurrentItem['SubflowName']%, the action index as %CurrentItem['ActionIndex']% and the message itself as %CurrentItem['Message']%.

However, I would suggest using Replace text on the message to replace newlines (enabling regular expressions and using \r?\n as the pattern) with an empty string or a whitespace. It might be that the newlines are causing issues with your SQL insert.

-------------------------------------------------------------------------
If I have answered your question, please mark it as the preferred solution. If you like my response, please give it a Thumbs Up.

I also provide paid consultancy and development services using Power Automate. If you're interested, DM me and we can discuss it.
UshaJyothiKasibhotla 225 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

use a query as following

Insert into Table name (coloumnname1,coloumnname2)
values('value1',value2)

Here coloumn names and values must be changed as per your Input file

Hope this helps
Usha.
TelmoERF96 170 on at

Like
a
(0)

Report
Copy link

Link copied!

@Agnius I used your first suggestion, it worked perfectly for what I intended

Thank you