Hi,
I have createda project plan and a Flow to send a reminder if a certain step is overdue.
My project plan is an Excel saved on sharepoint, if the column "First Draft Completion Date" is blank, that means the step is not completed. I want to create a condition which says
condition1" "First Draft Completion Date" is blank, then go to condition 2
condition 2" if "First Date Completion Deadline" is less than utcnow(), then send a email reminder
However, despite the column "First Draft Completion Date" is blank, the first condition output is always false . Can someone help?
Thanks!
Solved! Go to Solution.
Hi @Anonymous ,
You could remove 0 and set the parameter to the right of the condition to blank.
Please take a try.
Best Regards,
Hi @Anonymous
For checking Condition1" "First Draft Completion Date" is blank you need to use the expression function null. Remove the zero and add the null from the expression function.
If you liked my response, please consider giving it a thumbs up
Proud to be a Flownaut!
Learn more from my blog
Hi @Anonymous ,
You could remove 0 and set the parameter to the right of the condition to blank.
Please take a try.
Best Regards,
Thank you, abm!
However, I had tried changing zero into null. That didn't work either. I think it's because I have done conditional formatting with that column.
Hi @Anonymous
Try to use the expression length and check zero. If not try @v-bacao-msft suggestion.
If you liked my response, please consider giving it a thumbs up
Proud to be a Flownaut!
Learn more from my blogExcept data put function
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
Learn to digitize and optimize business processes and connect all your applications to share data in real time.
User | Count |
---|---|
29 | |
27 | |
23 | |
17 | |
10 |
User | Count |
---|---|
66 | |
58 | |
29 | |
27 | |
25 |