Is there a way to send an email via Flow that in any way can update a column in SP through their response?

[MikeRooker]

I had been able to make a Form using Forms and created a Flow that can send the responses back to a table.
However, I wanted to have the responses sent back to the appropriate row of a list(table) relative to who filled it out but I can't find a way to tie in the form fillers ID. So right now, Flow is writing responses to new rows on the list (table) and not the ones it should be associated with. Is there a way around this?

• I've thought about parameters added to the form but I don't think there is a way.
• I've thought of creating a separate list(table)where Flow would send the form responses to and then create a lookup from the original table. I can;t use the email address since they are more than one email responders per row.
• I can't seem to figure out how to use Adaptive Cards to make this work,

This was all so easy with InfoPath and SP Designer. 😞

Thanks in advance for any help.

[edgonzales]

@MikeRooker 

Hey there - In your table, does each responder have their own row?  If that's the case, could you use a Get Rows type action and filter off of the form-filler's ID?  This would give you the ID of the row to use in a subsequent Update Row step.

Let me know if you think that will work.

-Ed

If you liked this reply, please give it a thumbs up! If this reply has answered your question or resolved your challenge, please consider marking it as a Solution. This helps other users find it more easily via search.

[MikeRooker]

Hello @edgonzales , thank you.

Yes each responder does have their own row, however how would I tie that in to another list when of course their Row ID's wouldn't match? So I suppose I'm presented with 2 challenges:

1) See if a row already exists in designation list and

2) if it does exist then update it.

But it brings me back to "how would I tie that in to another list when of course their Row ID's wouldn't match?"

Thank you for your response.

[edgonzales]

@MikeRooker 

How big are the lists?  I wonder if it would be a good idea to keep an aggregate list with the user and the list name, search that and direct the responses to the appropriate list...kind of like a traffic cop or a switchboard.

There might be other ways, but that's just one that comes to mind.

Let me know.

-Ed