Answered

Error

(0) Share

Report

Posted on by ggalindo

Hello everyone, So I am using a flow template that had been working well until today. The flow is effortless to record responses from a form into a SharePoint list.

The form has five questions, which the first three are asking for a copy and past URL. The remainder is mainly asking the submitter questions about the URL links.

For about a month the flow worked great now issues, today it started to fail with the following error-

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

I have not to change anything to the flow or the SharePoint list can someone please help me understand why I am getting this error

Categories:

Building flows

I have the same question (0)

All responses (7)

Answers (1)

Jainil 25 on at

Like (0)

Report

Hi @ggalindo Can you share the flow for better reference? I am thinking one of the connections in flow is failing.

Was this reply helpful? Yes No
v-alzhan-msft on at

Like (0)

Report

Hi @ggalindo ,

Does your issue still exists now?

Could you please share the screenshot of the flow and the run history of the flow when it has run failed?

Best Regards,

Alice

Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Was this reply helpful? Yes No
ggalindo 32 on at

Like (2)

Report

Hello everyone,
Thank you for checking and helping me understand this error I was getting. I was able to resolve the problem.
Basically, the error was because two of the form fields were empty, and for some reason, the flow doesn't like to have seen empty fields when recording responses from a form on to a SharePoint list.
The fix for me was to adding and expression on the optional - if(empty(outputs('Compose')),null,outputs('Compose'))
this allows to record the responses from the two optional fields.
Thank you again, everyone

Was this reply helpful? Yes No
Verified answer

v-alzhan-msft on at

Like (0)

Report

Hi @ggalindo ,

Glad that your issue is solved.

Best Regards,

Alice

Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Was this reply helpful? Yes No
BonnieStar 39 on at

Like (2)

Report

What do you mean by, "adding and expression on the optional"..? Where did you add it? Can you include an image of that part of your flow?

Was this reply helpful? Yes No
irinaz 4 on at

Like (0)

Report

Hi,
I tried the same and added the phrase but it still fails. What am I doing wrong and how should I fix it?

if(empty(outputs('Compose')),null,outputs('Compose'))

Was this reply helpful? Yes No
Shailesh23 on at

Like (0)

Report

this wont work.. because it again passes empty value in power automate flow..

Was this reply helpful? Yes No