Hello,
I'm trying to curate a flow. The goal of this flow is to create an item on a "Master List", deriving its values from 4 different SharePoint lists. Once all values are imported, I want to put the Master List Item values into an HTML table that is then converted into a PDF file that gets put into a SharePoint document library.
This flow is triggered when an item is created or modified on a specific SharePoint List called "Compliance". When the Compliance item is created, we use the "Get Items" action for that item. Then, we initialize a variable called "Master List ID" to be used later.
After that, we check the values of 4 checkboxes in the Compliance Item. When those values are true, we create an item on the Master List. Set the "Master List ID" variable equal to the List Item ID for the Master List item. Then, we use the "Get Items" action to get the values for the Initial form, setting Order By to "Created desc" and Top Count to "1" (so that we only get the most recently created item from that list). To import the values, I use the "Update Item" action, setting each value to the dynamic content of the "Get Items" action. I repeat this process for each list (BackOffice, PortOps, and Compliance).
Here is where I run into the issue.
When trying to import the values from the 4th and final list (Compliance), I get the following error:
OpenApiOperationParameterTypeConversionFailed. The 'inputs.parameters' of workflow operation 'Update_item' of type 'OpenApiConnection' is not valid. Error details: Input parameter 'item/Directed_x0020_Execution' is required to be of type 'Boolean'. The runtime value '"Yes"' to be converted doesn't have the expected format 'Boolean'.
I understand that the error is saying that there is an issue with the "Directed Execution" value on the item. What I won't understand is why the value "Yes" is not being accepted in this instance, but is accepted in other portions of the flow.
Any guidance would be appreciated.
Screenshots of my flow:
