Unanswered

Get User Details from 'When a HTTP request received' trigger

(0) Share

Report

Posted on by ch38

Hi all,

Current state: I have an MS Form with a single response option where submission triggers a Power Automate flow. The flow identifies the next available work item within an Excel spreadsheet, updates the work item in the Excel so it is assigned to the user along with the allocation date and time, and then sends the user a Teams message with details of the work item and some other information for how they can complete the work item. This works perfectly well.

Possible Future State: I am hoping to improve the end-user experience where the user simply clicks a button on a SharePoint page to trigger the Power Automate flow to do all the same allocation and notifications. I cannot work out how to get the details of the user who selects the SharePoint button even though all users within the organisation are logged into their Microsoft/O365 accounts. We do not want to change to using MS Lists.

Any suggestions very welcome.

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (0)

Expiscornovus 33,195 Most Valuable Professional on at

Like (0)

Report
Hi @ch38,

Have you created the button with column/list formatting?

If that is the case you can use the '@me special string' value in a custom parameter called emailaddress. When that custom parameter is added you can retrieve it via the below expression:

triggerOutputs()['queries']['customparameter']

Below is an example

1. The outputs would look like the below.

2. Below is an example of json which can add such a button with emailaddress & currentweb query parameters.

{ "$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json", "elmType": "button", "style": { "border-radius": "5px", "margin": "5px 0px", "padding": "0px", "visibility": "visible" }, "attributes": { "class": "ms-bgColor-themePrimary" }, "children": [ { "elmType": "a", "txtContent": "E-Mail Me", "style": { "text-decoration": "none", "padding": "10px 0px", "width": "100%" }, "attributes": { "href": "='https://WhenarequestisreceivedGETurl&emailaddress=' + @me + '&currentWeb=' + @currentWeb", "target": "_blank", "class": "ms-fontColor-white" } } ] }

More detailed steps can be found in this blog I have written about this same approach:

https://www.expiscornovus.com/2023/01/20/e-mail-me-button-on-page/

Was this reply helpful? Yes No
ch38 on at

Like (0)

Report

Thanks for responding! Can the column/list formatting you mentioned be applied to Excel or only MS Lists? The link you sent seems to be about MS Lists formatting but we use Excel. I'm working beyond my skillset here with HTTP triggers so I appreciate your help.

Was this reply helpful? Yes No