Power Automate Flow that gets user information from SharePoint and updates excel spreadsheet

Question

I am trying to create a simple flow, that will collect information when a user clicks on a button in a SharePoint site. Essentially all I need is the user who clicked the button email and date and time of the button click.

I would then like to update a excel spreadsheet with this information.

It seems like quite a simple flow, but I haven't been able to work it out, all help is greatly appreciated!

I have tried several different options, including searching far and wide for an answer but no solution.

Answer 1

You can use JSON column formatting to show a button in the SharePoint list view and then configure the JSON to run a specific workflow.

The specifics are too much for an answer here. The crucial bit in the JSON code is this command, which has the workflow GUID as a parameter.

"customRowAction": {
    "action": "executeFlow",
    "actionParams": "{\"id\": \"edfddddd-6bbd-483f-87a1-26fdc3264a34\"}"
},

You can find samples online, for instance in this article:

https://www.c-sharpcorner.com/article/use-json-formatting-to-create-button-and-trigger-power-automate-flow/