Power Platform Community Forum Thread Details

Hey, not had much luck with this discussion group but lets see.

I have a lookup column that i am patching with 'Add new row' with dataverse.

I am doing this :

And this works - so i have the table name and a variable which holds the guid.

If the guid is empty then i just want to patch NOTHING

So I have looked at

if(empty(item()?['InvoiceRecipient.DisplayName']),null,item()?['InvoiceRecipient.DisplayName'])

Then works in my example variable but as i want to add the exact command if it is NOT NULL then I am struggling as this causing an error :

if(contains(outputs('Compose'),null),"",/avg_uwproducttables({outputs('Compose')}))
/avg_uwproducttables(@{outputs('Compose')})

and i guess it is becasue the /avg_uwproducttables is in the column (so to speak) and not in a formula

as my screenshot highlights

So how can i make this IF statement partly as an expression and partly as text in the field ? As per my screenshot.

Any help would be amazing...

Thanks alot guys and gals

Categories:

Empty lookup - Add new row dataverse