Our business is repairing and building truck tanks. I have a scheduler pilot I built in Microsoft Lists. We have techs assigned to jobs that our customers bring in. The repairs are assigned to bay locations, thirty one in all. In Lists we created a hidden column called location sort and a column called location for the bay assignments. I was advised to sort by the location sort which is a hidden column created in the test pilot. Here's the additional detail. We want to be able to sort in ascending order by the location column even though the sort is accomplished in the hidden Location sort column. Further, we want to be able to change the location by tech from the drop down column choices in the location column or by clicking on the bay number in grid edit and picking a different bay. Once the choices are made, the location column would automatically resort in ascending order This functionality is important because these assignments change daily.
I used Chat GPT to help me create the workflow. I have many hours trying to make this work but have been unsuccessful getting the flow to run without errors. Chat GPT has given me endless loops that don't work to resolve the issues. Below I've attached screen shots of the errors and the flow diagram as a starting point. I'd appreciate any input that you could give. At this point I'm not sure this is even possible. From the onset, it would seem that the function is fairly straightforward.
I'd appreciate hearing back once you have reviewed this.
Errors:
Action 'For_each' failed: The execution of template action 'For_each' failed: the result of the evaluation of 'foreach' expression '@triggerOutputs()?['body/value']' is of type 'Null'. The result must be a valid array.
Your flow was saved, but with a warning: Your flow may have a circular loop Actions in this flow may result in an infinite trigger loop. Please ensure you add appropriate conditional checks to prevent this flow from triggering itself.
Flow Diagram:
