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