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)

Sort by

Rajkumar_M 3,747 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
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
a
(0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Rajkumar_M 3,747 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
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
a
(0)

Report
Copy link

Link copied!

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,747 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
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
a
(0)

Report
Copy link

Link copied!

Still the same issue i'm afraid

Was this reply helpful? Yes No
Rajkumar_M 3,747 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

What is the data type of g_ref column ?

Share current updated formula ?

Was this reply helpful? Yes No
Alastairs 129 on at

Like
a
(0)

Report
Copy link

Link copied!

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,747 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

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
a
(0)

Report
Copy link

Link copied!

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