First Flow - Getting error messages when trying to get properties from a file

(0) Share

Report

Posted on by MR-18030928-0

I am trying to write my very first flow and keep it simple. I will iterate it over time to get exactly what I want but for now getting it working is the first step.

The flow is simple:

When a file is created in a folder --> Get File Content --> Send an Email

The idea is that it will send the file as an attachment to the people in the settings. (I actually want to send a link to the site but that went wrong too so I'm keeping it simple for now).

The error is in the Get File Content section - the flow is triggered fine:

Action 'Get_file_content' failed: The 'inputs.parameters' of workflow operation 'Get_file_content' of type 'OpenApiConnection' is not valid. Error details: The resolved string values for the following parameters are invalid, they may not be null or empty: 'id'

And here is the code:

{
  "type": "OpenApiConnection",
  "inputs": {
    "parameters": {
      "dataset": "https://<SharepointAddress>",
      "id": "@triggerOutputs()?['body/ID']"
    },
    "host": {
      "apiId": "/providers/Microsoft.PowerApps/apis/shared_sharepointonline",
      "connection": "shared_sharepointonline",
      "operationId": "GetFileContent"
    }
  },
  "runAfter": {}
}

So what obvious thing am I missing?

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (0)

Sort by

Suggested answer

PowerDeveloperTP 453 on at

Like
a
(0)

Report
Copy link

Link copied!

Hello,

Yes, this is indeed very simple flow.

Could you please check if you are referring file identifier in get file content action. Error seems like it is not able to identify the file.

Also for sending this file as an attachement, you will have to to configure the attachment section with file content and name of the file with extension

Good luck with your first flow and welcome to the world of automation.

Thank you.

Like my answer? - Hit that Thumbs Up. Resolved the Issue? - Hit Accept as Solution.
This helps others find solutions to future issues!

Was this reply helpful? Yes No
MR-18030928-0 2 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi,

Thanks so much for taking the time to help.

My options don't look the same as yours, but I updated the identifier to the one that looks most likely:

This worked insofar as it didn't generate an error at this point, but now the e-mail does.

These are the settings I have, and again they don't quite look like yours:

Thanks again for your help!

Was this reply helpful? Yes No
Suggested answer

PowerDeveloperTP 453 on at

Like
a
(0)

Report
Copy link

Link copied!

Hello,

Thanks for the details!

Firstly, the trigger you have used, "When a file is created in a folder" is deprecated due to inefficiencies in how it monitors folder changes. It is replaced by newer, more efficient triggers that focus on file properties rather than entire file contents, such as "When a file is created (properties only)" or "When a file is created or modified (properties only)" if you want to specifically look for any folder you can mention in Folder location

And the attachments we need to configured the file name with extension and content out put from Get file content

{

"Name": "@triggerBody()?['{FilenameWithExtension}']",

"ContentBytes": "@body('Get_file_content')"

}

Please let me know how it goes.

Thank you.

Like my answer? - Hit that Thumbs Up. Resolved the Issue? - Hit Accept as Solution.
This helps others find solutions to future issues!

Was this reply helpful? Yes No