@chandra1
After I tested , there are two ways working for me
Method 1
Create one more column like "Mark"
Make this flow auto run every 10 mins
List rows present in a Table filter query with Mark ne 'sent'
Use apply to each
It will run by every line of the list one by one
Send a mail and update rows Mark to "sent"
Method 2
Create new table like below
Rows = how many lines you already sent to mail
Mark = 1 just for easy get this rows
Make this flow auto run every 10 mins
Initialize variable type int with value 1
Get rows with new table column mark = 1
Initialize variable type int with value rows
Spoiler (Highlight to read)
int(outputs('获取行')?['body/rows'])
int(outputs('获取行')?['body/rows'])
List rows present in a Table from your original table
Use filter arrays by value from list rows
The name Not equal to empty
Use condition
Left side
Spoiler (Highlight to read)
int(outputs('获取行')?['body/rows'])
int(outputs('获取行')?['body/rows'])
Right side
'获取行'= get rows
'筛选数组'= filter arrays
You can change the name by your own
If true then do nothing, if false then do like below:
When the index > rows then send mail
And then make the index = index + 1
After this loop, update the rows like
And then show you the full map like below:
I use Chinese version , but I mark the point to English, I guess you can recognize that.
If you can't recognize some of that, please let me know it.
I hope it helps.
Best regards
Ler
