patch record based on condition in powerapps

(0) Share

Report

Posted on by Newbie12

227

Hi,

My Datasource is Excel,which contains columns "Ref No","Cancel Reservation","Cancel Reason","Current Status" & "Steps". I have Gallery on my Screen,which contains "Ref No" and other information. When User Clicks on their desired "Ref No", it navigates them to the form (Edit Mode), which consists of "Cancel Reservation","Cancel Reason","Current Status" & "Steps". I used visible property of the datacard such that when User Selects "Y" from "Cancel Reservation" datacard it display them "Cancel Reason" and "Current Status" datacard. When User Selects "N", it displays them "Current Status" and "Steps" datacard. I would like to patch my form based on User selection. Ex. If User selects "Y" under Cancel Reservation, then the data that need to be patch are for columns "Cancel Reason" and "Current Status". If User selects "N", then "Current Status" and "Steps" column should be patch to the Excel. I am not sure if something like this is possible ?

The "OnSelect" of Submit button is set to Submitform(form1).

Thanks in advance for your time!

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Sort by

WarrenBelz 155,290 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi @Newbie12 ,

One question first - why are you needing to do this when SubmitForm() will send the required data -it there is nothing in the other fields, then nothing will be updated in them (the visibility of a card does not affect its operation in Update).
You can certainly do a conditional Patch based on the selection.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Was this reply helpful? Yes No
Newbie12 227 on at

Like (0)

Report
Copy link

Link copied!

Hi @WarrenBelz ,

Whenever, I select "N" under Cancel Reservation, and add data to Current Status and Steps columns. It also add data from "Cancel Reason" column. "Cancel Reason" contains dropdown items such as "System Issue","Connectivity Issue","Other" etc.

Was this reply helpful? Yes No
Verified answer

WarrenBelz 155,290 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!
Hi @Newbie12 ,

There are other workarounds for this including conditional Update properties on Cards and using Combo boxes, which do not have a value in them unless you select it, however going with the Patch (and Excel causes some limitations here), if you put a button in a Custom Card on the form, you would do something like this OnSelect

If( YourCancelReservationDD.Selected.Value="Y", Patch( YourTableName, ThisItem, { 'Cancel Reason':YourCancelReasonBox.Text, 'Current Status':YourCurrentStatusBox.Text } ), Patch( YourTableName, ThisItem, { 'Steps':YourStepsBox.Text, 'Current Status':YourCurrentStatusBox.Text } ) )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Was this reply helpful? Yes No
Newbie12 227 on at

Like (0)

Report
Copy link

Link copied!

@WarrenBelz. Thank you!

Was this reply helpful? Yes No