Answered

Recurrence function and get the newest data.

(0) Share

Report

Posted on by HaiNguyen202

I have a project requiring add a row into a table after getting information via Telegram Bot. Basically, when I send messages "A", "B", "C" to Telegram Bot, the Bot will receive the data and create rows including:

- "Update ID" column ( which means the series of the text, for example "A" indicated as 1 because this is the first message I sent, "B" is 2 because this is the second, "C" is 3 because this is the third ) ,

- "Text" column (which means "A", "B", and "C" I have just sent as the messages in the previous step).

The situation is when I send another message "D", I need to trigger the flow manually again to add the row with "D" information. If not the row would not be updated. So I create the recurrence function which means in every 60s the flow would be triggered automatically. However, it will create the rows with "A", "B", and "C" again besides creating "D" with UpdateID "4". And I just need they add "D" ONLY with the UpdateID is "4" not "A", "B", and "C" again.

Please find the picture attached!

I am working on Condition function but I still cannot sort it out. Please help!

Categories:

Business Process Flows

All responses (9)

Answers (1)

Verified answer

v-bofeng-msft on at

Like (0)

Report
Re: Recurrence function and get the newest data.

Hi @HaiNguyen202 :

There is no column named "UpdateID" in your excel table.

Please try:

ID eq xxx

Best Regards,

Bof
HaiNguyen202 43 on at

Like (0)

Report

Re: Recurrence function and get the newest data.
v-bofeng-msft on at

Like (0)

Report

Re: Recurrence function and get the newest data.

Hi @HaiNguyen202 :

Could you please show me the filter query of 'Check ID with log file'.

Best Regards,

Bof
v-bofeng-msft on at

Like (0)

Report

Re: Recurrence function and get the newest data.

Hi @HaiNguyen202 :

Could you please show me the filter query of 'Check ID with log file'.

Best Regards,

Bof
HaiNguyen202 43 on at

Like (0)

Report

Re: Recurrence function and get the newest data.

Hi,
Thanks for your support. Actually I have solved the problem but now I have another query. I would like let the BOT only reply for the dedicated person. Each account has a fixed ID, so now I would like to let the BOT answers to the ID that I set for.
HaiNguyen202 43 on at

Like (0)

Report

Re: Recurrence function and get the newest data.

length(outputs('Check_ID_with_Log_file')?['body/value'])
v-bofeng-msft on at

Like (0)

Report

Re: Recurrence function and get the newest data.

Hi @HaiNguyen202 :

I guess the logic of your flow is to first determine whether the record exists, and if it does not exist, add a new line.Could you please provide detailed settings for these three Actions(Inside the red box)?

In addition, you can add a 5s delay after Add a row into a table and try again.

Best Regards,

Bof
HaiNguyen202 43 on at

Like (0)

Report

Re: Recurrence function and get the newest data.
v-bofeng-msft on at

Like (0)

Report

Re: Recurrence function and get the newest data.

Hi @HaiNguyen202 :

Could you please show me your flow?

Best Regards,
Bof