Showing results for 
Search instead for 
Did you mean: 
Advocate I
Advocate I

Updating SharePoint Managed Metadata Coluumn with dynamic data

Hi everyone

I have a flow that is setting the value of columns on documents in SharePoint based on the folder path of the document.  Each part of the folder path is set as a variable and then these variables are used to set the column values.  This works well but I'm having trouble setting a managed metadata column to show the financial year.  I'm following the instructions here and have got to the step where I query /_vti_bin/TaxonomyInternalService.json/GetSuggestions:


This seems to be setup in the right way according to the link but when the flow runs this step comes up with an error saying BadGateway.  There are no other error details so I can't see exactly why this has failed.

Has anyone tried doing this and if so have you come across this error before?  Any assistance would be gratefully received.

Thanks in advance for your help.

Super User II
Super User II

Re: Updating SharePoint Managed Metadata Coluumn with dynamic data

Hi @gj84uw 


"Bad Gateway" is a generic error that is telling you that there's something wrong with the request. 


Try the following. Select a test set of values for each of your variables and use an external app, like Postman, to test your calls. This will provide you more details on where the error is. When your requests are working correctly, then you can paste it back here and replace the static values with the variables.


Makes sense?


If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.


Helpful resources


August 2020 CYST Winners!

Check out the winners of the recent 'Can You Solve These?' community challenge!


Experience what's new for Power Automate

Join us for an in-depth look at the new Power Automate features and capabilities at the free Microsoft Business Applications Launch Event.


Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021


Power Automate Community User Group Member Badge

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

Users online (4,474)