Sharepoint List Trigger not working

[trishy0229]

I am really struggling here and have tried everything!

I set up a manual trigger flow and when I test it works fine.

When I attach the flow to a list using the JSON code I cannot get the flow to work. I just get a message that says trigger error.

Help

Trisha

[sudharsan1985]

Hi @trishy0229 

Can you please detail out the steps that you had done? If your flow's logic is simple with few actions, can you start associating the flow with the list triggering action and then test it?

[trishy0229]

Hi! Here is how I set up the flow, it is pretty simple.

When I run the test everything is good

When I go to where I put the trigger button in my sharepoint list that is when I get the error...

This is the JSON for the button I used

{
"$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json",
"elmType": "button",
"customRowAction": {
"action": "executeFlow",
"actionParams": "{\"id\": \"36348113-a063-4ced-9fe2-64a9fb1e427f\"}"
},
"attributes": {
"class": "ms-fontColor-themePrimary ms-fontColor-teal"
},
"style": {
"border": "none",
"background-color": "transparent",
"cursor": "pointer"
},
"children": [
{
"elmType": "span",
"attributes": {
"iconName": "ParkingLocationMirrored"
},
"style": {
"padding-right": "6px"
}
},
{
"elmType": "span",
"txtContent": "Push to EVP"
}
]
}

Thank you!

[sudharsan1985]

Hi @trishy0229 

I think the 'Manually trigger a flow' is causing the problem. When I created a flow with a manual trigger and add a text to capture the comments, the flow was triggered from SharePoint List, but it didn't ask for any comments and also when I check the status, it shows something wrong with the template expression.

Unable to process template language expressions in action 'Get_items' inputs at line '1' and column '2208': 'The template language expression 'json(decodeBase64(triggerOutputs().headers['X-MS-APIM-Tokens']))['$connections']['shared_sharepointonline']['connectionId']' cannot be evaluated because property 'X-MS-APIM-Tokens' doesn't exist, available properties are 'Connection, Accept, Accept-Encoding, Accept-Language, Host, Referer, User-Agent, origin, sec-fetch-site, sec-fetch-mode, sec-fetch-dest, Content-Length, Content-Type'. Please see https://aka.ms/logicexpressions for usage details.'.

I created an instant flow with the trigger as 'SharePoint - For a selected Item'

Then I created a text input and add a 'Get Item' action on the same list with the 'ID' from the trigger.

I have used your JSON with the flow-id updated to mine and the flow triggered successfully. See the screenshot below. Also, checked the status of the flow and it ran successfully. Please try it out and let me know.

Below are some useful links you can get some information on running flow from SharePoint Lists.

https://michalguzowski.pl/how-to-trigger-microsoft-flow-in-sharepoint-list/

https://wonderlaura.com/2018/07/18/button-in-sharepoint-list-to-trigger-microsoft-flow/

Hope it helps, please like it or mark it as a solution if it resolves your clarification or issue
-Sudharsan K...

[RobElliott]

@trishy0229 whenever you are triggering your flow from a JSON button in a SharePoint list then the trigger in the flow must always be For a selected item.

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.

[trishy0229]

Thank you! I can now get the button to open the flow window and run successful.

When I add the action to send an email I get an error on that step now.

[sudharsan1985 · Accepted solution]

Hi @trishy0229 

I too experienced the same error when I tried with the existing connection to the email. Make sure on the flow details page, there are 2 connections, one for SharePoint and other EMail like the screenshot below.

Also, when you try to trigger the flow from SharePoint list after adding the mail connection, it should ask you to confirm the permission for the first time like the screenshot below.

If the above is confirmed, then your flow should work fine. I had tested the same scenario, got the same issue, and then resolved by using the above method. Please try and let me know.

Hope it helps, please like it or mark it as a solution if it resolves your clarification or issue
-Sudharsan K...

[trishy0229]

Thank you so much!

Trisha