Compare between two tables and update lookup column CDS

[Hassan_]

Hello,

I'm trying to compare two columns from different tables and if matches > update the lookup field 

12

3

this is the lookup field with the entityschemanameinplural(GUID)

4

and also tried/entityschemanameinplural/GUID but no luck

5  I have done the "Create new record with setting the lookup field" but when I try the above it didn't work with the same way

Solved: Re: Trying to build a flow to create a new item CD... - Power Platform Community (microsoft....

1 - I'm I doing it the right way for comparing?

2- What is wrong with entityschemanameinplural(GUID)

Please help

thanks in advance 

[Hassan_]

@Mira_Ghaly 

Dear Mira,

Can you help me on this

and most kind thank you in advanced

[Mira_Ghaly]

@Hassan_

Can you try using cr7bc_customers_tses

[Hassan_]

@Mira_Ghaly 

Hello Mira,

Still the same 

    "message": "Resource not found for the segment 'cr7bc_customers_tses'."

[Mira_Ghaly]

@Hassan_ 

On your dataverse table can you show me the lookup field; how it looks/configured?

[Hassan_]

@Mira_Ghaly 

this is the relationship

Column

and this is the field created by the relationship 

Relationship

[Mira_Ghaly]

@Hassan_ 

did u try cr7bc_customers_t?

[Hassan_]

yes i did but didn't work

[Mira_Ghaly]

@Hassan_ 

screenshot please of the customers table schema name

[Hassan_ · Accepted solution]

Hello @Mira_Ghaly 

thank you for your kind support, it just worked like you explained before, don't know why didn't go before. 

4

Appreciate your support Mira

[Hassan_ · Accepted solution]

Hello @Mira_Ghaly 

Finally, I find the problem, it is case-sensitive

so when I use cr7bc_Customers_TS didn't work 
But when I use cr7bc_customers_ts It work successfully
Thanks again for your kind help

[Hassan_]

Also, If you put spaces it will not work. however, to solve this:

This is the table name:

1 Table Name

This is how to write it on the flow:

2 work like this

I hope this save your time