Recurrence Flow Excel to Planner Error

[Barnes94110]

Hi All,

I'm new to flow, so I appreciate all of your help.  I had previously made a flow that took an excel document & created/updated tasks in Planner. It was built off a manual trigger & starts with "for the selected row" . I was able to build out this flow & it works with no issues. I am posting a screen shot of it below.

I want to take the same flow, but instead of a manual trigger I would like it to run once a day. 

I started a new flow with Recurrence once a day. I tried to copy the same flow as before, except it now starts with "Recurrence" followed by "List rows present in table" instead of "For the Selected row" I was getting an error with the dates. In the original flow it allows be to select the column "start (Formatted)"  This "Formatted" version is not available in this flow.  I dug around on these forums and found I need to convert the date format from excel. Now when creating the task, I used to below expression in the "Start Date Time" 

addDays('1899-12-30',int(items('Apply_to_each')?['START']),'yyyy-MM-dd')

However I am now getting this error:

"Unable to process template language expressions in action 'Create_a_task' inputs at line '0' and column '0': 'The template language function 'int' was invoked with a parameter that is not valid. The value cannot be converted to the target type.'." 

Does anyone have an idea what the issue is? Or another way to go about setting this flow to run once a day?

Thanks, 

[v-xiaochen-msft]

Hi @Barnes94110 ,

The error shows that the value in 'items('Apply_to_each')?['START'] 'cannot be converted in int function. 

What's the output of 'items('Apply_to_each')?['START'] ' ? Could you share it?

Best Regards,

Wearsky

[Barnes94110]

this is a very stripped down version of the flow I was trying to create but this is how it looks currently 

This is the way the error looks when I run the flow

[v-xiaochen-msft]

Hi @Barnes94110 ,

I still don't find the output of items('Apply_to_each')?['START']  in the reply...

Best Regards,

Wearsky

[Barnes94110]

I'm not sure how to show you what the output is?  Its trying to create a task in planner . This is the code

"inputs": {

        "host": {

            "connectionName": "shared_planner",

            "operationId": "CreateTask_V3",

            "apiId": "/providers/Microsoft.PowerApps/apis/shared_planner"

        },

        "parameters": {

            "body/groupId": "df31afe6-4703-4fc2-8f51-32ef7dc01155",

            "body/planId": "TBKBzHM3cESsUUR0yymN-WQAC-sR",

            "body/title": "@items('Apply_to_each')?['WORKSTREAM']",

            "body/dueDateTime": "@addDays('1899-12-30',int(items('Apply_to_each')?['START']),'yyyy-MM-dd')"

        },

        "authentication": "@parameters('$authentication')"

    },

    "metadata": {

        "operationMetadataId": "f35d8a0f-7957-472b-abbd-7e78550a7c99"

    }

}