Can I add an &&& statement after Updating records

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

So I have been struggling to get an app to work .

All is in place but I need to change a varible after a record update.

So here is my code

Update(Table1_14,First(Filter(Table1_14, Name =DataCardValue1.Text && Time_x0020_Out<>Blank() && Time_x0020_In="")),{Time_x0020_In:Clock_5.Text, Location: "On Site"})

This all works but I want to add at hte end

&& UpdateContext({Variable:true})

can anyone help?

Rince

Categories:

Building Power Apps

I have the same question (0)

All responses (8)

Answers (0)

Sort by

keathley 142 on at

Like
a
(0)

Report
Copy link

Link copied!
@Anonymous Commands can typically be strung together by separating them with a ;

You might give this a try:

Update(Table1_14,First(Filter(Table1_14, Name =DataCardValue1.Text && Time_x0020_Out<>Blank() && Time_x0020_In="")),{Time_x0020_In:Clock_5.Text, Location: "On Site"}) ;UpdateContext({Variable:true})
Good luck,
Joey

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks Keathley

I should have mentioned that I want the variable to change only if the table has been updated, otherwise I want it to stay false.
If I separate it with a ; it always changes the varible

Was this reply helpful? Yes No
Shanescows 2,218 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

After the ; do an If to determine if it has changed.

Was this reply helpful? Yes No
keathley 142 on at

Like
a
(0)

Report
Copy link

Link copied!

@Anonymous I am not sure I follow if you want to know if the update failed or if it actually changed values. If you want to know if it succeeded / failed you could use an "OnSuccess" property on the form. If you want to know if the value changed you could wrap the variable update in an If to test for the change.

Joey

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

I tried wrapping in an ifstatement before and it didn't work.

What I ideally need is either to update an existing record or create new one if there is no existing record.

By changing the variable i can submit the form if the variable is equal to the set value.

I was exploring an alternant solution to the previous question I posed.

However I have never used an onSuccess statement before.
Something for me to look in to

Thanks

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Shane

How would the If staement check if table has been amended?

Thanks

Gareth

Was this reply helpful? Yes No
keathley 142 on at

Like
a
(0)

Report
Copy link

Link copied!

@Anonymous Have you looked at Patch which can create or update records?

Joey

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

I have looked at patch too yes.

I can get the records to create and to edit separately.
I can also get the records to create new and not edit.

I just cannot get the records to edit without creating a new instance too.

Rince

Was this reply helpful? Yes No