When patching from a Collection to Dataverse the Lookup value does not save/upload

[Bob_Bland]

Hey everyone,

Due to the needs of my company, I am creating an offline first app. The data is saved into a collection and when the user has internet or phone service, they can sync the collections back to dataverse.

The issue I am having is with a lookup column. I have two tables (System Materials and System Materials History), where System Materials History has a lookup column with System Materials information. The data can save when downloaded to the collections, can be added to the collection using information of the System Material collection, but will not upload the lookup to DataVerse when it is sync'd.

I have tried a basic collection and patch to no avail. I am using a ForAll because I am uploading multiple records at once.

The closest I have gotten is 

Unfortunately the LookUp is just the first Material (Material-00000) every time. Even when the actual offline Lookup refers to the correct record. 

Thank you all so much for the help in advance. 

Above the code pictured is the code for patching the System Materials and it works perfectly, so the actual data to be looked-up is there.

[v-jefferni]

Hi @Bob_Bland ,

Would you like to patch a LookUp field to Dataverse?

If so, to patch LookUp column, the right syntax would be as follows:

Patch('SP list', Default('SP list'), {LookUpColumn: LookUp(Choices('SP list'.LookUpColumn),Value = "Test Value")})

On your end, it could be:

{'Material LookUp': LookUp(Choices([@SystemMaterials].'Meterial Name'),Value = ThisRecord.'Material Name')
}

Please have a try and hope this helps.

Best regards,

Community Support Team _ Jeffer Ni
If this post helps, then please consider Accept it as the solution to help the other members find it.

[Bob_Bland]

Hey @v-jefferni 

Thank you for your reply. 

Yes I am trying to patch a lookup field to dataverse from a collection.

I tried your solution and it looks like it wants to work, but I am still getting an issue with the data. Now it is saying that I am missing a column and the schema of the record is incorrect.

 

Would I need to DropColumn somewhere before?

Thanks again for the help.

[v-jefferni]

Hi @Bob_Bland ,

There is one extra opening parenthesis next to LookUp, meanwhile a closing parenthesis at last is missing.

Please just replace your 'Material LookUp' sentence with everything inside the curly braces in my formula:

{'Material LookUp': LookUp(Choices([@SystemMaterials].'Meterial Name'),Value = ThisRecord.'Material Name')
}

Best regards,

Community Support Team _ Jeffer Ni
If this post helps, then please consider Accept it as the solution to help the other members find it.

[Bob_Bland]

Hello @v-jefferni , 

I replaced the lookup with what you said and am still getting the error issue. 

If I go to settings and turn on explicit column selection could that help anything?

From what I understand the Owner lookup is a default lookup in the dataverse tables, but it is not referenced in my app anywhere. 

Thanks for your help

[v-jefferni]

Hi @Bob_Bland ,

My bad, did not notice it is Dataverse in your case.

So, try below:

LookUp(Choices([@SystemMaterials].'Meterial Name'),'Meterial Name' = ThisRecord.'Meterial Name')

Best regards,

Community Support Team _ Jeffer Ni
If this post helps, then please consider Accept it as the solution to help the other members find it.

[Bob_Bland]

Hello @v-jefferni 

Unfortunately I am still having issues. 

When I put in the code you suggested I still have the errors with locating the lookup and having the name be recognized 

I tried the same code but using the system material history as the lookup base and got a result that had no errors, but when I ran the code, the system couldn't find the "property" as shown below.

Thanks for your continual help in this. I feel as though I am missing something obvious because I can't seem to make lookups work when going from collection to dataverse. 

[v-jefferni]

Hi @Bob_Bland ,

Could you please double check the table name of Dataverse? Since I have noticed that table names in both Patch and Defaults functions are showing in Black which indicates they are not correct:

Best regards,

Community Support Team _ Jeffer Ni
If this post helps, then please consider Accept it as the solution to help the other members find it.

[Bob_Bland]

Hello @v-jefferni 

The table name is correct. All of my Patches go to the right table in dataverse and are all black when nestled in a ForAll statement.  

The actual tables and patching still work completely normal for my other tables. Its only Lookups data columns from collection to dataverse that aren't uploading correctly. 

[Bob_Bland · Accepted solution]

Bit of an update: I have gotten it to partially work

By changing the column name it patches the correct lookup IF the parent item has been uploaded to Dataverse before this sync and is recognized as an existing option choice in dataverse.

In other words, when a user logs in for the first time and has their data come from Dataverse to their collection, then they can patch existing System Materials and System Materials History, but if they create the parent System Material offline and try to patch a System Material History item of the same name, they get the "Value must be a data entity record" error when syncing. 

This leads me to believe that for a lookup to work in Dataverse, there is something I cannot or am not adding to the record in my collection.