Answered

Copy a lookup field with blank value don't work (The supplied reference link -- xxxx-- is invalid)

(0) Share

Report

Posted on by FranckBLA

Hello,

I have an issue regarding a flow that copy a lookup field into a field. If in the CRM, the field has a value, the flow works fine. If the record is empty, the entire steps do not work and I have this message "The supplied reference link -- xxxx-- is invalid. Expecting a reference link of the form /entityset(key)."

I know that I can use some test conditions but I can have more than 10 fields to copy in the same step !

Comparing to the old way (Workflow) where it was easier, I'm lot.

Do you know a way to force the copy even the value is empty ?

Many thanks

Categories:

Building flows

I have the same question (0)

All responses (5)

Answers (1)

efialttes 14,756 on at

Like (1)

Report
Sharepoint? Dynamics? CDS?

Can you share a screenshot from your current flow design?

Did you tried aready with a WDL conditional expression empty() based?

if(empty(<your dynamic content here>),'',<your dynamic content here>)

Thanx!

Was this reply helpful? Yes No
abm abm 32,865 Most Valuable Professional on at

Like (0)

Report

Hi @FranckBLA

You can achieve this in different ways.

1. Add an If condition to check whether the value is null or empty then set the variable as null or the value.

2. Try using expression coalsec(yourdynamicfield,null). This might be easier. I haven't tested from my side. So please try and let me know.

3. You can add one single expression like below

if(greater(length(outputs('Compose')),0),float(outputs('Compose')),null)

Thanks

Thanks

Was this reply helpful? Yes No
FranckBLA 5 on at

Like (0)

Report

Thanks for your answer,

The screenshots below show how I set steps into CRM.
As I can have a lot of fields to copy, I though that use If condition is not a solution.
I can try the others solutions you propose. Can you help me please ?

Was this reply helpful? Yes No
Verified answer

abm abm 32,865 Most Valuable Professional on at

Like (1)

Report

Hi @FranckBLA

Not sure you can use the coalsec expression with contact to construct the string you want. Since these are composite lookups I can see you are setting with entity schema name and dynamic mapping value. So your only option is the IF condition for each ones.

Thanks

Was this reply helpful? Yes No
shadzk 15 on at

Like (1)

Report

I was having error this error: The supplied reference link -- systemusers() -- is invalid. Expecting a reference link of the form /entityset(key).

I just used this and it worked

Was this reply helpful? Yes No