Hello, I have a sharepoint list with an associated powerapp that works great. I also have an automated power flow that adds a row or modifies a row in an excel spreadsheet when a change is made to the Sharepoint list. The flow seems to work well for a day or two then it completely breaks. I am not getting any "failed" runs and they all say succeed but during every run, one of 3 things happens:
1) a row is added instead of modified
2) multiple rows are added
3) no rows are added or modified
I have screenshots of my flow below. If you can see why this is failing please let me know, I have been trying to figure this out for over a month and cannot find the issue.
the filter array string formula is:
string(triggerOutputs()?['body/ID'])
The condition length formula is:
length(body('filter_array'))
The excel table has an ID column (obviously) that is the key column used during the condition/filter array.
Thanks,
Phil C.
