It is a bit random but using the RemoveIf statement sometimes works, sometimes doesn't.
Nothing changes in the code, just the parameters. The items that could not be reomoved in PowerApps were successfully removed with T-SQL so there are no database constraint issues there.
The code used is:
RemoveIf('[dbo].[Invoices_Transactions]', Invoice = ThisItem.Invoice, Transaction = Last(CurrentTransaction).ID)
Thanks for the feedback.
Is CurrentTransaction a collection, or something else?
If it is a collection, then could we write a condition to check it would be empty?
If(!IsEmpty(CurrentTransaction), removeif(), removeif())
Only a shots for the missing scenarios.
Yes, CurrentTransaction is a collection. No it is not empty since there is a text box on the screen that displays Last(CurrentTransaction).ID
Frankly I am not sure of what is going on. In any case there is another bug in the SQL connector that your colleagues are working on, so maybe this will be resolved in the process.
Thanks for following up.
Fill out a quick form to claim your user group badge now!
Find out where you can attend!
Features releasing from October 2019 through March 2020
Learn how to build the business apps that you need.