Get name of user who ran the Flow and add to Excel

[Gmma99]

Hi all, 

I'm using a Flow which is activated from a Teams message. The message user, message content, and today's date go into an Excel sheet.

I'd like to pull in the name of the person who triggered the flow, too. I thought this might be  one of the Dynamic Content items but I don't see anything obvious. I tried 'invokeName' but the Excel column remained blank after the flow finished running. 

I've included a screenshot of the Flow Teams fields. Everything else about the Flow runs perfectly and all other info we need comes in to the Excel sheet fine. 

Thank you!

Emma

 

[Expiscornovus]

Hi @Gmma99,

You could use an expression to retrieve the From User DisplayName field (Sender User DisplayName) for that Saved by field if it doesn't show up in your list of dynamic content fields.

Edit: I see you were already using the Sender User DisplayName in the Staff Name field. Surely that is the person who triggers the flow, correct?

And if so, you can just search for that field in your dynamic content list and don't need to worry about an expression.

Below is an example of that field in a compose action (if the Sender Display Name doesn't show up in the dynamic content field list):

triggerBody()['entity']['teamsFlowRunContext']['MessagePayload']['From']['User']['DisplayName']

[Gmma99]

Thanks so much @Expiscornovus for your help. 

It's not always going to be the user who wrote the message as the same person who triggers the flow. It's a Team where there are 50 users trialling a piece of software. As they raise issues or beta findings, the support team would like to save those messages centrally (and avoid copying and pasting into an Excel). So nearly there 🙂

[Expiscornovus · Accepted solution]

Hi @Gmma99,

You are correct, I was pointing to the wrong field. My bad.

In that case you could use this expression instead. That should be the person who is triggering the flow.

triggerBody()['entity']['teamsFlowRunContext']['From']['Name']

[Gmma99]

@Expiscornovus you've saved me hours! Thank you! This works a treat 🙂