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

Sharepoint Connector Problem - only showing first 20 items from Term Store

Only first 20 items from the term store are showing up in Sharepoint connector. I have confirmed this with multiple managed term store values. Only the first 20 values from the term store show up. So if you have more than 20 items in the term store as managed metadata tags, then none of the ones after the 20th one will be available to be selected from MS Flow.


Flow URL A:

Community Support Team
Community Support Team

Re: Sharepoint Connector Problem - only showing first 20 items from Term Store

Hi @PleaseHelp ,


I did the test on my side, and it is exactly the same as what you described. Only the first 20 items are displayed in drop-down list.

However, you could use Enter custom value to configure this field. If the value you are configuring in this action is a fixed value, it is feasible to manually populate the corresponding value.

What you need to do is get this value first, you could get this value in the following way.

  • Create a new item in the list, or an item that has been configured with the expected tag value, and get the item ID.




  • The field value is obtained by the item ID and using Get item action, then configure this value is in Update item action.



  • Considering that the corresponding item may be deleted, it is recommended to get this value first and then manually configure it in the field.



Please take a try.


Best Regards,

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

Helpful resources


Power Platform Online Conference

Join us for the first ever Power Platform Online Conference!


Incoming: New and improved badges!

Look out for new contribution recognition badges coming SOON!


New & Improved Power Automate Community Cookbook

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


Power Automate Community User Group Member Badge

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


Power Platform World Tour

Find out where you can attend!


Webinars & Video Gallery

Watch & learn from the Power Automate Community Video Gallery!

Top Solution Authors
Users online (6,159)