Share
Report
32Hey, 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
All responses (
Answers (
