PowerApps Gallery Button Passing Wrong Value to Flow

(0) Share

Report

Posted on by BigJohn

Hi,

I have a canvas app that connects to a CDS instance.

I have a gallery in which I have put a "Pick" button.

When this is pressed, it uses Patch to update a value on the Account called "Picked" and also runs a Flow with the following:

UpdateContext({pickedItem: ThisItem});
UpdateContext({patchResult: Patch([@Accounts], ThisItem, {Picked:currentUserEmail})});
If(Not(IsBlank(patchResult)) And IsEmpty(Errors([@Accounts])), Notify("Call Picked Successfully",NotificationType.Success),Notify("Error Picking Call", NotificationType.Error));
CreateAppointment.Run(ThisItem.Account);

The flow creates an Appointment based on the Account in ThisItem
Intermittently, the value passed into the flow isn't the correct Account, so the appointment is created for a different Account.

I can't find any reason, or any pattern as to why sometimes ThisItem, doesn't in fact contain the details of the Gallery item where the button is pressed for passing to the flow.

The Patch to the Account works fine every time.

I really hope that someone can point out what I've done wrong here, because it feels flaky at best.

Any help would be greatly appreciated.

Cheers...

John

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

Mr-Dang-MSFT on at

Like (1)

Report
Hi @BigJohn,

If I'm understanding correctly:

You update a record

You run a flow based on the update

Problem: you intermittently send the wrong account to the flow run

The issue here is that you are performing an update to a row in a gallery. The gallery reloads itself when the update is performed. My suggestion here is to use variables when you want content to be static.

It should be a quick fix in the last line. Instead of ThisItem.Account, point it to your variable patchResult:

CreateAppointment.Run(patchResult.Account);

This removes the formula's reliance on the gallery and points to the variable instead (more static). The variable will only change when you cause it to change whereas the gallery is changing as you have changed it in earlier steps.

Was this reply helpful? Yes No
v-yutliu-msft on at

Like (0)

Report

Hi @BigJohn ,

Could you tell me

1)the data type of Account field?

2)the parameter that you need in your CreateAppointment.Run function.

Based on your description, since Patch function could perform well,ThisItem should return right value.

So I think the problem should be in this formula:

CreateAppointment.Run(ThisItem.Account)

Best regards,

Was this reply helpful? Yes No
BigJohn 54 on at

Like (0)

Report

Thanks Mr Dang, I wasn't aware of the reload when an update was performed.

I've changed to a variable, and it appears to be working.

Thanks for your help.

John

Was this reply helpful? Yes No