I would be looking to move the data in a "single line of text" type field to a lookup field. The Number in the single text data field is the exact number the lookup column uses, in fact I can just copy and paste it to the lookup field and select the parent table and its linked. If its possible I would like to run a flow on the existing child table to populate all the records lookup fields so they all show up in the related section of the parent and subgrid. That relationship is already set up and works fine, which is why i can just copy and paste the number in the text field to the lookup field manually within the App.
If so, should I expect to run into any issues in the flow if any of the child records don't have their parent table row loaded yet? this isn't a big deal, its just been a month or so since I imported the parent accounts so I'm sure some of the child tables rows that are being imported from salesforce wont have a parent loaded in the dataverse yet since more project have been sold since then. Of course I will be running the parent table import again before its said and done, this is purely for my testing purposes.
I cant figure out how to successfully run the child table flow import mapping the lookup field. I was able to make this happen when i was trying it using power query, using keys, but that didn't work well for our data source and was only bringing in one child row per parent account, when some parent accounts have hundreds of related child account. I was told power Query couldn't handle that and that the flow was using, but that came with a whole new set of errors for any fields that were not single row text, currency or date fields. So now I can get all the child rows imported for the child table, but I'm sitting with the data that needs to be in the lookup field existing as a single line text row under the lookup field on the page in the app to just copy/paste it.
So long story short, can I make a flow to populate that lookup field with that existing data in the single line text field?
