I am trying to dynamically add content to a Quick Links web part in sharepoint using Power Automate. I've confirmed that I am able to add a quick link to the web part by manually hard coding the https payload. Now to try and make it dynamic..
Here's what I've done so far:
Data for the new quick link comes from an email trigger
(some other unrelated actions)
Send a GET request to Sharepoint to get the latest Quick Links
(For reference, the returned JSON will look something like this: /"items[0].title/":/"something/", with items[0] 1 2 etc representing the links. The goal is to find the highest number so we can dynamically add n+1 in the payload.)
Parse JSON from the GET request
Create a string variable 'Quick Links' which has the relevant parsed JSON
Create an integer counter variable
Create a Do Until loop that increments the counter
I'm stuck at the Do Until loop. My parameters are set to 'Quick Links' not contains 'items[0]' and every time it only runs one loop before exiting as a success. I even tried setting 'Quick Links' to just a constant string that says 'items[9] and it still only runs one time. I guess my question is how the heck do I do substring or string comparisons in a Do Until loop???