Unanswered

Converting form response to text string

(0) Share

Report

Posted on by cjwwd2

Hello,

I have a flow set up that when a form is filled out and submitted, it triggers a flow that pulls the form data, then sends an email to our ticketing service with the form information in the body of the email.

I'm trying to get the sent from email to be the person who filled out the form (so it sets the ticket requester correctly in our ticketing portal), but the field for the email trigger (Outlook - Send an email (V2) ) gives me an error that you can't use the form response as dynamic content in the From (Send as) field; it only wants a text string.

Error: The 'inputs.parameters' of workflow operation 'Send_an_email_(V2)' of type 'OpenApiConnection' is not valid. Error details: Input parameter 'emailMessage/From' is required to be of type 'String/email'. The runtime value '"anonymous"' to be converted doesn't have the expected format 'string/email'.

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (0)

Pstork1 68,678 Most Valuable Professional on at

Like (0)

Report

Re: Converting form response to text string

It looks like your forms are setup so they can be submitted anonymously. Make sure the email of the person filling out the form is included in the details of the response or add a field in the form where they type in their email.

Even if you get that you will have an issue since you can't send an email as someone else unless you have "Send As" permission to their mailbox. For a full organization that's not practical. I would include the email of the send in the body of the email and find a way to get it from there for the ticketing system.

Was this reply helpful? Yes No
cjwwd2 2 on at

Like (0)

Report

Re: Converting form response to text string

Thanks, I was trying to set it up to send as the submitter so they are one that "submitted" the ticket to our ticketing service so we could ask questions/get clarification from them if needed.

Was this reply helpful? Yes No
Pstork1 68,678 Most Valuable Professional on at

Like (0)

Report

Re: Converting form response to text string

As I said, there are two potential issues. First, the settings for your form appear to be that anyone can fill out the form. So the form comes in as anonymous and the submitter is not included in the trigger or the details. You need to change the form so that only internal users (organization users) can submit the form. Or you need to add a question to the form where the user supplies their email.

Second, even if you do that you probably won't be able to send the email out as the user who submits the form. The flow will run in the context of the person writing the flow. In order to send an email as someone else that person will need send as permission to every mailbox that might be used to send the mail. In most organizations that isn't practical.

Was this reply helpful? Yes No