Hello,
I have two SharePoint lists - Submissions and Responses. I built a flow to
- collect response data (data coming from Outlook Adaptive card),
- create a record in the Responses table, and
- update the corresponding submission in the Submissions table by adding the Responses record to a multi-select lookup column called Reviews.
To accomplish this, I originally used the Update Item connector and tried updating the Reviews column with an array of IDs. This array is a combination of the existing items with the ID of the new record just created in Responses. The array was formatted as follows:
{
"Id": 1,
"Id": 2,
...
}
Derived from this solution: https://powerusers.microsoft.com/t5/Building-Flows/Updating-SharePoint-Lookup-Column-with-multiple/m-p/559065#M72985
Although the Update Item action succeeds, the Reviews column doesn't update with the new data. With no luck, I tried using the SharePoint Send HTTP Request action instead. I got this one to successfully update the Reviews column with records I manually created in the Responses table. However, it still won't link records that were created with the Create Item action that I'm using. The body for the HTTP POST request is in the following structure:
{
"ReviewsId": [1, 2, ...]
}
Reviews is the internal name of the column.
Any ideas as to why this Reviews column refuses to update? I've verified using additional queries that the data isn't updating to rule out any browser cache issues when looking at the list.
Thank you.
