Forum Discussion
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...
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
lbendlin
Super User
Super UserI want to update Notes for specific HB(Unique)Not currently possible. UDFs only work against Filter context, not against individual "rows".