Held Needed with Flow

[almendoza26]

I have basic knowledge in creating flow. But some functions were unfamiliar to me.

I have a SharePoint list where, when an Item is created on the list. I want Flow to have a reference number which gonna use the "Created" and "ID" fields in the list. However, I only wanted to get the "year-mm" in the created field, so I try to use indexOf function. I try first indexOf(outputs('Compose'),'T') to test if I could remove the time in the field. But the result of the flow is way different from the desired output. 

Heres the screenshot of the Flow I created and the result of the flow:

Flow I createdResult of the flow

Hope that someone can help me with this.

Regards,

[dvdalen · Accepted solution]

If the date field always returns in YYYY-MM-DD then you can use an expression like this:

int(concat(substring(outputs('Compose'),0,4),substring(outputs('Compose'),5,2)))

I tested it:

and this was the result:

[almendoza26]

Thanks it works!