cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
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.

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
firstImage

Power Platform Online Conference

Join us for the first ever Power Platform Online Conference!

firstImage

Incoming: New and improved badges!

Look out for new contribution recognition badges coming SOON!

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

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

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 Solution Authors
Top Kudoed Authors
Users online (4,692)