UDF writeback text to SQL table

[prathamesh27]

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 required but has no value),
I want to update Notes for specific HB(Unique) from Power BI report using UDF. I have seen many solution with Text slicer but now there is not text slicer as it is replaced by Input slicer, and that method is not working. It is not passing comments to UDF. Please show me process to do it.

[v-achippa]

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]

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

[lbendlin]

I want to update Notes for specific HB(Unique)

Not currently possible. UDFs only work against Filter context, not against individual "rows".

[DanieleUgoCopp · Accepted solution]

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