I want to share my observations I had while doing Poc on leveraging AI Builder to automate invoice processing system in dataverse connector in power automate . If any suggestions on my observation , it would be most welcome to improve my performance and design .
1) We had to use parson json action almost 1 yr back . Now The AI builder pre does the parsing of our data and provides the parsed output.
2) In my POC, Date values are not getting updated by adding dynamic values of Date Value of Predict output. i need to create a variable to store the date value , then add compose action to extract date , month and time and last create expression to formatdate using the output from the last compose action. then date gets enter in the Sharepoint . If I am not doing these steps before then it gives me below error message "The 'inputs.parameters' of workflow operation 'Update_file_properties' of type 'OpenApiConnection' is not valid. Error details: Input parameter 'item/Invoice_x0020_Date' is required to be of type 'String/date'. The runtime value '"30/05/2021"' to be converted doesn't have the expected format 'String/date'." If I try to create expression to format date based on the predictoutput , it gives me message below " 'In function 'formatDateTime', the value provided for date time string '30/05/2021' was not valid. The datetime string must match ISO 8601 format.'."The flow consider it to be month date format . This thing i tested by hardcoding sample value of date .
3) For every date field , I have to create that no of variables in parallel and perform the steps as mentioned in 2 point. Is there a way in we can define all date fields in one place and then use it anywhere in our flow .
4) I created balance column as number type in my sp and trained my model by including currency symbol in the model field . when i run the flow it gives me error stating below :- "The 'inputs.parameters' of workflow operation 'Update_file_properties' of type 'OpenApiConnection' is not valid. Error details: Input parameter 'item/Balance_x0020_Due' is required to be of type 'Number/double'. The runtime value '"₹ 6,000.00"' to be converted doesn't have the expected format 'Number/double'." i edited my model and removed the currency symbol from it and then tried again. then it works fine .
@yashag2255 @RezaDorrani
