cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ez1138
Level: Powered On

Planner to Flow to SharePoint, ID Choice Only

Pulling data in to SharePoint from Planner seems to have a choice for ID only for certain pieces.  I did it a couple years back but forgot how to create another column in SharePoint or whatever to convert the ID to the actual name/description of the item in that column (calculated or otherwise, not sure what the current best practice is).

 

Any insight would be appreciated.

3 REPLIES 3
Community Support Team
Community Support Team

Re: Planner to Flow to SharePoint, ID Choice Only

Hi @ez1138 ,

 

Could you please explain more details about your requirement?

Do you want to Pulling data in to SharePoint from Planner?

How to understand the "seems to have a choice for ID only for certain pieces" that you mentioned.'

 

Best regards,

Alice       

 

Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Highlighted
ez1138
Level: Powered On

Re: Planner to Flow to SharePoint, ID Choice Only

Hi, for many of the fields, it just shows ID and not the detail/name of the planner field.  I've added 3 screen shots.  Regardless if I make the next step of the flow to Outlook, SharePoint or any other spot, only ID is sent over and not the name (because it doesn't seem to be a choice).  Historically we had to create a hidden field for ID and another field and have the new field lookup the ID.

 

flow1.pngflow2.pngflow3.png

ez1138
Level: Powered On

Re: Planner to Flow to SharePoint, ID Choice Only

Hi, reading another post I saw something about using the "List..." function which allowed me to see the buckets and plans.  For some reason it added one entry per bucket.  I'm sure there's a simple solution there.  Not sure how to do it.

 

Also, what the best way to be able to show the value of the individual/person under the "Assign To".

 

flow5.pngflow4.pngflow6.pngflow7.png

Helpful resources

Announcements
thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

firstImage

Incoming: New and improved badges!

We've given our badges an overhaul and also added some brand new ones!

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

sixthImage

Power Platform World Tour

Find out where you can attend!

seventhimage

Webinars & Video Gallery

Watch & learn from the Power Automate Community Video Gallery!

Top Kudoed Authors (Last 30 Days)
Users online (4,968)