The runtime value '""' to be converted doesn't have the expected format 'String/date'.

[Qistina]

Hello, I'm building a flow that connects MS Form responses to be automatically updated into a Sharepoint list.

This is the question in MS Form.
If responder chooses Yes, it will answer the next question (name and date).
If responder chooses No, it will go to the next section, skipping the name and date question.

It's not a problem if responder chooses Yes, but it will be a problem if responder chooses No which means they skip the question. Skipping the name is fine, skipping the date is not however (Ive tested this scenario).

This is the error that I get in Power Automate:

How do I fix this? The column format for the Date column in Sharepoint is already in a date format.

Please advise. Thank you very much

[v-bofeng-msft]

Hi @Qistina ,

You could consider adding an 'if' statement to check if the field's value is equal to '""', and replace it with 'null' if it is. For example:

If(equals(TheSpecificValue,''),null,TheSpecificValue)

Best Regards,

Bof

[Qistina]

Hi Bof,

thanks again for responding. may I know where can I add that? I did it like this but it doesn't seem right

[v-bofeng-msft · Accepted solution]

Hi @Qistina ,

You could use this formula as a value directly , just replacing the erroneous part.

If(equals(TheSpecificValue,''),null,TheSpecificValue)

Best Regards,
Bof

[Qistina]

Hi @v-bofeng-msft 
Is this correct? The same error persist though

This is how I write it for the expression:

If(equals(outputs('Get_response_details')?['body/rb4472eda74f04518b74218e79b976d78'],''),null,outputs('Get_response_details')?['body/rb4472eda74f04518b74218e79b976d78'])

[v-bofeng-msft]

Hi @Qistina ,

Please delete the content marked in red and then try again.

Best Regards,

Bof

[Qistina]

thank you so much! it works 🙂