"We couldn't create your rule. Please try again." error with restricted list permissions

%3CLINGO-SUB%20id%3D%22lingo-sub-2278370%22%20slang%3D%22en-US%22%3E%22We%20couldn't%20create%20your%20rule.%20Please%20try%20again.%22%20error%20with%20restricted%20list%20permissions%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2278370%22%20slang%3D%22en-US%22%3E%3CP%3EI%20setup%20a%20list%20with%20the%20following%20restrictions%20(under%20list%20Settings%20%26gt%3B%20Advanced%20Settings)%20so%20that%20users%20can%20create%2Fsee%2Fedit%20only%20their%20records%3A%3C%2FP%3E%3CUL%3E%3CLI%3E%3CSTRONG%3ERead%20access%3C%2FSTRONG%3E%3A%26nbsp%3B%3CSPAN%3ERead%20items%20that%20were%20created%20by%20the%20user%3C%2FSPAN%3E%3C%2FLI%3E%3CLI%3E%3CSPAN%3E%3CSTRONG%3ECreate%20And%20Edit%20access%3A%26nbsp%3B%3C%2FSTRONG%3ECreate%20items%20and%20edit%20items%20that%20were%20created%20by%20the%20user%3C%2FSPAN%3E%3C%2FLI%3E%3C%2FUL%3E%3CP%3E%3CSPAN%3EWith%20these%20settings%2C%20even%20I%20as%20site%20owner%20and%20the%20person%20who%20created%20the%20list%20and%20has%20access%20to%20read%2Fchange%2Fdelete%20all%20records%2C%20cannot%20create%20any%20rules%20under%20Automate.%26nbsp%3B%20Every%20rule%20I%20try%20to%20create%20results%20in%20error%3A%3CBR%20%2F%3E%22%3CFONT%20color%3D%22%23FF0000%22%3EWe%20couldn't%20create%20your%20rule.%20Please%20try%20again.%3C%2FFONT%3E%22%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3EI%20have%20to%20change%20Read%20access%20to%20%22Read%20all%20items%22%20to%20be%20able%20to%20create%20rules%20-%20but%20then%20that%20exposes%20everyone's%20records.%26nbsp%3B%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3EIs%20this%20a%20bug%20or%20is%20it%20a%20feature%20that%20even%20someone%20with%20full%20rights%20to%20the%20list%20cannot%20create%20a%20rule%20because%20there%20is%20tighter%20security%20for%20other%20users%3F%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2278370%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ELists%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EPermissions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2339586%22%20slang%3D%22en-US%22%3ERe%3A%20%22We%20couldn't%20create%20your%20rule.%20Please%20try%20again.%22%20error%20with%20restricted%20list%20permissio%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2339586%22%20slang%3D%22en-US%22%3E%3CP%3EI'm%20seeing%20the%20same%20issue%2C%20I%20can't%20create%20rules%20on%20a%20Sharepoint%20list%2C%20the%20system%20just%20throughs%20this%20error.%20It%20is%20regardless%20of%20the%20type%20of%20rule%20as%20well.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2340608%22%20slang%3D%22en-US%22%3ERe%3A%20%22We%20couldn't%20create%20your%20rule.%20Please%20try%20again.%22%20error%20with%20restricted%20list%20permissio%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2340608%22%20slang%3D%22en-US%22%3EYes%2C%20I%20mentioned%20this%20in%20my%20original%20post.%20But%20it%20defeats%20the%20point%20of%20wanting%20restricted%20permissions%20on%20the%20list.%3C%2FLINGO-BODY%3E
New Contributor

I setup a list with the following restrictions (under list Settings > Advanced Settings) so that users can create/see/edit only their records:

  • Read accessRead items that were created by the user
  • Create And Edit access: Create items and edit items that were created by the user

With these settings, even I as site owner and the person who created the list and has access to read/change/delete all records, cannot create any rules under Automate.  Every rule I try to create results in error:
"We couldn't create your rule. Please try again."

 

I have to change Read access to "Read all items" to be able to create rules - but then that exposes everyone's records.  

Is this a bug or is it a feature that even someone with full rights to the list cannot create a rule because there is tighter security for other users?

5 Replies

I'm seeing the same issue, I can't create rules on a Sharepoint list, the system just throughs this error. It is regardless of the type of rule as well.

Identified this is a permissions error

The owner needs to open the list and select: Settings > List settings > Advanced settings. Under Item-level Permissions, the Read access option must be changed to Read all items.
https://support.microsoft.com/en-us/office/create-a-rule-to-automate-a-list-151ea008-7fa6-409b-b0bd-...
Yes, I mentioned this in my original post. But it defeats the point of wanting restricted permissions on the list.

@DCKan The way I got around that was by using power automate, not lists automation.

Did the same. Not ideal but it works.
I still think since a list owner has full permissions on all list records, he/she should be able to do list automation and not have to resort to Power Automate.