Use SQL database values in Sharepoint Custom Forms

Copper Contributor

Hi everyone, I managed to use a PowerApps custom form to create dynamic dropdowns with my SQL data and the results appear in the dropdowns but when I submit the form only those SQL values show up as invisible (all other non-SQL fields show up fine).

 

I'm using [DB_Name].Customers or Sort(Distinct([DB_Name], Customers), Result) to get the SQL information, but it's just not submitting properly.

 

Is this a problem related to the form's connection to the server? Is there a solution to this issue?

 

Thanks in advance,

0 Replies