I am trying to build a flow where When the contents of an excel sheet changes a flow is triggered and the contents of the excel file are either updated or created in the sql server..
I am using azure "when a file is modified as a trigger".
my question is how can iterate through the ids and identify which ones to update and which ones to add.
Please help
Example:
excel file
id desc
1 a
2 b
7 c
6 d (needs to be updated)
5 e (need to be added)
sql server
id desc
1 a
6 l
8 x
7 c
2 b
after the flow triggers i would like the sql server to be as such
1 a
6 d
8 x
7 c
2 b
5 e
