I created a quick PowerApps to copy records from one SharePoint list to a similar, new one. Made some tweaks in the new list, and one of those was to make a column a lookup ; the source table for the copy has the column as a single line of text.
When the app runs, all the records copy over, but just two of them have a value in the new lookup column and neither of those values correspond to the value of the text columnin the source. The remainder are just blank.
The app is very simple: I created two galleries, one with items = 'source table' and the other with items = 'target table' and a button that contains the following expressions:
The red part is what is not working properly. Since all of the other fields do copy properly, I have assumed that the FORALL causes the data to advance in the source list and that by grabbing those values in the PACTH it would work. So, Store as a text field in the source should copy over as the "lookup" result in the target, right?
I have tried at least a dozen expressions and this is the only one that did not give me a PATCH error on the button.