I'm building a workflow that would check a date to help forecast expirations and email the user, however, the data fields may not be populated as not every user has to have every credential. I created an AND/OR tree in the condition to check each column of data, where if any of the conditions are true it emails a user.
However, I'm consistently getting the following error:
I'm including a Null function specifically to avoid this type of error and so the flow wouldn't think that a blank was less than today's date plus a certain number of days. I'm really stumped here.
Hi @dbrueggen,
What is your data source?
I think you could directly convert the null value into a string or you could replace the null value with another value:
if(equals(<VALUE TO TEST>,null),'Value if null','value if not null')
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
Announcing a new way to share your feedback with the Power Automate Team.
Power Platform release plan for the 2022 release wave 2 describes all new features releasing from October 2022 through March 2023.
Learn to digitize and optimize business processes and connect all your applications to share data in real time.
User | Count |
---|---|
63 | |
27 | |
21 | |
15 | |
13 |
User | Count |
---|---|
123 | |
46 | |
44 | |
35 | |
31 |