Sharepoint list permissions Microsoft Flow

%3CLINGO-SUB%20id%3D%22lingo-sub-959237%22%20slang%3D%22en-US%22%3ESharepoint%20list%20permissions%20Microsoft%20Flow%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-959237%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20trying%20to%20create%20a%20Flow%20that%20will%20generate%20a%20PDF%20when%20an%20item%20is%20submitted%20to%20a%20SharePoint%20List%20and%20cannot%20get%20the%20First%20Step%20in%20the%20Flow%20to%20work.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhen%20using%20a%20Service%20Account%2C%20Flow%20is%20not%20showing%20any%20Site%20Addresses%20or%20List%20Name's.%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-left%22%20style%3D%22width%3A%20575px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F151499iAC9307B44200D216%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22FlowServiceAcct-NoItems.PNG%22%20title%3D%22FlowServiceAcct-NoItems.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%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThis%20service%20account%20is%20in%20the%20%22SiteName%20Owners%22%20group%2C%20but%20does%20not%20see%20any%20items%20in%20the%20%22Site%20Address%22%20list.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhen%20using%20my%20User%20Account%2C%20Flow%20showing%20items%20for%20%22Site%20Address%22%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-left%22%20style%3D%22width%3A%20564px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F151498iA8BCEF86E525EDE3%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22UserAcct-Items.PNG%22%20title%3D%22UserAcct-Items.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%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHowever%2C%20it%20will%20not%20show%20any%20list%2C%20even%20though%20it%20is%20in%20the%20Owner's%20group%20of%20the%20Site%20that%20the%20List%20is%20inheriting%20permissions%20from.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-left%22%20style%3D%22width%3A%20573px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F151500iFCF53644EC5E0EBD%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22UserAcct-NoListName.PNG%22%20title%3D%22UserAcct-NoListName.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%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EDoes%20anyone%20have%20any%20idea%20why%20the%20discrepancy%20and%20why%20I%20cannot%20see%20any%20%22List%20Name%22%20items%20once%20a%20site%20is%20selected%20that%20does%20indeed%20have%20lists%20that%20we%20are%20submitting%20to%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-959237%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%3CLINGO-SUB%20id%3D%22lingo-sub-961144%22%20slang%3D%22en-US%22%3ERe%3A%20Sharepoint%20list%20permissions%20Microsoft%20Flow%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-961144%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F203961%22%20target%3D%22_blank%22%3E%40Brandon%20McGinnis%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYou%20may%20have%20missed%20a%20step.%20Make%20sure%20you%20click%20onto%20%3CSTRONG%3EEnter%20custom%20value%3C%2FSTRONG%3E%20%3CU%3Efirst%3C%2FU%3E%20%3CEM%3Ebefore%3C%2FEM%3E%20you%20paste%20the%20%3CSTRONG%3Esite%20address%20URL%3C%2FSTRONG%3E.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EDon't%20forget%20to%20ensure%20that%20the%20service%20account%20has%20full%20access%20to%20the%20SharePoint%20site%20so%20you%20don't%20get%20stitched%20up%20in%20issues%20later%20down%20the%20track.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECheers%20and%20best%20wishes%3C%2FP%3E%3CP%3EDamien%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-962131%22%20slang%3D%22en-US%22%3ERe%3A%20Sharepoint%20list%20permissions%20Microsoft%20Flow%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-962131%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F89704%22%20target%3D%22_blank%22%3E%40Damien%20Rosario%3C%2FA%3Ethank%20you%20for%20the%20suggestions!%3CBR%20%2F%3E%3CBR%20%2F%3EI%20don't%20need%20to%20enter%20a%20Custom%20Value%2C%20it%20should%20appear%20in%20a%20site%20dropdown%20list.%3CBR%20%2F%3E%3CBR%20%2F%3EThe%20service%20account%20is%20in%20the%20%22SiteName%20-%20Owners%22%20group%20so%20I%20would%20assume%20that%20is%20what%20you%20mean%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-967011%22%20slang%3D%22en-US%22%3ERe%3A%20Sharepoint%20list%20permissions%20Microsoft%20Flow%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-967011%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F203961%22%20target%3D%22_blank%22%3E%40Brandon%20McGinnis%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20agree%20that%20it%20should%20show%20up%20in%20your%20list%20and%20I'm%20not%20across%20any%20technical%20reasons%20why%20it%20wouldn't%20show%20(I'll%20leave%20it%20to%20the%20experts%20to%20comment%20on)%2C%20but%20when%20it%20doesn't%20show%2C%20using%20the%20%3CSTRONG%3EEnter%20custom%20value%3C%2FSTRONG%3E%20is%20just%20as%20effective.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20use%20this%20method%20as%20the%20way%20forward%20in%20my%20Flows%20and%20I%20hope%20it%20has%20given%20you%20the%20way%20forward%20for%20your%20issue%20too.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECheers%20and%20best%20wishes%3C%2FP%3E%3CP%3EDamien%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-968125%22%20slang%3D%22en-US%22%3ERe%3A%20Sharepoint%20list%20permissions%20Microsoft%20Flow%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-968125%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F89704%22%20target%3D%22_blank%22%3E%40Damien%20Rosario%3C%2FA%3E%26nbsp%3Bthe%20issue%20is%20that%20%22Tasks%22%20and%20a%20regular%20SharePoint%20List%20are%20treated%20differently%20by%20Flow.%3CBR%20%2F%3E%3CBR%20%2F%3EI%20tested%20by%20creating%20a%20regular%20Sharepoint%20List%20and%20it%20showed%20up%20in%20the%20dropdown%20of%20available%20items%20where%20the%20Tasks%20list%20did%20not.%3CBR%20%2F%3E%3CBR%20%2F%3EUsing%20the%20%22Custom%20Value%22%20for%20the%20%22Tasks%22%20list%20worked%20though%20and%20I%20was%20able%20to%20create%20the%20Flow.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-970097%22%20slang%3D%22en-US%22%3ERe%3A%20Sharepoint%20list%20permissions%20Microsoft%20Flow%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-970097%22%20slang%3D%22en-US%22%3E%3CP%3EI'm%20glad%20to%20hear%20it%20worked%2C%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F203961%22%20target%3D%22_blank%22%3E%40Brandon%20McGinnis%3C%2FA%3E.%20I%20get%20the%20frustration%20but%20I%20suppose%20that's%20what%20the%20custom%20value%20is%20for%20in%20those%20type%20of%20instances.%20Perhaps%20they'll%20fix%20this%20up%20as%20the%20product%20evolves.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBest%20wishes%20with%20your%20Flows%20and%20the%20weekend%20ahead!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECheers%3C%2FP%3E%3CP%3EDamien%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Contributor

