cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Advocate II
Advocate II

Receive data from external users

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 ?

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Community Support
Community Support

Re: Receive data from external users

Hi @golabem,

 

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.

Annotation 2019-09-10 182758.png

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.

View solution in original post

4 REPLIES 4
Highlighted
Advocate II
Advocate II

Re: Receive data from external users

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. 

Highlighted
Community Support
Community Support

Re: Receive data from external users

Hi @golabem,

 

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.

Highlighted
Advocate II
Advocate II

Re: Receive data from external users

@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

Highlighted
Community Support
Community Support

Re: Receive data from external users

Hi @golabem,

 

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.

Annotation 2019-09-10 182758.png

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.

View solution in original post

Helpful resources

Announcements
Power Platform ISV Studio

Power Platform ISV Studio

ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.

Upcoming Events

Experience what’s next for Power Automate

See the latest Power Automate innovations, updates, and demos from the Microsoft Business Applications Launch Event.

Community Conference

Power Platform Community Conference

Find your favorite faces from the community presenting at the Power Platform Community Conference!

Users online (6,077)