cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
carem
Advocate II
Advocate II

Update an Additional Lookup Field in Sharepoint List using new label Control?

I have a Sharepoint List name "Assets", and have 1 lookup column point to Repair Shop:

Assets List have 3 Column:

 - Asset name (Single Line of Text)

 - Repair Shop (Lookup)

- Repair Shop Address (Additional Lookup)

When I create a  canvas app for this list:

- When editing a record, if I choose another Repair Shop, the Repair Shop Address doesn't dynamically change.

My work around:

I can set up a label and set the Text property: 

LookUp(RepairShopDataSource, ShopName = RepairShop.Selected.Value, Address); and the only thing I need to do is hide the Datacardvalue.

But I want more:

I want to know that if I can update that Field in Source by that Label. That requires a record to submit data. I mean:

 - Old Update using Invisible Datacardvalue: DatacardValue.Selected

 - New Update Property using the New Label: What the formula is?

1 ACCEPTED SOLUTION

Accepted Solutions
v-monli-msft
Community Support
Community Support

Hi @carem ,

 

I understand why you want to use a custom data card rather than the old one. I guess that you just want to make the Repair Shop Address also change its display value in edit form dynamically. But you really do not need to update this column with your customized data card, since the results are the same. And if you must know, you cannot modify this field in PowerApps since the field should be read only. If you change the Update property of this field to other formulas, when you submit the edit form, it will give you the error.

 

Regards,

Mona

 

 

 

Community Support Team _ Mona Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

2 REPLIES 2
Edwin-Abdalian
Impactful Individual
Impactful Individual

Please explain why would you need to update the address column? you just need to update the main lookup column which is the RepairShop column in you SharePoint list. as soon as you update that, the addrees field will be updated aqutomatically.

v-monli-msft
Community Support
Community Support

Hi @carem ,

 

I understand why you want to use a custom data card rather than the old one. I guess that you just want to make the Repair Shop Address also change its display value in edit form dynamically. But you really do not need to update this column with your customized data card, since the results are the same. And if you must know, you cannot modify this field in PowerApps since the field should be read only. If you change the Update property of this field to other formulas, when you submit the edit form, it will give you the error.

 

Regards,

Mona

 

 

 

Community Support Team _ Mona Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
Power Apps Africa Challenge 2022

Power Apps Africa Challenge

Your chance to join an engaging competition of Power Platform enthusiasts.

Super User 2 - 2022 Congratulations

Welcome Super Users

The Super User program for 2022 - Season 2 has kicked off!

September Events 2022

Check out all of these events

Attend in person or online, there are incredible conferences and events happening all throughout the month of September.

Government Carousel

New forum: GCC, GCCH, DoD - Federal App Makers (FAM)

In response to the unique and evolving requirements of the United States public sector, Microsoft has created Power Apps US Government.

Users online (2,412)