Hey
I am trying to create a power automate flow but It keeps failing. I was originally having issues with the content it was passing through to the form but I think I have resolved those issues and they seemed to be where input type were mis matching eg date and string fields.
Since then though I am getting messages about users not being found. I have attached a screenshot below. Any help would be helpful
Any chance you can be more specific on how you solved this? I have been going back and forth between the same 2 errors and really need to fix my flow. How do I know if my SharePoint column is a contact field or string? If I just want a persons name, which should it be?
Hey,
I think you are Correct. The original error was caused by me setting one of my Sharepoint columns to a contact field and not a string. I worked through all the fields one at a time until I found the bugged entry.
This is a completely different error. Now you are trying to set a date type (the field age) with 2 double quotes. This is not a valid date.
I Think I have tracked it down to a few fields where I give the user a choice in the microsoft form. In the Sharepoint list I had the field set to choice but the options were just yes/no which didn't match the form. I've change the Sharepoint list choice to match the Form in which case I get this error
The 'inputs.parameters' of workflow operation 'Create_item' of type 'OpenApiConnection' is not valid. Error details: Input parameter 'item/Age' is required to be of type 'String/date'. The runtime value '""' to be converted doesn't have the expected format 'String/date'.
or if I change the Sharepoint list field to be a string I get this error
Object must implement IConvertible.
clientRequestId: 224a4315-dd37-4396-acce-b4344f2add3a
serviceRequestId: 224a4315-dd37-4396-acce-b4344f2add3a
What fields (user fields) are you trying to set using create item and how are you trying it? Have you checked the values you are trying to set using a compose action. Have you checked to manually set the user and use “peek code” to see how the format has to be to set the user?
WarrenBelz
146,524
Most Valuable Professional
RandyHayes
76,287
Super User 2024 Season 1
Pstork1
65,906
Most Valuable Professional