Forum Discussion

prathamesh27's avatar
prathamesh27
Frequent Visitor
4 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
    4 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

     
     
     
v-achippa's avatar
v-achippa
Community Support
4 months ago

Hi prathamesh27,

 

Thank you for reaching out to Microsoft Fabric Community.

 

Thank you DanieleUgoCopp and lbendlin for the prompt response.

 

As we haven’t heard back from you, we wanted to kindly follow up to check if the response provided by the user's for the issue worked? or let us know if you need any further assistance.

 

Thanks and regards,

Anjan Kumar Chippa

v-achippa's avatar
v-achippa
Community Support
4 months ago

Hi @prathamesh27,

 

We wanted to kindly follow up to check if the response provided by the user's for the issue worked? or let us know if you need any further assistance.

 

Thanks and regards,

Anjan Kumar Chippa