Create new leave type based on requirements

[syhrh]

Hi, I'm developing a Leave Application System on a SharePoint site. In it, I use Power Apps to customize the forms and use flows to update leave balance for example. One of the system's requirements is HR can create new leave types. This means that there is Annual Leave, Emergency Leave etc, then if HR decides to add a new one like Compassionate Leave, they can do that. The problem is I manually input/calculate for every leave type in the Power Automate. The expressions/formula, all I do by myself. So how to satisfy that requirement? Can anyone please enlighten me if there's a way?

Thank you.

[Hardesh15]

@syhrh  You can achieve such requirement via flow. Please explain your requirement in detail. i will guide you for this.

Please 'Thumbs Up' the posts that helped you and 'Accept as Solution' if my post answered your question.

@Hardesh /Gopenly.in

[syhrh]

@Hardesh15 the requirement is this, "A new leave type can be created if the current leave types are not enough."

I really can do that?

This is one of the examples of many flows where I manually input the leave type and calculate the column. So what to do if HR decides to add a new leave type? 

[Hardesh15]

@syhrh  Have you tried calculated column for such calculation. You can use condition in calculated column which will be based on Leave types.

Please 'Thumbs Up' the posts that helped you and 'Accept as Solution' if my post answered your question.

@Hardesh /Gopenly.in

[syhrh]

@Hardesh15 The current columns in the list are not calculated ones. Isn't the calculation in Power Automate and in the calculated column different? If I change it into calculated columns now, it will mess up my flow right now as I have some working in progress and done already.

[Hardesh15]

@syhrh  Calculated columns are easy to handle as excel formula. In case of flow you need to Share PA license with HR and they may not well verse with expression n all.

It is not just input value you are also using calculation along with it so you have to modified your flow every time new requirement come.

Also i am hoping that total leaves for each category is varying.

Please 'Thumbs Up' the posts that helped you and 'Accept as Solution' if my post answered your question.

@Hardesh /Gopenly.in

[syhrh]

@Hardesh15 "It is not just input value you are also using calculation along with it so you have to modified your flow every time new requirement come". Is this the solution?

what do you mean by, "total leaves for each category is varying"?