cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ecrevisse
Helper II
Helper II

Coalesce Function, how it work ?

Hi everyone, 

 

i would like to get to know you better function COALESCE. 

i will monitor my Sharepoint list and there is below expression 

 

Item: 

 

coalesce(triggerBody()?['Title'],'An item')
 
was modified at:  
 
coalesce(triggerBody()?['Modified'],'')
 
by 
 
coalesce(triggerBody()?['Editor']?['DisplayName'],'someone')
 
How to read this expression ? 
 
D. 
 
1 REPLY 1
ekarim2020
Community Champion
Community Champion

See: https://docs.microsoft.com/en-us/azure/logic-apps/workflow-definition-language-functions-reference#c...

coalesce - Return the first non-null value from one or more parameters. Empty strings, empty arrays, and empty objects are not null.

Examples taken from the above reference:

 

coalesce(null, true, false)      -----> true
coalesce(null, 'hello', 'world') -----> hello
coalesce(null, null, null)       -----> null

 

Ellis

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Top Solution Authors
Top Kudoed Authors
Users online (1,385)