Changing Item ID's to Item Display Name

(0) Share

Report

Posted on by AlexaRees

Hi, Everyone!

New to Power Automate here -

I've created a flow from Microsoft Planner to a SharePoint List, the trigger is when the Planner task is marked complete and the action is to create an Item in a SharePoint List.

The issue I'm running into is that the data for the Bucket and Completed By columns are populating as ID number's rather than the Bucket Title and Completed By user ID. This may be more of a Microsoft Planner question, but maybe someone knows how to code the ID to read the Display Value instead of the ID. I've included some screenshots below of the Flow and the way the SharePoint List reads.

Thanks for your help in advance!

I have the same question (0)

All responses (5)

Answers (1)

ScottShearer 25,254 Most Valuable Professional on at

Like (0)

Report

Re: Changing Item ID's to Item Display Name

@AlexaRees

Please see this post and the links that I provided.

Was this reply helpful? Yes No
AlexaRees 18 on at

Like (0)

Report

Re: Changing Item ID's to Item Display Name

Hi, @ScottShearer - Any idea what I'm doing wrong here? I'm not getting the option for the Display Name (or any user profile info) in the Dynamic Expression unless I add the action within the current action that includes the Get user Profile. When I add the Create Item action within the current action, the flow does not work.

Was this reply helpful? Yes No
Verified answer

v-bacao-msft on at

Like (0)

Report

Re: Changing Item ID's to Item Display Name

Hi @AlexaRees ,

Please refer to the following configuration:

Feel free to let us know if you have any questions.

Best Regards,

Was this reply helpful? Yes No
AlexaRees 18 on at

Like (0)

Report

Re: Changing Item ID's to Item Display Name

Hi, @v-bacao-msft - Thank you so much! That worked wonders. One more question I hope.

Now I need to get the Assigned To Display Name. Is that something I can accomplish in the same flow?

Was this reply helpful? Yes No
Nico_0710 171 on at

Like (0)

Report

Re: Changing Item ID's to Item Display Name

Hey,
I have the exact same problem. Did you managed to solve it @AlexaRees ?

Was this reply helpful? Yes No