Public Form Drop Down Excel Data Source

When using an Excel workbook stored in OneDrive as the data source for a drop down in a public web form, the caching value defaults to 600 (10 minutes). Would setting it to a lower value cause issues? My concern is some sort of request throttling by SharePoint Online.

Hello @rschoneman,

Reducing the caching lifetime may affect the form load speed, but probably won't cause throttling when it sets at least to 1 second.

1 Like