Allow users to view/edit only thier list elements created using form

%3CLINGO-SUB%20id%3D%22lingo-sub-2236000%22%20slang%3D%22en-US%22%3EAllow%20users%20to%20view%2Fedit%20only%20thier%20list%20elements%20created%20using%20form%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2236000%22%20slang%3D%22en-US%22%3E%3CP%3Emy%20flow%20works%20fine%20but%20I%20have%20a%20problem%20setting%20permissions.%20I%20would%20like%20users%20to%20see%20only%20their%20items%20on%20the%20list.%20But%20since%20the%20item%20is%20created%20from%20the%20form%20using%20power%20automate%20on%20a%20dedicated%20user%20(DMS)%20I%20don't%20know%20how%20to%20grant%20access%20to%20the%20actual%20user%20for%20his%20items%3CBR%20%2F%3E%3CBR%20%2F%3EThis%20is%20my%20flow%3A%3C%2FP%3E%3CDIV%20class%3D%22mceNonEditable%20lia-copypaste-placeholder%22%3E%26nbsp%3B%3C%2FDIV%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22lukasz2_0-1616689857316%20(1).png%22%20style%3D%22width%3A%20674px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F267154i56B583418C4556C2%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22lukasz2_0-1616689857316%20(1).png%22%20alt%3D%22lukasz2_0-1616689857316%20(1).png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CBR%20%2F%3Eit%20will%26nbsp%3B%20create%20new%20element%20on%20sharepoint%20list%20based%20on%26nbsp%3B%20Microsft%20Form%20with%20attachement%3A%3C%2FP%3E%3CDIV%20class%3D%22mceNonEditable%20lia-copypaste-placeholder%22%3E%26nbsp%3B%3C%2FDIV%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22lukasz2_1-1616689857319.png%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F267155i9293D62D7D490866%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22lukasz2_1-1616689857319.png%22%20alt%3D%22lukasz2_1-1616689857319.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eflow%20is%20run%20by%20a%20dedicated%20user%20called%20DMS%3CBR%20%2F%3EUnfortunately%20in%20this%20case%20the%20item%20in%20sharepoint%20is%20created%20also%20by%20this%20user%20(DMS)%20.%3CBR%20%2F%3Eso%20I%20added%20an%20extra%20column%26nbsp%3B%20%22Osoba%22%20which%20contains%20the%20form%20responder%20%22%C5%81ukasz%20%C5%9Awier%C5%BCewski%22%20in%20example%20above%3CBR%20%2F%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22lukasz2_2-1616689857320.png%22%20style%3D%22width%3A%20599px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F267149i9D047358445AD374%2Fimage-dimensions%2F599x48%3Fv%3Dv2%22%20width%3D%22599%22%20height%3D%2248%22%20role%3D%22button%22%20title%3D%22lukasz2_2-1616689857320.png%22%20alt%3D%22lukasz2_2-1616689857320.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CDIV%20class%3D%22mceNonEditable%20lia-copypaste-placeholder%22%3E%26nbsp%3B%3C%2FDIV%3E%3CP%3E%3CSTRONG%3EThe%20case%20is%20that%20i%20want%20everyone%20has%20access%20to%20this%20list%2C%20but%20I%20would%20like%20people%20to%20see%20only%20the%20items%20they%20added.%26nbsp%3B%3C%2FSTRONG%3E%3CSTRONG%3EBy%20default%2C%20the%20owner%20of%20this%20item%20is%20DMS(flow%20user)%2C%20so%20I%20think%20I%20need%20to%20grant%20permissions%20based%20on%20this%20created%20column%2C%20but%20I%20don't%20know%20how%20to%20do%20it.%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EChanging%20the%20sharepoint%20list%20options%20below%20will%20not%20help%20because%20the%20owner%20of%20this%20item%20is%20DMS%3C%2FP%3E%3CDIV%20class%3D%22mceNonEditable%20lia-copypaste-placeholder%22%3E%26nbsp%3B%3C%2FDIV%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22lukasz2_3-1616689857321.png%22%20style%3D%22width%3A%20460px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F267160iE182B9269C63B583%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22lukasz2_3-1616689857321.png%22%20alt%3D%22lukasz2_3-1616689857321.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20also%20tried%20adding%20permissions%20after%20creating%20the%20item%20but%20the%20user%20still%20doesn't%20have%20permissions%20if%20the%20option%20above%20is%20enabled%3C%2FP%3E%3CDIV%20class%3D%22mceNonEditable%20lia-copypaste-placeholder%22%3E%26nbsp%3B%3C%2FDIV%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22lukasz2_4-1616689857321.png%22%20style%3D%22width%3A%20741px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F267163iE99BD78FD9A0268D%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22lukasz2_4-1616689857321.png%22%20alt%3D%22lukasz2_4-1616689857321.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECan%20anyone%20help%20me%20with%20this%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2236000%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EMicrosoft%20Flow%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

my flow works fine but I have a problem setting permissions. I would like users to see only their items on the list. But since the item is created from the form using power automate on a dedicated user (DMS) I don't know how to grant access to the actual user for his items

This is my flow:

 

lukasz2_0-1616689857316 (1).png

 


it will  create new element on sharepoint list based on  Microsft Form with attachement:

 

lukasz2_1-1616689857319.png

 

 

flow is run by a dedicated user called DMS
Unfortunately in this case the item in sharepoint is created also by this user (DMS) .
so I added an extra column  "Osoba" which contains the form responder "Łukasz Świerżewski" in example above
lukasz2_2-1616689857320.png

 

The case is that i want everyone has access to this list, but I would like people to see only the items they added. By default, the owner of this item is DMS(flow user), so I think I need to grant permissions based on this created column, but I don't know how to do it.

 

Changing the sharepoint list options below will not help because the owner of this item is DMS

 

lukasz2_3-1616689857321.png

 

I also tried adding permissions after creating the item but the user still doesn't have permissions if the option above is enabled

 

lukasz2_4-1616689857321.png

 

Can anyone help me with this

0 Replies