Unanswered

Power Automate cannot write an empty uri into a SharePoint list

(0) Share

Report

Posted on by clairejk

I have a Form, which has an optional URL field, to be passed into a SharePoint List hyperlink field, which is also optional.

The Flow I have was working whether there was a link in the Form or not, but has now stopped working, with the error:

Action 'Create_item' failed: The 'inputs.parameters' of workflow operation 'Create_item' of type 'OpenApiConnection' is not valid. Error details: Input parameter 'item/BookingLink' is required to be of type 'String/uri'. The runtime value '""' to be converted doesn't have the expected format 'String/uri'.

I have tried converting to null if the Form is empty, but this does not work either.

Categories:

General topics

All responses (3)

Answers (0)

Sort by

clairejk 15 on at

Like
a
(0)

Report
Copy link

Link copied!

And now I'm having the same problem with date fields and image fields. I was trying to do it with Conditions, but I've got 4 already, and there are a lot of optional fields in my form!
Any help would be much appreciated.
v-yetonggu-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @clairejk ,

Please check this test:

Run History:

When link field and Date field all blank.

Flow Configuration:

Please try this expression:

if(empty(DateDynamicContent),null,formatDateTime(DateDynamicContent,'yyy-MM-dd')) if(empty(LinkDynamicContent),null,LinkDynamicContent)

Best Regards,

Sunshine Gu
clairejk 15 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you, I have tried these, but it still gives the errors:
The runtime value '""' to be converted doesn't have the expected format 'String/uri'.
The runtime value '""' to be converted doesn't have the expected format 'String/date'.