Can I have my form choice question look up the answers?

%3CLINGO-SUB%20id%3D%22lingo-sub-2919928%22%20slang%3D%22en-US%22%3ECan%20I%20have%20my%20form%20choice%20question%20look%20up%20the%20answers%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2919928%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20a%20simple%20form%20for%20people%20to%20fill%20out%20to%20acknowledge%20they%20have%20read%20a%20briefing.%20These%20answers%20get%20put%20into%20a%20Sharepoint%20list.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EOne%20of%20the%20questions%20is%20%22which%20briefing%20did%20you%20read%3F%22.%20Can%20i%20get%20this%20to%20be%20a%20dropdown%20that%20looks%20up%20the%20briefing%20titles%20available%20(in%20a%20sharepoint%20document%20library.%20Or%20maybe%20from%20an%20excel)%20instead%20of%20me%20adding%20an%20option%20every%20time%20a%20new%20briefing%20is%20published%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20this%20possible%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%3C%2FP%3E%3CP%3ESam%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2919928%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EForms%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%202019%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2920555%22%20slang%3D%22en-US%22%3ERe%3A%20Can%20I%20have%20my%20form%20choice%20question%20look%20up%20the%20answers%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2920555%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1137286%22%20target%3D%22_blank%22%3E%40samdavidson%3C%2FA%3E%26nbsp%3Bno%2C%20there%20is%20no%20functionality%20in%20Forms%20to%20look%20up%20anything.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAt%20my%20company%20we%20issue%20safety%20briefings%20as%20part%20of%20a%20contract%20and%20I%20created%20the%20system%20using%20Forms%2C%20Power%20Automate%20and%20SharePoint%20to%20replace%20a%20commercial%20system%20costing%20several%20thousand%20UK%20pounds%20a%20month.%20The%20briefing%20details%20are%20added%20to%20the%20Forms%20form%20and%20a%20PDF%20is%20uploaded...%3C%2FP%3E%3CP%3E%3CSPAN%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20image-alt%3D%221-SBS-Form.png%22%20style%3D%22width%3A%20447px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F323696i621B310613109FD9%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%221-SBS-Form.png%22%20alt%3D%221-SBS-Form.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E...and%20saved%20automatically%20by%20a%20flow%20in%20Power%20Automate%20as%20an%20attachment%20to%20a%20new%20list%20item.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20image-alt%3D%222-SBS-Library.png%22%20style%3D%22width%3A%20934px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F323713iDD4AE5D1B83EC1E8%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%222-SBS-Library.png%22%20alt%3D%222-SBS-Library.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EA%20JSON-formatted%20button%20in%20the%20list%20is%20then%20used%20to%20trigger%20another%20flow%20to%20send%20out%20the%20briefing%20and%20the%20administrator%3CSPAN%3E%26nbsp%3Bcan%20select%20teams%20will%20receive%20it%20(from%20another%20list).%20%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20image-alt%3D%223-SBS-Flow-Panel.png%22%20style%3D%22width%3A%20487px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F323701i21F2EA81E3AB9B2B%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%223-SBS-Flow-Panel.png%22%20alt%3D%223-SBS-Flow-Panel.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3EThe%20user%20receives%20an%20email%20with%20the%20briefing%20as%20an%20attachment%20but%20the%20email%20is%20an%20approval%20adaptive%20card%20which%20means%20they%20just%20need%20(within%2030%20days)%20to%20add%20any%20comments%20then%20click%20a%20submit%20button.%26nbsp%3B%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20image-alt%3D%226-SBS-Recipient-Email.png%22%20style%3D%22width%3A%20632px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F323710i75E3B27CEC612F72%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%226-SBS-Recipient-Email.png%22%20alt%3D%226-SBS-Recipient-Email.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3EThe%20adaptive%20card%20then%20%22closes%22%20so%20they%20can't%20submit%20the%20read%20confirmation%20more%20than%20once%2C%20but%20can%20still%20read%20the%20attachment.%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20image-alt%3D%227-SBS-AdaptiveCardClosed.png%22%20style%3D%22width%3A%20614px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F323708iDDC5732F7CF40982%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%227-SBS-AdaptiveCardClosed.png%22%20alt%3D%227-SBS-AdaptiveCardClosed.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3EThe%20flow%20adds%20their%20name%20and%20date%20and%20any%20comments%20they%20made%20into%20another%20list%3A%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20image-alt%3D%228-SBS-ResponsesList.png%22%20style%3D%22width%3A%20927px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F323711i9400676BA94DCFA9%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%228-SBS-ResponsesList.png%22%20alt%3D%228-SBS-ResponsesList.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3EThis%20is%20a%20more%20complex%20approach%20but%20works%20well%2C%20meets%20the%20terms%20of%20the%20contract%20and%20provides%20an%20audit%20trail%20of%20who%20has%20read%20the%20briefing.%3C%2FSPAN%3E%26nbsp%3BI%20haven't%20provided%20screenshots%20of%20the%20flows%20but%20can%20do%20so%20if%20it%20would%20help.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERob%3CBR%20%2F%3ELos%20Gallardos%3CBR%20%2F%3E%3CFONT%20size%3D%222%22%20color%3D%22%23006400%22%3EIntranet%2C%20SharePoint%20and%20Power%20Platform%20Manager%20(and%20classic%201967%20Morris%20Traveller%20driver)%3C%2FFONT%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Hi,

 

I have a simple form for people to fill out to acknowledge they have read a briefing. These answers get put into a Sharepoint list.

 

One of the questions is "which briefing did you read?". Can i get this to be a dropdown that looks up the briefing titles available (in a sharepoint document library. Or maybe from an excel) instead of me adding an option every time a new briefing is published?

 

Is this possible?

 

Thanks

Sam

2 Replies

@samdavidson no, there is no functionality in Forms to look up anything. 

 

At my company we issue safety briefings as part of a contract and I created the system using Forms, Power Automate and SharePoint to replace a commercial system costing several thousand UK pounds a month. The briefing details are added to the Forms form and a PDF is uploaded...

1-SBS-Form.png

 

...and saved automatically by a flow in Power Automate as an attachment to a new list item. 

 

2-SBS-Library.png

 

A JSON-formatted button in the list is then used to trigger another flow to send out the briefing and the administrator can select teams will receive it (from another list).

 3-SBS-Flow-Panel.png

 

The user receives an email with the briefing as an attachment but the email is an approval adaptive card which means they just need (within 30 days) to add any comments then click a submit button.  

 

6-SBS-Recipient-Email.png

 

The adaptive card then "closes" so they can't submit the read confirmation more than once, but can still read the attachment. 

 

7-SBS-AdaptiveCardClosed.png

 

The flow adds their name and date and any comments they made into another list:

8-SBS-ResponsesList.png

 

This is a more complex approach but works well, meets the terms of the contract and provides an audit trail of who has read the briefing. I haven't provided screenshots of the flows but can do so if it would help.

 

Rob
Los Gallardos
Intranet, SharePoint and Power Platform Manager (and classic 1967 Morris Traveller driver)

Thanks! That's a better solution to what i was envisioning. If I could get some screenshots of the flows that would be really helpful.