Unanswered

Trying to create an automate flow for SharePoint list

(0) Share

Report

Posted on by ashishashford

I have a SharePoint list (below) which I am trying to make use of for creating an automate flow.

This list has a flow triggering button in each row "Mov to O365". My requirement is that when user clicks on "move to O365". Only if his email address matches the email address in adjacent row on which he clicked, email should be triggered as "YOU ARE THE OWNER OF THIS MAILBOX" or else "YOU ARE NOT THE OWNER OF THIS MAILBOX". I have already created a flow to trigger the email to the person who triggers the flow but i am not able to achieve the above condition.
Example: If the user who clicked on Move to O365 has email address: a.com and if the row adjacent to it has a.com email address in the "EmailAddress" column then email should trigger stating: "YOU ARE THE OWNER OF THIS MAILBOX"

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (0)

RobElliott 10,428 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!
@ashishashford I would do it a different way and only display the button if the owner is the same as the current logged in user. So in the image below I am logged in to Office 365 as rob.d.elliott99 so as that email address is shown in the Owner column the button is visible, but for the other columns it is hidden:

The JSON to conditionally display that button is as follows and it's the visibility line that's important:

{ "$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json", "elmType": "button", "txtContent": "Move to O365", "customRowAction": { "action": "executeFlow", "actionParams": "='{\"id\":\"50097cde-b800-4c6c-ade9-95be7574f4e5\", \"headerText\":\" ' + [$Title] + '\",\"runFlowButtonText\":\"Go\"}'" }, "style": { "background-color": "#cf000f", "color": "white", "border-radius": "10px", "visibility": "=if(([$Owner]==@me), 'visible', 'hidden')" } }

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
ashishashford 3 on at

Like (0)

Report
Copy link

Link copied!

Wow. Thanks for taking initial stab at this. I must say you are really helpful and that's the first thing I tried doing but gave up. I initially started with idea of hiding the BUTTON for non-owner but it didn't work well so I thought to design in a way that only owner will and should receive appropriate email. Now with your help, I went back to original idea but even then it doesn't work. Maybe i am missing something.

{
"$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json",
"elmType": "button",
"txtContent": "Move to O365",
"customRowAction": {
"action": "executeFlow",
"actionParams": "='{\"id\":\"cf4dc7f5-b272-4362-b493-dcf46a75b4ca\", \"headerText\":\" ' + [$Title] + '\",\"runFlowButtonText\":\"Go\"}'"
},
"style": {
"background-color": "#cf000f",
"color": "white",
"border-radius": "10px",
"visibility": "=if(([$EmailAddress]==@me), 'visible', 'hidden')"
}
}
I am logged in as myself but the button doesn't show up against my email address

Was this reply helpful? Yes No