Answered

Power Automate does not send e-mail triggering from a button on a PowerApps form of a Sharepoint List

(0) Share

Report

Posted on by AAndras

Hello, I made a PowerApps Form to create or midify items in a Sharepoint List. I placed a button on this Form which triggers a Power Automate Flow (Send_an_email_(V2)). This flow should send e-mails and strat Approvals.

When I test the flow manually feeding the required inputs instead of PowerAPps form it runs without problem. Great. But when I use button on the Form in the SharePoint list it comes bcak with the following problem:

* Send_an_email_(V2) action:

"Unable to process template language expressions in action 'Send_an_email_(V2)' inputs at line '0' and column '0': 'The template language expression 'json(decodeBase64(secrets('X-MS-APIM-Tokens')))['$connections']['shared_office365']['connectionId']' cannot be evaluated because property 'shared_office365' doesn't exist, available properties are 'shared_sharepointonline, shared_sendmail'. Please see https://aka.ms/logicexpressions for usage details.'."

* Approval:

"InvalidTemplate. Unable to process template language expressions in action 'Start_and_wait_for_an_approval' inputs at line '0' and column '0': 'The template language expression 'json(decodeBase64(secrets('X-MS-APIM-Tokens')))['$connections']['shared_approvals']['connectionId']' cannot be evaluated because property 'shared_approvals' doesn't exist, available properties are 'shared_sharepointonline, shared_sendmail'. Please see https://aka.ms/logicexpressions for usage details.'."

I use my comany account. These actions working well eg when I made approval flow for a document library.

I've already removed and readd the connection, but it not helped on me

What do I miss here?

Thanks

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Sort by

ScottShearer 25,290 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

@CsaszarZsomle

Please post a screen shot of your Flow as well as screen shots of how you call the Flow from Power Apps.

Was this reply helpful? Yes No
AAndras 12 on at

Like (0)

Report
Copy link

Link copied!

Attached the printscreens of the flow and where I call it from the PowerApps:

And this is the script of the PowerApps step from the flow:

Was this reply helpful? Yes No
Verified answer

Pstork1 69,244 Most Valuable Professional on at

Like (2)

Report
Copy link

Link copied!

I assume you are trying to send an email to the maker of the app, which is why you are trying to get the account from the connection. When you trigger a flow from Power Apps it runs in the context of the user who presses the button, not the maker of the app. That's why referencing connections won't work. I would suggest passing the email of the user as a parameter to the flow. You can get the email address in Power Apps using User().Email. Then you won't have to try to extract it from the connections.

Was this reply helpful? Yes No
AAndras 12 on at

Like (0)

Report
Copy link

Link copied!

In PowerApps I used this : paQUOTE_Approval.Run(DataCardValue20.Text*1;User().Email)
than in the Flow I set this e-mail as Sender and it was working. Surprisingly the Approval worked w/o any issue.

Thanks a lot

Was this reply helpful? Yes No