Hi,
I have a flow working based on sharepoint list that warns me when a date approuches. It works fine but it fails when a cell is empty. Any idea how I can skip the empty cells?
@lessOrEquals(items('Apply_to_each')?['Contract_x0020_end_x0020_date'], adddays(utcnow(), 30))
Solved! Go to Solution.
Hi @Anonymous,
Do you mean skipping the item with a null value in the date field?
You could try to use Filter array to filter the date field containing the value of the item, and then use Filter array- output value to configure the following steps, which is to replace the output of the original Get items with the output of the Filter array.
Image reference:
Take a try.
Best Regards,
Barry
I would tend to use something like this:
@not(empty( ** Nest in here ** ))
You'll need to use it relevant to your Flow but I have have succeeded with this as it basically means, Return true if not empty.
Proud to be a Flownaut!
Hi @Anonymous,
Do you mean skipping the item with a null value in the date field?
You could try to use Filter array to filter the date field containing the value of the item, and then use Filter array- output value to configure the following steps, which is to replace the output of the original Get items with the output of the Filter array.
Image reference:
Take a try.
Best Regards,
Barry
Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.
Watch Nick Doelman's session from the 2020 Power Platform Community Conference on demand!
User | Count |
---|---|
40 | |
36 | |
35 | |
32 | |
27 |
User | Count |
---|---|
37 | |
37 | |
33 | |
26 | |
22 |