web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Recurrence function an...
Power Automate
Unanswered

Recurrence function and get the newest data.

(0) ShareShare
ReportReport
Posted on by 43

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!

 

HaiNguyen202_0-1634649339738.png

 

 

 

Categories:
I have the same question (0)
  • v-bofeng-msft Profile Picture
    on at

    Hi @HaiNguyen202 :

    Could you please show me your flow?

    Best Regards,
    Bof

  • HaiNguyen202 Profile Picture
    43 on at

    HaiNguyen202_0-1634881883804.png

     

  • v-bofeng-msft Profile Picture
    on at

    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)?

    vbofengmsft_2-1634883545015.png

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

    Best Regards,

    Bof

     

     

     

  • HaiNguyen202 Profile Picture
    43 on at
    length(outputs('Check_ID_with_Log_file')?['body/value'])
    HaiNguyen202_0-1635217168898.png

     

  • HaiNguyen202 Profile Picture
    43 on at

    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.  

  • v-bofeng-msft Profile Picture
    on at

    Hi @HaiNguyen202 :

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

    vbofengmsft_0-1635217703227.png

    Best Regards,

    Bof

     

  • v-bofeng-msft Profile Picture
    on at

    Hi @HaiNguyen202 :

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

    vbofengmsft_0-1635217703227.png

    Best Regards,

    Bof

     

  • HaiNguyen202 Profile Picture
    43 on at

    HaiNguyen202_0-1635217835088.png

     

  • Verified answer
    v-bofeng-msft Profile Picture
    on at

    Hi @HaiNguyen202 :

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

    vbofengmsft_0-1635225314559.png

    vbofengmsft_1-1635225371333.png

    Please try:

    ID eq xxx

    Best Regards,

    Bof

     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 522 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 364 Moderator

#3
abm abm Profile Picture

abm abm 243 Most Valuable Professional

Last 30 days Overall leaderboard