Change a value based on a response from ms forms

(0) Share

Report

Posted on by morgan_avila

My flow is triggered when an MS Forms response is submitted.

then I get the response details into an excel file (SharePoint)

I have a specific question (Multiple choice, six options) regarding a "Sector" if the answer is "X Sector," I want to automatically change to the leaders' email of that sector within the excel file. I've tried using the if expression, but it's not allowing that, for I don't know what reason.

Categories:

General topics

I have the same question (0)

All responses (4)

Answers (0)

ScottShearer 25,290 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

@morgan_avila

Please post screen shots of what you have now and I will suggest a fix.

Was this reply helpful? Yes No
ScottShearer 25,290 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

@morgan_avila

Please post screen shots of your Flow. That will make it much easier to assist.

Was this reply helpful? Yes No
morgan_avila 7 on at

Like (0)

Report
Copy link

Link copied!

Was this reply helpful? Yes No
morgan_avila 7 on at

Like (0)

Report
Copy link

Link copied!

basically, this is a request form, when they enter the Segment information, a specific approver is assigned according to the segment, the users don't have the approvers info, so I need to add an email depending on the response on the Segment question. I have 6 different segments and 6 different approvers:
i.e.:
EDS output: example@example.com
CS output: example2@example.com

etc etc

Was this reply helpful? Yes No