Use SQL database values in Sharepoint Custom Forms

%3CLINGO-SUB%20id%3D%22lingo-sub-2864833%22%20slang%3D%22en-US%22%3EUse%20SQL%20database%20values%20in%20Sharepoint%20Custom%20Forms%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2864833%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20everyone%2C%20I%20managed%20to%20use%20a%20PowerApps%20custom%20form%20to%20create%20dynamic%20dropdowns%20with%20my%20SQL%20data%20and%20the%20results%20appear%20in%20the%20dropdowns%20but%20when%20I%20submit%20the%20form%20only%20those%20SQL%20values%20show%20up%20as%20invisible%20(all%20other%20non-SQL%20fields%20show%20up%20fine).%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI'm%20using%20%5BDB_Name%5D.Customers%20or%20Sort(Distinct(%5BDB_Name%5D%2C%20Customers)%2C%20Result)%20to%20get%20the%20SQL%20information%2C%20but%20it's%20just%20not%20submitting%20properly.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20this%20a%20problem%20related%20to%20the%20form's%20connection%20to%20the%20server%3F%20Is%20there%20a%20solution%20to%20this%20issue%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20in%20advance%2C%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2864833%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ECustom%20Form%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ELists%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EPowerApps%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESQL%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Visitor

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