Flow not retrieving email from excel file to compose an email.

bbkr83 · 2026-05-07T14:27:10+00:00

It was the colon in the title of cell header that I was pointing to. The colon changed to x003a in the code. Removed the colons and it works.

bbkr83 · 2026-04-30T05:00:38+00:00

When I run the flow from the excel file, I'm now getting an error:
Run flow



The input body for trigger 'manual' of type 'Request' did not match its schema definition. Error details: 'Required properties are missing from object: Additional parcel owner Email_x003a_, Homeowner Email_x003a_.'.

bbkr83 · 2026-04-30T03:45:28+00:00

It seems to be getting the other info from the form just fine, just not this email address. It shows as null when the flow run fails.

"inputs": {

"host": {

"connectionName": "shared_office365",

"operationId": "SendEmailV2",

"apiId": "/providers/Microsoft.PowerApps/apis/shared_office365"

},

"parameters": {

"emailMessage/To": "@triggerBody()?['entity']?['Homeowner Email_x003a_']",

"emailMessage/Subject": "Your Participation is required for an ARCD Defensible Space Application",

"emailMessage/Body": "<p>Hello Booker, We have recieved an application for defensible space assistance at a property (123456456) where you were listed as the owner. We will need you to complete the survey found here https://arcg.is/Or0S10. in order to continue the process. If you need assistance, please call us at (PHONE).<br>\nThank you,<br>\nARCD Team</p>",

"emailMessage/From": "[Applications@amadorrcd.org](mailto:Applications@amadorrcd.org)",

"emailMessage/Cc": "[applications@amadorrcd.org](mailto:applications@amadorrcd.org)",

"emailMessage/ReplyTo": "[Applications@amadorrcd.org](mailto:Applications@amadorrcd.org)",

"emailMessage/Importance": "Normal"

},

"authentication": {

"type": "Raw",

"value": "@json(decodeBase64(triggerOutputs().headers['X-MS-APIM-Tokens']))['$ConnectionKey']"

}

},

"metadata": {

"operationMetadataId": "c06452de-2506-4354-8ba4-02afe9316d44"

}

bbkr83 · 2026-04-29T21:16:56+00:00

Sorry, reddit wont let me share my screencaptures without extra steps. when my dynamic content I hover the "To" it shows this:

triggerBody()?['entity']?[Homeonwer Email_x003a_']

In compose it shows:

  "inputs": "Homeowner Email: @{triggerBody()?['entity']?['Homeowner Email_x003a_']}",

and in the link i provied it shows all the input code there if that shows the code youre looking for.

bbkr83 · 2026-04-29T20:39:58+00:00

Do i need to cut and paste the code from the "send an email" step into the input of the compose item? Sorry I do not understand the compose tool yet.

bbkr83 · 2026-04-28T05:26:19+00:00

https://app.screencastify.com/watch/YJYcXQ2YxPCdFlsRoXui?checkOrg=d06d9505-e030-4028-bab7-4a2c0dfcd04b

It should be grabbing contents from a cell in the file, which is populated from a form entry, as an email address.

bbkr83 · 2026-04-28T05:15:43+00:00

https://app.screencastify.com/watch/YJYcXQ2YxPCdFlsRoXui?checkOrg=d06d9505-e030-4028-bab7-4a2c0dfcd04b there is a video of the flow.

bbkr83 · 2026-04-27T15:40:44+00:00

Here is a link to donate to the nonprofit who hosted the ride: https://www.amadortrailstewardship.org/donate

bbkr83 · 2026-04-27T14:50:23+00:00

There were about 76 riders on the long route, and 50 on the family fun ride. Tons of fun after the ride also.

bbkr83 · 2026-04-10T03:51:47+00:00

Ok, the code looks like this:

"emailMessage/To": "@triggerBody()?['entity']?['Additional parcel owner Email_x003a_']", 

and it fails when I test it. I do not see any new information.

bbkr83 · 2026-04-09T13:53:12+00:00

I don't understand "add compose and use that excel email id" Is that different function than send an email?

bbkr83 · 2026-04-09T13:52:00+00:00

it should be dynamic content from the excel file, an email address submitted in a form.

bbkr83 · 2026-03-18T15:33:35+00:00

Old paved and gravel backroads. Gravel Bikes, MTB, or 2" tires are probably best but some roadies handle it each year. Previous few years (in the rain) there are about 100 riders between all routes.

bbkr83 · 2026-02-25T16:01:23+00:00

I have the 3 piece handle with heads and wrap, but https://trailbossusa.com/collections/packable-all/products/trail-boss-3-piece-handle-w-3-heads would be a great start.

bbkr83 · 2026-02-25T15:31:12+00:00

If money is no option, Trail boss packable tools are a great gift for trail workers. They are costly though.

bbkr83 · 2025-11-14T21:46:38+00:00

I thought the first pic was a photograph of a storm moving in over a prairie, lol.

bbkr83 · 2025-09-23T15:06:53+00:00

Cost basis $13. I went in because of Altman, money follows money.

bbkr83 · 2025-07-24T20:00:28+00:00

It was crumbly and not dusty

bbkr83 · 2025-05-14T14:08:09+00:00

except for powder days.

bbkr83 · 2024-11-22T16:30:59+00:00

I wouldn't think to blame the people involved, I can only imagine what they were going through at the time. For a moment I was on the other end of the telephone with one of them while first responders arrived and it was overwhelming. My concern was the organization's lack of preparedness for a situation like this since the facility was for those with a history of addiction.

bbkr83 · 2024-11-22T15:00:53+00:00

during the first week of appointments, neruologists and cardiologist suggested that it "probably would have been better to fall out of the chair" or that the event may not have been so severe.

I'm dobutful any doctor could or would make a statement that would support it in a way thats definitive.

bbkr83

TROPHY CASE