Public form - Dropdown value from SharePoint list

Hello,

Is it possible to fill out dropdown field with the values of a SharePoint list using the Public Form? I know it can be done with the SP form, but I need it done with the Public form.

Thanks,

Alberto

Hello @avs270,

Welcome to Plumsail Community!

If the public form is published in SharePoint, this can be done using the code from this article.

Otherwise, this can be done using MS Graph, but in this case, each user of the form must be authenticated.

Are you considering a paid support option?

We can integrate Public Forms with MS Account. You will be able to turn on authentication via MS Account for specific forms. Thus a user will need to sign into his MS Account before using such forms, and the user will be able to use MS Graph without additional authentication. Also, we will provide corresponding JS-code to populate fields with SharePoint lists data.

If you are interested, please contact us via [email protected]

Hello,

Thank you for the reply. If I understand correctly, the only way to have this done is to have the form show within SharePoint (which requires SharePoint Online licensing) or to have a MS account for the user opening the public form. In other words, this cannot be done with pure anonymous access.

Please confirm.

Thanks,

Alberto da Silva

Hello @avs270,

Yes, that is correct. If you store data in the SharePoint list and want to access it, you need to be authorized.

1 Like

Hello @avs270,

We published an article that may be useful for you. It's on how to populate drop-down lists in public Plumsail forms with data from a SharePoint list. The form will still be anonymous. You can find it on Medium:

1 Like

Thank you, in the example below. Are we able to query the values that we want to bring from the SharePoint list. I do not want to bring all values. If so, where would this be done?

Hello @adasilva,

You can change the Query options in the ListData.cs file in your copy of our repository on GitHub, the path of the file is:
data-source-functions/FunctionApp/SharePoint/ListData.cs

1 Like

Hi Margarita,

What if we used Azure SQL Database instead of SharePoint list. How would we connect to it from an external form?

Thanks,

Alberto da Silva

Hello @adasilva,

Unfortunately, right now there is no one method to get data from SQL server to forms. I would recommend getting the data copied from SQL server to SharePoint via MS Flow.