SOLVED

VIewing SharePoint List Data in a MS Form

%3CLINGO-SUB%20id%3D%22lingo-sub-817022%22%20slang%3D%22en-US%22%3EVIewing%20SharePoint%20List%20Data%20in%20a%20MS%20Form%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-817022%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20a%20MS%20Form%20which%20collects%20information%20and%20adds%20this%20to%20a%20SharePoint%20list%20via%20MS%20Flow.%20So%20far%2C%20so%20good.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%202%20questions%20though%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E1.%20Can%20I%20create%20a%20single%20form%20and%20restrict%20the%20data%20users%20see%20based%20on%20permissions%3F%20For%20example%2C%20I%20would%20want%20external%20users%20to%20see%20Section%201%20but%20internal%20users%20to%20see%20Sections%201%20and%202%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E2.%20Is%20it%20possible%20to%20open%20the%20same%20Form%20and%20show%20a%20row%20of%20data%20from%20the%20SharePoint%20list%20in%20the%20MS%20Form%3F%20So%2C%20once%20data%20had%20been%20received%20from%20an%20external%20source%2C%20I%20wanted%20to%20send%20an%20alert%20to%20an%20internal%20user%20to%20view%20the%20data%20submitted%20in%20the%20MS%20Form%20and%20then%20add%20some%20additional%20criteria.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20realise%20this%20could%20be%20done%20using%20PowerApps%20but%20wondered%20if%20Forms%20also%20supported%20such%20a%20scenario.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMany%20thanks%20in%20advance%2C%3C%2FP%3E%3CP%3EColin%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-817022%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EForms%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-817257%22%20slang%3D%22en-US%22%3ERe%3A%20VIewing%20SharePoint%20List%20Data%20in%20a%20MS%20Form%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-817257%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F358029%22%20target%3D%22_blank%22%3E%40Colin2307%3C%2FA%3E%26nbsp%3Bneither%20of%20your%20questions%20are%20currently%20possible%20in%20Forms.%20Additionally%2C%20you%20can%20only%20have%20a%20form%20which%20is%20either%20visible%20to%20those%20in%20your%20organisation%2C%20or%20visible%20to%20anyone%20with%20a%20link.%20So%20you%20can't%20have%20questions%20visible%20based%20on%20whether%20someone%20is%20internal%20or%20external.%3C%2FP%3E%3CP%3E%3CFONT%20size%3D%223%22%3ERob%3C%2FFONT%3E%3CBR%20%2F%3E%3CFONT%20size%3D%223%22%3ELos%20Gallardos%3C%2FFONT%3E%3CBR%20%2F%3E%3CFONT%20size%3D%223%22%3EMicrosoft%20Flow%20Community%20Super%20User%3C%2FFONT%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-817376%22%20slang%3D%22en-US%22%3ERe%3A%20VIewing%20SharePoint%20List%20Data%20in%20a%20MS%20Form%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-817376%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F174092%22%20target%3D%22_blank%22%3E%40Rob%20Elliott%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20Rob.%20I%20figured%20as%20much%20but%20thought%20I'd%20ask%20anyway.%20Did%20some%20testing%20earlier%20and%20I%20see%20Forms%20is%20one%20way.%20PowerApps%20it%20is.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThans%2C%3C%2FP%3E%3CP%3EColin%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Contributor

Hello,

 

I have a MS Form which collects information and adds this to a SharePoint list via MS Flow. So far, so good. 

 

I have 2 questions though

 

1. Can I create a single form and restrict the data users see based on permissions? For example, I would want external users to see Section 1 but internal users to see Sections 1 and 2

 

2. Is it possible to open the same Form and show a row of data from the SharePoint list in the MS Form? So, once data had been received from an external source, I wanted to send an alert to an internal user to view the data submitted in the MS Form and then add some additional criteria.

 

I realise this could be done using PowerApps but wondered if Forms also supported such a scenario.

 

Many thanks in advance,

Colin

2 Replies
Highlighted
Best Response confirmed by Colin2307 (Occasional Contributor)
Solution

@Colin2307 neither of your questions are currently possible in Forms. Additionally, you can only have a form which is either visible to those in your organisation, or visible to anyone with a link. So you can't have questions visible based on whether someone is internal or external.

Rob
Los Gallardos
Microsoft Flow Community Super User

Highlighted

@Rob Elliott 

 

Thank you Rob. I figured as much but thought I'd ask anyway. Did some testing earlier and I see Forms is one way. PowerApps it is. 

 

Thans,

Colin