Power Platform Community Forum Thread Details

Hi, I would like to insert input from Ms Form to Sharepoint List.

One of the question is in Text form (choice question), asking about Quarter (Quarter 1, Quarter 2, Quarter 3, Quarter 4). Another question is asking about duration (in quarter as well). I need to calculate the end of quarter based on these two information. Eg, if Quarter=Quarter 1, and duration is 2 quarters, then end of quarter = Quarter 2.

My thought is by convert the start of quarter into integer first. Then use expression 'Add' and 'Mod' to calculate the end quarter. Yet I get 0 as input at the Compose action.

My expression in compose:

if(equals(outputs('Get_response_details')?['body/ab1'], 'Quarter 1'), 1, if(equals(outputs('Get_response_details')?['body/ab2'], 'Quarter 2'), 2, if(equals(outputs('Get_response_details')?['body/ab3'], 'Quarter 3'), 3, if(equals(outputs('Get_response_details')?['body/ab4'], 'Quarter 4'), 4, 0))))

Anyone have any ideas on converting this to integer? Or maybe ways to get end of quarter?

Thank you in advance.