I have a Member List the has each member once, and a Status column.
I have a Training List. Each member may appear once or many times (depending on number of certs/quals each has), and also has the Status column.
My flow currently works. It updates the Member Training List Status based on any change the Member List.
The issue, I am being forced to use the SP Id in the 'Update item' action of my flow. In the action it shows 'required' even though I don't require it in my list for anything. Because the SP Id number don't match on both list, and because the Member appears multiple time on the Member Training List, the flow is updating the wrong line item.
So, the flow is working, just not 'exactly'.
I don't want to use the SP auto-generated Id. I have a UnqID in another column. I could use the 'UnqID' I've created (that matches exactly for each member on both lists), the hope is a change to the Member List will then Update item the 'Status' for the member on every line their name appears on the Member Training List.
Can I / How do I disengage the 'requirement' for the SP Id in the flow?
Thoughts?