Tuesday, 11 June 2024

Errors in powers automate : The 'inputs.parameters' of workflow operation 'Add_a_new_row' of type 'OpenApiConnection' is not valid. Error details: input parameter

 


Here the input formula or the filed value is not in the expected format. 

Here the Flow is expecting either a String value or Date-time value. 

You can declare a string at beginning of flow and use append to string to store and pass the value. 

or use formula to convert it into specific date format by using the below formula : 

addDays('01/01/1900',sub(int(items('Apply_to_each_2')?['Date field name']),2),'dd/MM/yyyy')




Another Error : 


The input body for trigger 'manual' of type 'Request' did not match its schema definition. Error details: 'Invalid type. Expected Integer but got String.'.


Sometime the flow may give this error after a long time or when it is run by other user: 
Just duplicate the flow and make it as main flow fixed this issue. 


No comments:

Post a Comment

Identify all the cloudflows on a particular entity along with its messages

  The easiest way to identify the flows that trigger on a particular entity with its messages is to run a SQL query using the sql4cds tool i...