I have a workbook in which I have emails being added to tables via Power Automate each time they come in with some basic information. I then have multiple users in the organization who come behind that and fill in additional information, inclusive of data validation fields (4 columns) with options they should not deviate from. They consistently paste free-form text to those cells turning off the data validation and make my reporting incredibly difficult. I can protect the sheet but this stops Power Automate from functioning. I assume Power Automate is editing the file using my credentials and I could potentially add that to an Allow Edit Range permissions object but the Locations option is set to my personal machine and will not pull from the organization.
How can I restrict permissions from users while not inhibiting Power Automate from functioning? If that's a non-starter, would it be possible to use Power Automate or anything else to compare user values against the tables in which I keep the validation options and send out angry emails when a non-compliant entry is found?
How can I restrict permissions from users while not inhibiting Power Automate from functioning? If that's a non-starter, would it be possible to use Power Automate or anything else to compare user values against the tables in which I keep the validation options and send out angry emails when a non-compliant entry is found?
