OnChange not firing

(0) Share

Report

Posted on by EpicTriffid

364

Hi there,

I have an OnChange function on a text input (# Students) that is designed to update all records in a gallery (# Stud.) when the number is changed. While i was using a SharePoint list as my database, it worked great, but now that I've moved over to an SQL DB, it doesn't seem to be firing when changed.

UpdateContext(
 {newStudents:
 'UE - Value - # Students'.Text}
);
ForAll(
 'UE Unit Gal'.AllItems,
 Patch(
 '[dbo].[Units]',
 LookUp(
 '[dbo].[Units]',
 ID = Value('UE Gal ID'.Text)
 ),
 {
 'Number_x0020_of_x0020_Students': Value(newStudents)
 }
 )
)

The offending input is the one with the delegation error. If anyone can help me remove that as well, I'd be very grateful!

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (0)

Sort by

yashag2255 24,769 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
Hey @EpicTriffid

Can you try to update the expression as:

UpdateContext( {newStudents: Value('UE - Value - # Students'.Text)} ); ForAll( 'UE Unit Gal'.AllItems, Patch( '[dbo].[Units]', LookUp( '[dbo].[Units]', ID = Value('UE Gal ID'.Text) ), { 'Number_x0020_of_x0020_Students': newStudents } ) )

Are you getting any errors? To check if the OnChange is getting triggered, add the below expression on the OnChange property as:

Notify("Getting triggered");

If you are able to see the notification, then the issue is with the Patch query and OnChange is getting triggered.

Note: OnChange only gets triggered if the user clicks outside the text input.

Hope this Helps!

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

Was this reply helpful? Yes No
EpicTriffid 364 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @yashag2255 ,

Thanks for the help. I adapted it as you said, and no errors that I can see. The notifation does come through, so do you have ideas what might be wrong with the Patch? Is there a problem between ForAll and SQL?

Was this reply helpful? Yes No