Forum Discussion

Victor Shostak's avatar
Victor Shostak
Copper Contributor
Jun 08, 2020

Integration SP Online with External (anonymous) Form

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?

Document Library
files
SharePoint Online

2 Replies

  • RobElliott's avatar
    RobElliott
    Silver Contributor
    Jun 08, 2020

    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

     

     

    • Victor Shostak's avatar
      Victor Shostak
      Copper Contributor
      Jun 16, 2020

      RobElliott

      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-function-using-azure-ad-app-f25f881d7328

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

Resources