Integration SP Online with External (anonymous) Form

%3CLINGO-SUB%20id%3D%22lingo-sub-1449416%22%20slang%3D%22en-US%22%3EIntegration%20SP%20Online%20with%20External%20(anonymous)%20Form%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1449416%22%20slang%3D%22en-US%22%3E%3CP%3EHello!%3C%2FP%3E%3CP%3EWe%20would%20like%20to%20be%20able%20to%20post%20external%20anonymous%20(no%20O365%20authentication)%20form%20hosted%20on%20the%20Internet%20site%20into%20SP%20Online%20list%2C%20that%20includes%20form%20fields%20and%20attached%20files.%3CBR%20%2F%3ESince%20anonymous%20authentication%20is%20phased%20out%20in%20O365%20we%20need%20some%20intermediate%20on%20Office%20side%20to%20deliver%20JSON%20over%20to%20O365%20and%20post%20it%20to%20SP%20online%20List.%3C%2FP%3E%3CP%3EHow%20would%20you%20architect%20this%3F%3C%2FP%3E%3CP%3EEmail%2C%20Flow%3F%20Azure%20function%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1449416%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EDocument%20Library%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFiles%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1449609%22%20slang%3D%22en-US%22%3ERe%3A%20Integration%20SP%20Online%20with%20External%20(anonymous)%20Form%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1449609%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F140793%22%20target%3D%22_blank%22%3E%40Victor%20Shostak%3C%2FA%3E%26nbsp%3Byou%20could%20use%20Microsoft%20Forms%20set%20to%20%22Anyone%20with%20a%20link%20can%20respond%22%2C%20i.e%20it's%20anonymous.%20Then%20use%20a%20flow%20in%20Power%20Automate%20to%20get%20the%20form%20response%20and%20create%20an%20item%20in%20the%20SharePoint%20list.%20It's%20quick%20and%20works%20well%20but%20there%20is%20one%20issue%20in%20that%20a%20responder%20cannot%20attach%20files%20to%20an%20anonymous%20form.%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%3EMicrosoft%20Power%20Automate%20Community%20Super%20Use%3C%2FFONT%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1466559%22%20slang%3D%22en-US%22%3ERe%3A%20Integration%20SP%20Online%20with%20External%20(anonymous)%20Form%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1466559%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%3C%2FP%3E%3CP%3EThank%20Rob%20for%20a%20suggestion.%26nbsp%3B%3CBR%20%2F%3EWe%20have%20a%20complex%20form%20to%20submit%2C%20it%20is%20outside%20of%20Office%2C%20I%20was%20looking%20for%20a%20solution%20like%20this%3A%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fmedium.com%2Fplumsail%2Fhow-to-provide-public-access-to-sharepoint-online-list-data-via-azure-function-using-azure-ad-app-f25f881d7328%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fmedium.com%2Fplumsail%2Fhow-to-provide-public-access-to-sharepoint-online-list-data-via-azure-function-using-azure-ad-app-f25f881d7328%3C%2FA%3E%3C%2FP%3E%3CP%3EIt%20allows%20to%20read%20from%20SP%20List%20anonymously%20however%20we%20need%20to%20submit.%3CBR%20%2F%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Hello!

We would like to be able to post external anonymous (no O365 authentication) form hosted on the Internet site into SP Online list, that includes form fields and attached files.
Since anonymous authentication is phased out in O365 we need some intermediate on Office side to deliver JSON over to O365 and post it to SP online List.

How would you architect this?

Email, Flow? Azure function?

2 Replies

@Victor Shostak you could use Microsoft Forms set to "Anyone with a link can respond", i.e it's anonymous. Then use a flow in Power Automate to get the form response and create an item in the SharePoint list. It's quick and works well but there is one issue in that a responder cannot attach files to an anonymous form.

 

Rob
Los Gallardos
Microsoft Power Automate Community Super Use

 

 

@Rob Elliott

Thank Rob for a suggestion. 
We have a complex form to submit, it is outside of Office, I was looking for a solution like this:

https://medium.com/plumsail/how-to-provide-public-access-to-sharepoint-online-list-data-via-azure-fu...

It allows to read from SP List anonymously however we need to submit.