Unanswered

Copy One Field to Another Field

(0) Share

Report

Posted on by mogulman

764

I thought this would be simple. I'm using an SQL Server connection to an on-premise server. I have a Client form and I want to copy the Billing address to the Shipping address (attached). I have a button to trigger copy (CopyBilling2Shipping). In the OnSelect property of the button I have:

OnSelect = ShippingStreetVal.Text = BillingStreetVal.Text (the Val fields are the datacard value fields).

I don't get any errors but nothing happens. I'm sure there is a simple fix but I've looked around and can't find it.

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

dinusc Microsoft Employee on at

Like (1)

Report

You cannot use simple assignments here as your "ShippingStreetVal.Text" is probably already bound to its parent card value.
You can get some ideas of how this can be done from here:
https://powerusers.microsoft.com/t5/Creating-Apps/How-to-enable-a-Same-as-Shipping-Billing-address-feature/m-p/117497#M2478

Was this reply helpful? Yes No
mogulman 764 on at

Like (0)

Report

It did give me some ideas on how to solve.

1. Used button to set context variable (copyB2S)
2. In each datacard set Default to If(copyB2S, BillingStreetVar.Text,ThisItem.ShippingStreet)
3. On save I refresh data if copyB2S is set and then unset.

SubmitForm(ClientEditFM);If(copyB2S,Refresh('[dbo].[Client]'),false);UpdateContext({copyB2S:false})

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

Like (0)

Report
Hi @mogulman,

Have you solved your problem?

I have made a test on my side and please take a try with the following steps:

Set OnSelect property of CopyBilling2Shipping button control to following formula:

UpdateContext({ButtonPress:true})

Unlock the DataCard where you want to show copied result.

Select the TextInput control within the above DataCard control, set Default property of this TextInput control to following formula:

If(ButtonPress=true,BillingStreetVar.Text,Parent.Default)

Set OnSelect property of Submit button control to following formula:

SubmitForm(ClientEditFM);If(ButtonPress=true,Refresh('[dbo].[Client]'),false);UpdateContext({ButtonPress:false})

If you have solved your problem, please click "Accept as Solution" so that this thread will be marked for other users to easily identify if your problem is solved.

Best regards,

Kris

Was this reply helpful? Yes No