I am trying to create a Flow that will generate a PDF when an item is submitted to a SharePoint List and cannot get the First Step in the Flow to work.

 

When using a Service Account, Flow is not showing any Site Addresses or List Name's.

FlowServiceAcct-NoItems.PNG

 

 

 

 

 

 

 

This service account is in the "SiteName Owners" group, but does not see any items in the "Site Address" list.

 

 

When using my User Account, Flow showing items for "Site Address" 

UserAcct-Items.PNG

 

 

 

 

 

 

 

 

 

 

 

 

 

However, it will not show any list, even though it is in the Owner's group of the Site that the List is inheriting permissions from.

 

UserAcct-NoListName.PNG

 

 

 

 

 

 

 

Does anyone have any idea why the discrepancy and why I cannot see any "List Name" items once a site is selected that does indeed have lists that we are submitting to?

5 Replies
Highlighted

Hi @Brandon McGinnis 

 

You may have missed a step. Make sure you click onto Enter custom value first before you paste the site address URL.

 

Don't forget to ensure that the service account has full access to the SharePoint site so you don't get stitched up in issues later down the track.

 

Cheers and best wishes

Damien

Highlighted

@Damien Rosariothank you for the suggestions!

I don't need to enter a Custom Value, it should appear in a site dropdown list.

The service account is in the "SiteName - Owners" group so I would assume that is what you mean?

Highlighted

Hi @Brandon McGinnis 

 

I agree that it should show up in your list and I'm not across any technical reasons why it wouldn't show (I'll leave it to the experts to comment on), but when it doesn't show, using the Enter custom value is just as effective.

 

I use this method as the way forward in my Flows and I hope it has given you the way forward for your issue too.

 

Cheers and best wishes

Damien

Highlighted

@Damien Rosario the issue is that "Tasks" and a regular SharePoint List are treated differently by Flow.

I tested by creating a regular Sharepoint List and it showed up in the dropdown of available items where the Tasks list did not.

Using the "Custom Value" for the "Tasks" list worked though and I was able to create the Flow.

Highlighted

I'm glad to hear it worked, @Brandon McGinnis. I get the frustration but I suppose that's what the custom value is for in those type of instances. Perhaps they'll fix this up as the product evolves.

 

Best wishes with your Flows and the weekend ahead!

 

Cheers

Damien