I have a list with a choice column called Status with possible values: New, Pending, Complete. I would like to be able to ensure that whenever the Status column is set to Complete, that an attachment has been added to the list item.
The problem I'm having is that attachment is not really a column so I don't think I can do the usual list validation.
I have also seen similar a question but with an older version of SharePoint. I am using SharePoint Online and not sure if I can add a custom script like that.
I considered Power Automate for a moment, but I don't know how I could set up a flow that would reject entries.