Flow runs succesfully, but no data is written to Excel

(2) Share

Report

Posted on by CU05080624-2

Hi,

I am building a flow that extracts data from unstructured e-mail and writes the data to Excel.

The flow runs successfully, but no data is written to Excel.

It might have to do with the table in Excel, but I don't know...

How can I troubleshoot the flow?

Screenshot 2024-07-10 at 10.47.50.png

Thank you in advance!

Categories:

Using flows

I have the same question (0)

All responses (8)

Answers (0)

Sayan 818 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hey @MP-68

can you please share the unstructured e-mail data so that I can check on it?

------------------------------------------------------------------------------------------------------------------------------
If my suggestion helped you, please give it a Thumbs up 👍 and Mark it as a Solution 🤖 so that it can benefit others in the community.

Thanks,
Sayan Patra
RPA Developer

Was this reply helpful? Yes No
CU05080624-2 on at

Like (0)

Report
Copy link

Link copied!
Hi Sayan,
Thank you!

Here is a sample e-mail:

Sent from (Aarhus Universitet - Webshop)at 2021-08-16T17:14:06 Din AU Webshop ordrebekræftelse
Hej Svendsen
Tak for din ordre hos AU Webshop. Hvis du har:
Valgt afhentning som forsendelsesmetode, kan du hente din ordre, når du får en mailnotifikation herom.
Valgt Post Nord som forsendelsesmetode, vil din ordre blive sendt indenfor et par dage.
Købt et produkt til download, klik da på linket i produktoversigten herunder, for at downloade din fil.
Købt et virtuelt produkt (f.eks. en licens), vil dette blive sendt til dig pr. email.
Du vil modtage en faktura, når din ordre er blevet behandlet.
Såfremt der er betalt gennem DIBS (betalingskort), trækkes pengene på din konto når du modtager fakturaen.
Du kan se status for din ordre ved at logge ind på din konto.
Hvis du har spørgsmål til din ordre, kan du finde kontaktmailen for de enkelte
produkter i produktoversigten herunder..
Din ordre #WO0912134679793
Placeret den 16. aug. 2021 17.11.07
Faktura information
K
Produkter Stata16
SKU: Stata 16-AU
tal Pris 1 300
Bemærk: Licensen købes for et år af gangen og udløber d. 31/08 hvert år. Du vil modtage din licens senest en hverdag efter dit køb. Vær opmærksom på at licensen som standard sendes til din studiemail (post.au.dk).
Kontaktemail: webshop.bss@au.dk Subtotal

Was this reply helpful? Yes No
CU05080624-2 on at

Like (0)

Report
Copy link

Link copied!

Also, here is a sample of the parsed JSON:

{
"response": {
"Order number": {
"value": "WO00234513465",
"type": "string"
},
"Customer name": {
"value": "Aa-modo Dhoj Writgua",
"type": "string"
},
"Customer ID": {
"value": "au544115031",
"type": "string"
},
"Item ordered": {
"value": "Stata 16",
"type": "string"
}
}
}

Was this reply helpful? Yes No
Sayan 818 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hey @MP-68
can you please share that what you have written inside add a row into a table?

Was this reply helpful? Yes No
Hannahn 18 on at

Like (0)

Report
Copy link

Link copied!

Hi how i can solve this problem

Was this reply helpful? Yes No
CU05080624-2 on at

Like (0)

Report
Copy link

Link copied!

Here are the settings.
I am not sure why the library and table has these inputs, as I chose them via a drop down and everything looked fine. When saving and going it looks like this - I guess this is intentional?

Was this reply helpful? Yes No
Sayan 818 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hey @MP-68

Click on Change Connection and Create a new connection and use that connection.

Thanks,
Sayan Patra
RPA Developer

Was this reply helpful? Yes No
CU05080624-2 on at

Like (0)

Report
Copy link

Link copied!

Like this?

Was this reply helpful? Yes No