Skip to main content
Nintex Community Menu Bar
Solved

Any External Data At All On O365 Form?

  • Aug 15, 2018 8:52 AM UTC
  • 4 replies
  • 52 views
  • Translate All

rhia
Nintex Partner
Forum|alt.badge.img+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

Best answer by EuanGamble

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

View original

4 replies

rhia
Nintex Partner
Forum|alt.badge.img+15
  • Author
  • Nintex Partner
  • Aug 15, 2018 3:10 PM UTC

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

Translate

EuanGamble
Nintex Employee
Forum|alt.badge.img+13
  • Nintex Employee
  • Answer
  • Aug 15, 2018 10:55 PM UTC

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

Translate

rhia
Nintex Partner
Forum|alt.badge.img+15
  • Author
  • Nintex Partner
  • Aug 16, 2018 8:23 AM UTC

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.

Translate

rhia
Nintex Partner
Forum|alt.badge.img+15
  • Author
  • Nintex Partner
  • Apr 11, 2019 12:42 AM UTC

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.

Translate