Forum Discussion

TMX_Consulting's avatar
TMX_Consulting
Copper Contributor
Jan 31, 2022

Convert Office User ID to Name

Friends,

 

I created a flow in Power Automate that copies tasks from Planner to Sharepoint. So far so good...

When listing the users assigned to tasks, he puts the User ID and I don't know how to convert it to Name. I need this conversion to create a Dashboard in Power BI.

 

Thanks!

Microsoft Flow
sharepoint

2 Replies

  • RobElliott's avatar
    RobElliott
    Silver Contributor
    Feb 01, 2022

    TMX_Consulting try using the Office 365 Users Get User Profile (V2) action. You could populate the input field with the User ID (or the user email) and then select the name for later actions from the dynamic content box.

     

    Rob
    Los Gallardos
    Microsoft Power Automate Community Super User

    • TMX_Consulting's avatar
      TMX_Consulting
      Copper Contributor
      Feb 01, 2022

      RobElliott 

       

      Thanks for the answer.

       

      When I use the Get User Profile (V2) to get the name of the creator of the task, it doesn't show an error, but when I do it with those responsible (assigned users) for the task, it shows an error.

       

       
       
      WorkflowOperationParametersRuntimeMissingValue. The 'inputs.parameters' of workflow operation 'Get_user_profile_(V2)' of type 'OpenApiConnection' is not valid. Error Details: The resolved string values ​​for the following parameters are invalid, they cannot be null or empty: 'id'

       Do you know how to help me?

Resources