Answered

"ne null" Not Working under Get Items Filter Query

(0) Share

Report

Posted on by austinchi

Hello,

I have a scheduled flow that runs every month and sends out emails if the "Planned Kick Off Date" matches the date that the flow runs. It works as intended however every time it runs it appears as "Failed" with the error "Unable to process template language expressions for action 'Condition' at line '0' and column '0': 'The template language function 'formatDateTime' expects its first parameter to be of type string. The provided value is of type 'Null'." My assumption is that the Get Items are retrieving null values as there are empty cells under the column "Planned Kick Off Date". My idea was to filter out the nulls before the further Apply to Each step by adding the expression "Planned Kick Off Date ne null" under Get Items Filter Query. However I am getting the error below:

"The expression "Planned Kick Off Date ne null" is not valid. Creating query failed."

What did I do wrong? I am attaching a few screen shots for reference. I would really appreciate if someone could help me figure out where the issue is.

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Verified answer

creativeopinion

10,508 Moderator on at

Like (1)

Report

Copy link

Link copied!

@austinchi You will need to use the internal column name of your Project Kick of Date column. Keep in mind that the internal column name may not always match the name displayed in your Sharepoint list. If you aren’t sure how to get this, please refer to this section of one of my YT tutorials.

For more flow troubleshooting tips—check out this YT Tutorial: 5 Power Automate Troubleshooting FAQs and Helpful Tips for Creating Better Flows

In this tutorial I cover:

✅ How to troubleshoot a false Condition action result

✅ How to get dynamic content when it isn’t selectable from the list of dynamic content

✅ How to troubleshoot an Apply to Each action that isn’t looping through

✅ How to troubleshoot a skipped Apply to Each action

✅ How to troubleshoot a Filter Query

✅ How to use a SharePoint yes/no column in a Filter Query

✅ How to use Compose actions to troubleshoot a Power Automate flow

✅ How to troubleshoot multiple emails being sent

✅ How to troubleshoot multiple Teams messages being sent

Hope this helps!

If I helped you solve your problem—please mark my post as a solution ✅.
Consider giving me a 👍 if you liked my response! If you're feeling generous— ☕️ Buy me a coffee: https://www.buymeacoffee.com/acreativeopinion

👉 Watch my tutorials on YouTube
👉 Tips and Tricks on TikTok

Was this reply helpful? Yes No

austinchi 5 on at

Like (0)

Report
Copy link

Link copied!

Worked like a champ! Thank you very much for the solution!

Was this reply helpful? Yes No