Forum Discussion

prathamesh27's avatar
prathamesh27
Frequent Visitor
5 months ago
Solved

UDF writeback text to SQL table

I have SQL table which contains HB and Notes section, I will click on HB in table in Report, then it fetches specific HB but when i ut comments in Notes Input slicer the button shows error(Notes is r...
Need Help
Show and Tell
Tutorial Requests
  • DanieleUgoCopp's avatar
    DanieleUgoCopp
    5 months ago

    Hello,

    what usually works in practice is using Power Apps visual for writeback, or calling a Power Automate flow that writes to SQL, both handle text input much more reliably than trying to force it via UDF if you really want to stick with SQL/UDF, you’d need a parameterized query or direct query trick,

    I’d try Power Apps first, much smoother for this use case

    Best regards,
    Daniele

     
     
     
DanieleUgoCopp's avatar
DanieleUgoCopp
Icon for Super User rankSuper User
5 months ago

Hello,

what usually works in practice is using Power Apps visual for writeback, or calling a Power Automate flow that writes to SQL, both handle text input much more reliably than trying to force it via UDF if you really want to stick with SQL/UDF, you’d need a parameterized query or direct query trick,

I’d try Power Apps first, much smoother for this use case

Best regards,
Daniele