Update Owner Row based on condition (MS Form)

(0) Share

Report

Posted on by md7

232

Hi all,

I have a MS form that users fill out. One of the questions in the form is which the users select what area of interest they're interested in.

I've created a flow to add the form details to a table in dataverse.

Based on the answer to the question, I'd like to assign specific admins to be the owner of that newly added row.

I understand that a switch is potentially needed for this. I have used switches before but I'm unsure how to update the row to assign the correct admin based on the answer to the question.

How would i be able to do this?

Thanks!

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (1)

Sort by

RobElliott 10,505 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@MD7 Add a string variable early in the flow which will later hold the email address of the relevant admin. For the On field in the switch you should select the question about the area the submitter was interested in. Inside each case you'll need to add a Set variable action, select the variable and for the value field type in the address of the admin. Finally oputside the switch add a dataverse update a row action and for the owner column select the variable.

Rob
Los Gallardos
If I've answered your question or solved your problem, please mark this question as answered. This helps others who have the same question find a solution quickly via the forum search. If you liked my response, please consider giving it a thumbs up. Thanks.

Was this reply helpful? Yes No
md7 232 on at

Like (0)

Report
Copy link

Link copied!

Hi Rob, Thanks for the reply.
I'm not quite sure how to string variables. Are you able to go into a bit more detail to do this?
Thanks.

Was this reply helpful? Yes No
Verified answer

Linn Zaw Win 2,996 on at

Like (1)

Report
Copy link

Link copied!

@MD7

At the beginning of the flow, you can initialize a String variable as in the screenshot below.

Based on the Area of Interest, you can use a Switch statement to set the variable with the owner value if you have the GUID of the specific admins. (I have a blog post with more details on how to set the lookup column value).

Instead of adding the form details to a table in Dataverse and updating the owner later, you can set the owner field in the same Add a new row in Dataverse step with the string variable set in the Switch statement. (please refer to the screenshot)

PS: If you don't have to GUID of the specific admins and if you need to get it dynamically (from email address or something else), it can be a bit more complex than this sample flow.

Was this reply helpful? Yes No