This one is driving me nuts.
I have a daily reporting snapshot feeding into an object. I am trying to get a flow to update Account records based on the Accounts captured in the snapshot.
Here is the Flow in its entirety:
Starts as a schedule-triggered flow filtering only records within the snapshot that have a number greater than 21 in the Days Since Due field. Further context:
- Days Since Due is a formula field on the object that stores the snapshots which subtracts Today() from a due date on a record captured by the snapshot. These numbers are populating correctly when viewing the snapshot records.
- I have a separate flow running daily that deletes all snapshot records that were not created today, so there is no need to further filter records by date in this flow. It was a weird round-about solution of mine to simplify this flow, thinking it would fix my issues, but it obviously didn't.
Next is a Get Records element that gets all the Account records that match the Account IDs that are captured in the snapshot. Besides the default Account record ID, it is only capturing a picklist field called AR Health Status from the qualified Account records.Next is a Loop element shoving all the qualified Accounts and their collected fields into a variable called AccountCollection.
The an Assignment element making the AR Health Status the picklist value of Super Bad (respect the naming schema lol).
And then lastly, outside the loop, an Update Records element to update everything from the Loop and variable.
But NOTHING is updating! And the debug isn't giving me any errors to work with.
Any advice from the community? :) thanks!
Davis Johnson (SolomonEdwards) 
Forum Ambassador
If the collection is of type Account (same as the individual items you are looping), you would put that new collection variable on the left side of the operator, use add as the operator type, and use the current loop of the collection as the right side of the equation. Then, you'd reference that collection variable from your update element.
