Insert New column if value is missing

[Veni_Padam]

Hi All,

Ques:
If Month column does not have "April or May" then a new row with April/May should be added with null values for Value & path column.

Could someone help ?
Thanks inadvance!

[atcodedog05]

Hi @Veni_Padam 

Here is how you can do it.

Workflow:

Hope this helps : )

[Veni_Padam]

Hello @atcodedog05 
Apr or May - it should be in different rows but not as a single value "Apr/May"
I just gave the data for reference, but in real case it should check all the months and should populate a new row for each missing month.

And instead of using a separate flow for each month checking, can that be done with a single logic?

[binuacs]

@Veni_Padam 

[atcodedog05]

Hi @Veni_Padam 

Sorry for the delayed response. You can use the join tool and union to have all the months included.

Workflow:

Hope this helps : )