Patching a choice column using the choice from another table selected via gallery

(0) Share

Report

Posted on by Alastairs

129

Good morning

I have 2 tables nov_agreements and nov_meters

both have a column called type with 3 choices.

from a list of agreements i want to add a meter. I select the agreement in the gallery and then go to create a meter.

I want to patch the type field with the type value from the selected agreement. this is what i have

Please let me know if you need any further information.

Thanks in advance. Alastair

Categories:

Building Power Apps

I have the same question (0)

All responses (10)

Answers (1)

Rajkumar_M 3,741 Super User 2025 Season 2 on at

Like (0)

Report
Hi @Alastairs

If you patch data to choice column you should use this formula

type: {Value: nov_agree_gal.Selected.type}

{
mprx: meter_edit_mprx_txt_4.Text,
eac: Value(meter_edit_eac_txt_4.Text),
g_ref: nov_agree_gal.Selected.gref
m_ticket_ref: nov_sel_gal.Selected.m_ticket_ref,
type: {Value: nov_agree_gal.Selected.type}
}

Thanks!

If my response has been helpful in resolving your issue, I kindly request that you consider clicking "Accept as solution" and "giving it a thumbs up" as a token of appreciation.

Was this reply helpful? Yes No
Alastairs 129 on at

Like (0)

Report

Thanks for looking at this. unfortunately that is giving an error still

Was this reply helpful? Yes No
Rajkumar_M 3,741 Super User 2025 Season 2 on at

Like (0)

Report
Why you use same combo box to two different column.

{
g_ref: nov_agree_gal.Selected.gref

type: {Value: nov_agree_gal.Selected.type}
}

Was this reply helpful? Yes No
Alastairs 129 on at

Like (0)

Report

the 2 tables have the same column as i'll need them for different reports however as all meters under the agreement will have the same type i wanted to eliminate the ability for users to select the wrong one

Was this reply helpful? Yes No
Rajkumar_M 3,741 Super User 2025 Season 2 on at

Like (0)

Report
Try this,

type: { Value: nov_agree_gal.Selected.type.Value }

(Or)

type: nov_agree_gal.Selected.type.Value

Was this reply helpful? Yes No
Alastairs 129 on at

Like (0)

Report

Still the same issue i'm afraid

Was this reply helpful? Yes No
Rajkumar_M 3,741 Super User 2025 Season 2 on at

Like (0)

Report

What is the data type of g_ref column ?

Share current updated formula ?

Was this reply helpful? Yes No
Alastairs 129 on at

Like (0)

Report

the q_ref column works fine, it's the type thats not working and that is a choice

Was this reply helpful? Yes No
Rajkumar_M 3,741 Super User 2025 Season 2 on at

Like (0)

Report

Refer this threads : https://powerusers.microsoft.com/t5/Building-Power-Apps/How-do-I-patch-an-optionset-field/td-p/487523

https://powerusers.microsoft.com/t5/Building-Power-Apps/How-to-patch-an-option-set-field/td-p/422578

Thanks!

Was this reply helpful? Yes No
Verified answer

Alastairs 129 on at

Like (0)

Report

so i've created a workaround, i've put in a drop down box that defaults to the type of the selected agreement and then uses the selected option to patch the meter table.
I've then hidden the drop down and pretended i've done it properly.

Thanks for your help though

Was this reply helpful? Yes No