UpdateIf stuck in infinite load, but also works?

[epiej]

I'm updating an SQL Server table and a duplicate collection of that table in one button. When I press it, the app is stuck in an infinite loop with the dots passing the top of the screen and the button remains grey. I tested the UpdateIf functions for the SQL and Collection independently and the collection update works without issue. When I restart the app it shows that my SQL update went through, so the SQL part apparently worked, but is causing an infinite load. The table and collection are ~4,500 records long each. Below is the logic.

UpdateIf(
    '[dbo].[SQL_TABLE]',
    TABLE_ID in TableCheckedItems.TABLE_ID,
    {FOREIGN_KEY_ID: ComboBox27_1.Selected.FOREIGN_KEY_ID}
);
UpdateIf(
    SQL_TABLE_COLLECTION,
    TABLE_ID in TableCheckedItems.TABLE_ID,
    {FOREIGN_KEY_ID: ComboBox27_1.Selected.FOREIGN_KEY_ID}
)

[Jeff_Thorpe]

I am not sure why it would bestuck in a loop. Try adding your updateif() functions to a Concurrent(). If it works it will also improve performance.

Example 

Concurrent(
 UpdateIf(
    '[dbo].[SQL_TABLE]',
    TABLE_ID in TableCheckedItems.TABLE_ID,
    {FOREIGN_KEY_ID: ComboBox27_1.Selected.FOREIGN_KEY_ID}
 ),
 UpdateIf(
    SQL_TABLE_COLLECTION,
    TABLE_ID in TableCheckedItems.TABLE_ID,
    {FOREIGN_KEY_ID: ComboBox27_1.Selected.FOREIGN_KEY_ID}
 )
)

Formula1, Formula2 [, ...] )

[epiej]

@Jeff_Thorpe I'd already tested both updates independently and narrowed it down to the SQL update causing the issue. I tried your solution, and while the collection is updated immediately, the loop is still there.