Is it possible to build a dictionary, and then perform an actual action (such as set field value) on every item in that dictionary?
The Objective - I have a list lets say"Test List" (for simplicity let's say it has 4 columns) and i am running the workflow on item 1
Now when Cost field is updated on item ID 1, the lookup cost will change for items ID 3 & 5, but the calculated fields in 3 & 5 will not update until the items are modified in some way.
Solution so far - So what i have done is Create a string variable "domain/site/_api/web/lists('test list')/items?$filter=Lookup on ID eq '([%CurrentItem:ID)'
to create my call to "domain/site/_api/web/lists('test list')/items?$filter=Lookup on ID eq '1'
which when i count returns 2 items. I build the dictionary with these 2 items
The Problem - Now I have seen many posts showing how you can iterate through that dictionary to get the values out of it, and then log them in a variable you can then use in to log to history or send an email. However i want to actually do something to those items in the dictionary such as set a 5th column "say date modified" to today in order to update the calculated field.
once my dictionary is built, is it possible to, for instance count my dictionary items (which will equal 2 in this case, this i have already achieved) to create my loop, then
First Loop Get next ID from dictionary > (3) update column 5 with today's date(just for example doesn't have to be a date just something to make it update), in the item with ID (3) Second Loop Get next ID from dictionary > (5) update column 5 with today's date in the item with ID (5)
I have also thought about doing this through update item in the loop, or If lookup ID = CurrentItem:ID but i have stumbled into problems there. I raised another question around using "IF" and "Update Item" as it is really a different question and it would be useful to learn if either method is possible and how to perform each method separately.
Thanks in Advanced