This video is based on a Power Automate community question. Here generate dates in sequence using start and end date, couple of expressions and HTML table generation.
Power Automate community thread:
[ Ссылка ]
Expressions I used in this video are as follows:
split(outputs('Start_Date'),'/')
formatDateTime(concat(outputs('Split_Start_Date')[2],'-',outputs('Split_Start_Date')[1],'-',outputs('Split_Start_Date')[0]),'yyyy-MM-dd')
split(outputs('End_Date'),'/')
formatDateTime(concat(outputs('Split_End_Date')[2], '-', outputs('Split_End_Date')[1], '-', outputs('Split_End_Date')[0]), 'yyyy-MM-dd')
split(replace(replace(replace(outputs('Week_Days'),'[',''),']',''),'"',''),',')
item()
ToUpper(last(split(outputs('Each_Item'),'.')))
if(and(not(equals(outputs('Day'),'SAT')),not(equals(outputs('Day'),'SUN'))),'H','')
Below is the JSON format for Format Each Results step:
{
"Date": @{formatDateTime(variables('StartDate'),'dd/MM/yyyy')},
"Day": @{outputs('Day')},
"Indicate Holiday": @{outputs('Indicate_Holiday')}
}
addDays(variables('StartDate'),1,'yyyy-MM-dd')
Ещё видео!