Share
Report
578I have a Dataverse table that has two columns (State and Estado). When the data was imported from SharePoint, the State column had the State Code followed by State Name (e.g. 22 - Louisiana). Now the Estado column is a lookup column where I need to remove the code and show only the State name. I really can't figure out how just copy the data from State to Estado using split. The split function is not the issue, using last(split(items('Apply_to_each')?['cr39c_state'], ' - ')) returns what I need. ). These are the steps I'm following.
1. List Rows from the table
2. Apply to each of the List Rows values
3. Update a row using the an unique identifier: items('Apply_to_each')?['cr39c_name'].
Now is when the issues start. When I'm updating the Estado column. I'm not sure if I should refer to the column within the table that contains the State with the code (State) or if I have to refer to the lookup table (States):
I seen some info only about EntityName, but I'm not sure what entity I'm supposed to be referring to. In the image above I used the entity name for the States, but I just get an error:
{
"error": {
"code": "0x8006088a",
"message": "Bad Request - Error in query syntax."
}
}
Any ideas here?
Thanks in advance.
All responses (
Answers (
