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 created
Result of the flow
Hope that someone can help me with this.
Regards,
Solved! Go to 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:
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:
Thanks it works!
User | Count |
---|---|
78 | |
56 | |
53 | |
43 | |
39 |
User | Count |
---|---|
80 | |
80 | |
75 | |
67 | |
43 |