Receive data from external users

[Anonymous]

Hi,

I created a large flow, which works like this:

1. Trigger is submitting a custom form in powerapp by one of company workers. He types aprovers and customer emails. Submitted forms are stored in sharepoint list.

2. After all responsible people from our company approves, an email with pdf version of this form and agree/reject button is send to external customer (it is "send email with option" in flow

3. If customer agrees, I want to send him another email, where he can type his own unique purchase number. Then, I need to receive this number and update with it one specific column in sharepoint.

How can I receive this number? 

I have made simple power app for it but then I realized it is not that simple to share it with external customer. Moreover customers can be vary, and it has to work dynamically.

I was considering using forms, but I'm not sure how to implement this to be clear and explicit for many customers and then receive their response and not to mix them accidently if I will have many flows running.

Could you help me, please ?

[Anonymous]

At the end of your large flow, send the customer an email where you ask for the purchase number, then a create a new flow where the trigger is "When a new email arrives", then make the customer email you the purchase number, use dynamic content "body", and update the collumn in your SP-list. 

[v-litu-msft]

Hi @Anonymous,

There is no action in Outlook that could track the response of the sent emails.

I have seen a similar request from Flow Ideas Forum, please vote it at here:

https://powerusers.microsoft.com/t5/Flow-Ideas/obtain-user-response-status-for-outlook-invite-events...

Or you can use the Microsoft Form to send a survey which have columns named emails, unique purchase number, etc. 

After creating a new Flow with trigger When a new response is submitted of MS Form connector, according to the email address to update the SharePoint list.

Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

@v-litu-msft 

I was considering using forms, but I see it little too dangerous to mix customer answers - one can reply slower, one faster. 

If I want to refer to email address of customers who replied survey, to let flow be able to difference responses, I think the only option is customer has to type his email manually right ?

But also, If I need to create new flow with trigger "when new response is submited", how can I distinguish the exactly sharepoint list item which I want to update? It doesn't have to be last one.

Sorry If i'm not clear enough but this issue is following me for few days and I'm a little bit confused

[v-litu-msft · Accepted solution]

Hi @Anonymous,

You don't need worried about the user enters an error email address manually, the return value of MS Form has a field is Responders' email, it will get the email address who submit the survey.

Then you can use the Get items action of SharePoint connector to get the match (For example: EmailsAddress) item. Then update this item according to the return ID.

Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.