Unanswered

Send email, get reply and update excel

(0) Share

Report

Posted on by JustinasZ

Hi, i'm trying to make a flow that Gets info from Excel, send that information to certain user, and if that certain user is replied then reply text goes to excel certain column and row.

Done part is corrected with italic

Categories:

Building flows

I have the same question (0)

All responses (6)

Answers (0)

Sort by

eric-cheng 5,171 on at

Like (0)

Report
Copy link

Link copied!

Hi @JustinasZ ,

How is it sent to the user? Email or Approval task?

--------------------------------------------------------------------------
If I have answered your question, please mark my post as a solution
If you have found my response helpful, please give it a thumbs up

Connect on LinkedIn

Was this reply helpful? Yes No
JustinasZ 28 on at

Like (0)

Report
Copy link

Link copied!

For now its email, but whole idea is that system sends a email to user and he just replies( with cost center) and automatically updates excel with a data from replies

Was this reply helpful? Yes No
eric-cheng 5,171 on at

Like (0)

Report
Copy link

Link copied!

Hi @JustinasZ ,

You will need to create another flow with an email trigger.

1. Email trigger will filter emails and trigger flow based on the subject
2. Convert HTML body to text
3. Look for row in Excel
4. Update row

Keep in mind this approach is dependent on how the user responds to the email as it can break if they dont reply in the expected format.

--------------------------------------------------------------------------
If I have answered your question, please mark my post as a solution
If you have found my response helpful, please give it a thumbs up

Connect on LinkedIn

Was this reply helpful? Yes No
JustinasZ 28 on at

Like (0)

Report
Copy link

Link copied!

For now looks like this, issue is that i cant use your model because Subject doesn't change,

Whole flow right now made, with Invoices, for example you get a invoice with 10 rows, Every row as separate from each other and sends as new mail with info of certain groups for example price and etc., And I need if I replied to that specific one for that specific row something updates. Whole idea of project to made a excel which you update by replying to email, so you don't need manual insert cost center or any other parameter though excel, just answer emails that all.

Was this reply helpful? Yes No
eric-cheng 5,171 on at

Like (0)

Report
Copy link

Link copied!

Hi @JustinasZ ,

You can append something unique like an invoice number to the email subject when you send it e.g. Test1 - 1234

In the other flow, create the flow with Test1 subject filter. Extract the invoice number using the below expression whilst replacing the static text with the dynamic content for subject

@trim(last(split('Test1 - 1234', '-')))

Use the output in your Excel list rows in table odata filter.

Regardless, you will have issues with extracting the cost centre in the body of the replied email as the original email the user is replying to will muck up the response.

Could you create an Approval step instead?
-------------------------------------------------------------------------
If I have answered your question, please mark my post as a solution
If you have found my response helpful, please give it a thumbs up

Connect on LinkedIn

Was this reply helpful? Yes No
JustinasZ 28 on at

Like (0)

Report
Copy link

Link copied!

I can try approval step but I don't know how to collect info from Approval, it would be better because there you can Write selections which i don't need write again. But I really don't know how it would like on flow.

Was this reply helpful? Yes No