How to add Incremental Case ID when a new submission from MS Forms

[ABCDEFG1234]

Hi all,

I want to build a flow that can add case ID in an excel table when a new submission from MS Forms.

Here is my flow:

Compose

formatDateTime(outputs('Get_response_details')?['body/submitDate'],'yyyyMMMdd')

concat(outputs('Get_response_details')?['body/rd25c02c1f80f4a6db71f80dabadff5f9'], '_', outputs('Compose'))

length(outputs('List_rows_present_in_a_table')?['body/value'])

There is a pattern for the CaseID, such as: HumanResource_2021MAY23_001, but the last three digit will be reset if the Date is change.

The case ID can be

HumanResource_2021MAY23_001

Transportation_2021MAY23_002

HumanResource_2021MAY24_001

The flow can be ran successfully, but there is no update on the table.

[PrasadAthalye]

Can you check variable value of Approval ID within Flow run? Is it correctly generated?

Can you check data type of the column in excel ? Is it Number?

Finally, can you please hardcode a value and see if that goes through?

[ABCDEFG1234 · Accepted solution]

Thank you for your comment, I find another away to achieve the purpose.

Here is my flow:

formatDateTime(body('Convert_time_zone'),'yyyyMMMdd')

concat(outputs('Get_response_details')?['body/rd25c02c1f80f4a6db71f80dabadff5f9'], outputs('Compose'))

length(body('Filter_array'))

Finally, we can add a row into a table.