Unanswered

Set rule based on specific date

(0) Share

Report

Posted on by Sesese

Hi guys,

I have an issue with my flow on setting a rule based on a date.

In my flow I register all the elements from a microsoft form; if a string/date field is empty, autocamically the flow replace the blank cell with "1/1/2001", otherwise I receive an error because that specific cell can't be blank.

Now my issue is related to the fact that I need that cell to be blank and not filled with the variable

The compose formula is this

if(equals(outputs('Crea_elemento')?['body/Deadline'],variables('null')),replace(outputs('Crea_elemento')?['body/Deadline'],'

variables('null'),'-'),outputs('Crea_elemento')?['body/Deadline'])

At the end, this formula doesn't replace what I expect

Categories:

Building flows

I have the same question (0)

All responses (5)

Answers (0)

Expiscornovus 33,755 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
Hi @Sesese,

Just to double check. If the Deadline field in the Crea elemento action is empty you want to populate it with 1/1/2001.

If that is correct you could use an empty function for this.

if(empty(outputs('Crea_elemento')?['body/Deadline']), variables('null'), outputs('Crea_elemento')?['body/Deadline'])

Was this reply helpful? Yes No
Sesese on at

Like (0)

Report
Copy link

Link copied!

In the "create element" I have already defined this rule in order to have that fixed date, otherwise the flow gives me an error.
After that, I want to delete that fixed value and have an empty value

Was this reply helpful? Yes No
Expiscornovus 33,755 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
Hi @Sesese,

If you want to clear the value you can probably just use this expression instead:

if(equals(outputs('Crea_elemento')?['body/Deadline'], variables('null')), '', outputs('Crea_elemento')?['body/Deadline'])

Was this reply helpful? Yes No
Sesese on at

Like (0)

Report
Copy link

Link copied!

It seems it doesn't work, on the sharepoint table the value is still there

Was this reply helpful? Yes No
Expiscornovus 33,755 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi @Sesese,

Can you show me where you are using this expression? In addition to that can you show me how your Deadline column is configured in SharePoint, can you share a screenshot of the settings of that column?

Was this reply helpful? Yes No