cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
colbyc
Helper IV
Helper IV

Make value of field equal to value of field in another list without LookUp Column

Hello,

I have List A and List B. List A and List B contain a lot of similar fields, with List B copying over the values of List A via lookup fields. At this point though I am out of lookup fields allowed but need one more column to pull a value over from List A to List B. 

 

I am in the form of List B and have added both A and B as connections. I need the default value of a field called "Change Type" on list B to be equal to the the Change Type field of list A. There is a secondary field called 'ACR No' that can be used as the unique value to reference (Change Type will not be unique).

 

Current code looks like this but I'm not sure its correct at all (DataCardValue35_1 is the 'ACR No' field for List B: LookUp('Application Change Request', DataCardValue35_1 = 'Application Change Request'.'ACR No')

25 REPLIES 25

@RandyHayes that (kind of) worked! The Change Type value is now appearing on the edit/view form as the default value. Its not though appearing as the actual value on the list itself... the column looks empty until I click on the entry and see it on the form. Is there somewhere I can put this to get it to appear on the list? Was I wrong trying to put in the Default box?

@colbyc 

So are you actually writing it to your SharePoint list??

What is the Update property of the DataCard that has DataCardValue10 in it?

Yes, the lookup will work all the time, but unless you are writing that into your actual SharePoint List, it's not going to appear anywhere else.

_____________________________________________________________________________________
Digging it? - Click on the Thumbs Up below. Solved your problem? - Click on Accept as Solution below. Others seeking the same answers will be happy you did.
NOTE: My normal response times will be Mon to Fri from 1 PM to 10 PM UTC (and lots of other times too!)
Check out my PowerApps Videos too! And, follow me on Twitter @RandyHayes

Really want to show your appreciation? Buy Me A Cup Of Coffee!

@RandyHayes I'd like to actually write it to the SP list...the current Update value is DataCardValue10.Text

@colbyc 

Okay...that's a good start.  That appears to be the correct formula assuming that the ACR No in your SharePoint list that your EditForm is connected to is a text column.

Have you actually submitted a form?  Have you looked at your SharePoint list to see if the value is written into the proper column?

_____________________________________________________________________________________
Digging it? - Click on the Thumbs Up below. Solved your problem? - Click on Accept as Solution below. Others seeking the same answers will be happy you did.
NOTE: My normal response times will be Mon to Fri from 1 PM to 10 PM UTC (and lots of other times too!)
Check out my PowerApps Videos too! And, follow me on Twitter @RandyHayes

Really want to show your appreciation? Buy Me A Cup Of Coffee!

@RandyHayes 

 

Just figured it out myself, needed to put in same parameters on the new form as well as edit. Thank you so much for all your help! Will go back and mark one of your earlier responses as Solution.

@colbyc 

Glad to help!

_____________________________________________________________________________________
Digging it? - Click on the Thumbs Up below. Solved your problem? - Click on Accept as Solution below. Others seeking the same answers will be happy you did.
NOTE: My normal response times will be Mon to Fri from 1 PM to 10 PM UTC (and lots of other times too!)
Check out my PowerApps Videos too! And, follow me on Twitter @RandyHayes

Really want to show your appreciation? Buy Me A Cup Of Coffee!

Helpful resources

Announcements
Power Platform Call June 2022 768x460.png

Power Platform Community Call

Join us for the next call on August 17, 2022 at 8am PDT.

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Users online (2,333)