Solved

Any External Data At All On O365 Form?

  • 15 August 2018
  • 4 replies
  • 3 views

Userlevel 6
Badge +15

Hey folks - 

 

With the lack of controls for SQL / Web Request / BDC on O365 forms, have you found any ways around this? 

I have an SQL instance that I need to be able to reference from a form. Is there a way to mirror into SharePoint lists and use it as a look-up list without it being a BDC? Any fancy thoughts you've come up with???

 

Cheers,


Rhia

icon

Best answer by EuanGamble 16 August 2018, 00:55

View original

4 replies

Userlevel 6
Badge +15

Euan Gamble‌  // Dan Burke‌ // Jonathan Butler

Userlevel 5
Badge +13

Hi Rhia Wieclawek‌,

No workaround at this stage. We are still planning on using Nintex Xtensions to provide a connection to external data sources for Universal Forms, but we are still a while away from that.

Cheers,

Euan

Userlevel 6
Badge +15

Thanks Euan. 

I'm trying to think of ways to populate a SharePoint list with SQL data and just refresh it as needed or something, without it being BDC. Sounds messy huh.

Userlevel 6
Badge +15

Just FYI in case anyone else runs into this:

 

There's a product called Layer2 which will replicate your SQL query into an SPO list. From there, you can use it however you like - Nintex can't tell the difference between it and a regular list.

Reply