Get my profile

[Anonymous]

Hi Guys,

I am trying a simple thing in Flow which is when a row created in my SQL table then I have to get a notification when the column Employeename is equal to Get my Profile field employeename. But unfortunately I get this error. In 

{
  "error": {
    "code": "BadRequest",
    "message": "Parsing Select and Expand failed.",
    "innerError": {
      "request-id": "36955122-b1eb-43e3-9c80-d99dde8ea98f",
      "date": "2019-08-28T13:51:34"
    }
  }
}

I Know this is PowerApps community but in Flow community I can not upload pictures.

Thanks in advance!
 

[Jeff_Thorpe]

What is the value of EmployeeName?

[Anonymous]

It is the fullname of the user. I fill this Fields in powerapps by user().fullname

[Jeff_Thorpe]

The "Get My Profile" returns the profile of the user that is executing the Flow and the "select fields" is asking which fields you want to return from the profile. This needs to be the name of the standard fields like surname, department, country and etc. You are using dynamic content called EmployeeName which returns the employee's full name which is not a name of a field on the profile and that is what is causing the error.

What do want "Get My Profile" to return?

[Anonymous]

I will explain you more what my situation is. I have a table which is included the following columns ID, employeename, manager, flow etc.
I want when an employee add a new row then that the flow send the current user a mail and also a mail to the manager which is belings too.

For the column employeename I use User().fullname and for column Manager I use Office365Users.Manager(User().Email).Mail 

I want that this things automatically happens.  In attachment see you a photo of my FLow.

[Jeff_Thorpe]

The selected fields in the My Profile action isn't correct. It expecting the names of the profile fields that you want returned. The 'EmployeeName' dynamic content resolves to an actual user name and not a name of a field in the profile. For a quick test you can remove 'EmployeeName' and just type in country. The Flow should run and My Profile will return the country of the user executing the Flow.

[Anonymous · Accepted solution]

Thanks for your response! the problem was indeed the value of my column Employeename. when I changend the value instead of fullname to email adres then it works correctely.