Showing results for 
Search instead for 
Did you mean: 

Update Lookup Column with NULL🔎🚫

This short guide will show one of possible solutions how to prevent a Cloud Flow action from failing when a lookup column output from a previous action is "null/does not contain data".

By implementing a custom expression function, you can failproof the action and keep each lookup column empty if required.

I have prepared a test cloud flow that permanently fails when executed because GUID = Null:


Skærmbillede 2023-05-19 120615.png


I am trying to update a "parentcustomeid" lookup of a Parent Contact and input must be "/entityset(key)" where:

• entityset - table entity set name that can be copied from related table configuration page.
• key - GUID of a row

Normally your action field could look like this:


"Account Name (Accounts)"      /accounts(triggerOutputs()?['body/accountid'])

Uden titel1.jpg

I suggest we add an Expression Function for the field using a string below:


if(Equals(triggerOutputs()?['body/accountid'], null), '', concat('/accounts(', triggerOutputs()?['body/accountid'], ')')) 


Skærmbillede 2023-05-19 125217.png


Each expression function should be applied per/for each lookup column.

The logic behind this expression function is similar to Condition action except it is simply contained in a single line of text.


1. "If" checks whether our statement is true or false. In our case "if" (true) "Account" from "trigger outputs" "equals" "null", then the column will be kept clean by adding two single quotation marks - ''.

2. Otherwise "if" false, then it means that data (GUID) is present and we have to "concatenate" the similar " / accounts( triggerOutputs()?['body/accountid'] ) " formulas several parts it contains to maintain its structure inside a function expression.

If correctly done you normally won't be bothered with failure notifications and operations in your CRM won't be interrupted. 😉


This is very useful. I was trying to set a flow to create a backup of my sharepoint lists to a csv file. I had couple of null values in a lookup column and my flow was failing. I applied your concept and it works. Thanks a lot!

@aizardar Thank you! Even though in my example I used Dataverse connector (should have specified that with tags or in a topic...), I am very glad to hear that same principle works for SharePoint. 😊

@artdlov - Concat() is great idea

About the Author
  • Experienced Consultant with a demonstrated history of working in the information technology and services industry. Skilled in Office 365, Azure, SharePoint Online, PowerShell, Nintex, K2, SharePoint Designer workflow automation, PowerApps, Microsoft Flow, PowerShell, Active Directory, Operating Systems, Networking, and JavaScript. Strong consulting professional with a Bachelor of Engineering (B.E.) focused in Information Technology from Mumbai University.
  • I am a Microsoft Business Applications MVP and a Senior Manager at EY. I am a technology enthusiast and problem solver. I work/speak/blog/Vlog on Microsoft technology, including Office 365, Power Apps, Power Automate, SharePoint, and Teams Etc. I am helping global clients on Power Platform adoption and empowering them with Power Platform possibilities, capabilities, and easiness. I am a leader of the Houston Power Platform User Group and Power Automate community superuser. I love traveling , exploring new places, and meeting people from different cultures.
  • Read more about me and my achievements at: MCT | SharePoint, Microsoft 365 and Power Platform Consultant | Contributor on SharePoint StackExchange, MSFT Techcommunity
  • Encodian Owner / Founder - Ex Microsoft Consulting Services - Architect / Developer - 20 years in SharePoint - PowerPlatform Fan
  • Founder of SKILLFUL SARDINE, a company focused on productivity and the Power Platform. You can find me on LinkedIn: and twitter I also write at, so if you want some Power Automate, SharePoint or Power Apps content I'm your guy 🙂
  • I am the Owner/Principal Architect at Don't Pa..Panic Consulting. I've been working in the information technology industry for over 30 years, and have played key roles in several enterprise SharePoint architectural design review, Intranet deployment, application development, and migration projects. I've been a Microsoft Most Valuable Professional (MVP) 15 consecutive years and am also a Microsoft Certified SharePoint Masters (MCSM) since 2013.
  • Big fan of Power Platform technologies and implemented many solutions.
  • Passionate #Programmer #SharePoint #SPFx #M365 #Power Platform| Microsoft MVP | SharePoint StackOverflow, Github, PnP contributor
  • Web site – Youtube channel -