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