I made a flow about creating and updating Excel data to sharepoint list.
I used 「control 」action, and used「title」column as the key.
If the title have already been copied to the sharepoint list, the corresponding data would be updated by excel data.
If the title doesn't exist in the sharepoint list, the data would be copied from excel to sharepoint list.
All things went successfully, except that I found there are some single quotation mark in the title column, which made the filter query in the condition action failed.
The query is title eq 'dynamic contents'
Ex. apple'company
which make the query become title eq 'apple'company 1Q' and failed.
∟ 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
variable : name→count type→integer value→0
do until: loop stop condition → variable('count') is equal to triggerBody()?['number']
list rows present in a table（get the data from excel）: 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
