Forum Discussion
mdcastorena
Apr 30, 2022Brass Contributor
Dynamically update Term store values based on SQL Server database updates
Hi, I have a SQL Server database living on a virtual machine hosted in Azure and am trying to connect SharePoint to it so I can dynamically update the term store based on records added to a certain c...
SteveKnutson
Apr 30, 2022MVP
mdcastorena I was looking at how to do this recently and had a different approach that might be worth considering. Rather than using a PowerApp, use a script to read data from SQL and then update the Term Store using either the Graph API or PnP PowerShell
TermSets can be updated using Graph API Create term - Microsoft Graph v1.0 | Microsoft Docs
You can also use PowerShell to update the Term Store Set-PnPTerm | PnP PowerShell
- Apr 30, 2022Nice. Guess you could technically build an app to do this in conjunction with some flows. Or create a custom connector as well.
Wish I had stumbled across this previously. I may have to go back and add something to my term store ;).