Add multiple rows from one input row (date based)

[C2]

Hi

I have a table with the following columns:
ID, Contract, Start day, End day, from time, to time, days of the week (enunmlist: mon, tue, wed), Day.
I set this table with form because I want to insert as variables:
Start day, End day, from time, to time, days of the week.
Adding a row via form: from 11/1 to 11/20 from 09:00 to 11:00, I select mon, tue.
the app adds many rows with the days that correspond to Monday and Tuesday from 11/1 to 11/20.
the day column will be the variable that will change every row.

To do this I also created another table with two columns: Day and day of the week, and a virtual column (DateSelected) in the first table that selects all the dates corresponding to the condition:
SELECT(
Calendar[Day],
AND(
([Day] >= [_THISROW].[Start day]),
([Day] <= [_THISROW].[End day]),
IN([Weekday], [_THISROW].[Days of the week])
)
)

now I should understand how a bot can break down the list of days and create as many rows as there are dates in the list of the virtual column (DateSelected) that only modifies the [Day] column and pastes all the other info again.

I tried to create an action to add a row and associated it to a bot that however only performs the action once when a row is added.
How do I create a sequence of rows based on how many values ​​the virtual column list has?
thanks

[Suvrutt_Gurjar]

Please search the "Tips and Tricks" section with key words such as "add rows" or "add multiple records" etc.

There are several tips those could give you the idea to configure your add rows functionality.

Search - Google Cloud Community

[C2]

Thanks for the suggestion.
I found how to add a series of successive dates between a period.
https://www.googlecloudcommunity.com/gc/Tips-Tricks/FAQ-Add-rows-for-a-date-range/m-p/321864

My question is how can I get these dates from a list  (not just +1 day es: Add Date: IF(ISBLANK([Add Date]), [Start Date], ([Add Date] + 1))

 In my case the virtual column that contains a selection of dates in the period

[Suvrutt_Gurjar · Accepted solution]

---

@C2 wrote:

My question is how can I get these dates from a list 

---

Then maybe the following tip is relevant to you.

FAQ: add row per value in EnumList - Google Cloud Community