∟ false →for each → [update item](項目の更新)
→increment variable(変数の値を増やす)
「list rows present in a table」can not get data from excel more than 256 rows, so I'm using [do until] to get data more than 256 rows.
The parameter in actions↓
manually trigger : the type of user input →number
current time: no expression in it.
conver a time zone: basetime→body('current_time') source time zone→ (UTC)Coordinated Universal Time Destination time zone→ (UTC+09:00)Osaka,Sapporo,Tokyo Time unit→
formatDateTime(body('Current_time'), 'yyyyMMdd-HHmmss')
compose: inputs → workfile body('conver a time zone').xlsx
variable : name→count type→integer value→0
get file content using ID(box): File ID→ I choosed from the open folder button. infer content type →Yes
create file(onedrive):file name→output('compose') file content→body(’get file content using ID’) Folder Path→ I choosed from the open folder button.
do until: loop stop condition → variable('count') is equal to triggerBody()?['number']
get tables: Location→ OneDrive for business Document Library→ document File→outputs('create file')?['body/path'] outputs('create file')?['body/name']
list rows present in a table(get the data from excel):
File →outputs('create file')?['body/path'] outputs('create file')?['body/name']
table→
outputs('Get_tables')?['body/value'][0]['name']
skip count → variable('count') datetime format→ ISO 8601
apply to each : outputs('list rows present in a table')?['body/value']
get items(get the data from sharepoint): filter query→title eq 'title' top count→1
control : condition expression →empty(outputs('get items')?[''body/value']) is equal to true
∟ true → [create item]
∟ false →[update item]
increment variable: name→count value→1