Skip to main content
Community site session details

Community site session details

Session Id : KJ9ymwqg9fOCZ8D/R95jzn
Power Automate - General Discussion
Unanswered

clear triggers, sharepoint list

Like (0) ShareShare
ReportReport
Posted on 13 Feb 2017 21:52:33 by 4

I have a sharepoint list that triggers on new item creation, which creates a new row in a sql table, and then sends back the id.....

There are some items that i want to add to the sp list that are already in the sql table, which i obviously dont' want created again in the sql table.  how long do i have to wait to turn the flow back on....and will the trigger be "dead"?

Categories:
  • michowl Profile Picture
    Microsoft Employee on 14 Feb 2017 at 18:34:38
    Re: clear triggers, sharepoint list

    Or if you know a row is in SQL already, you can add a column to SP list like "InSQL" and manually check it off if you know it's in SQL, and update it from Flow when you get the SQL Row ID back. Then check if the column is checked in Flow before adding to SQL.

  • michowl Profile Picture
    Microsoft Employee on 14 Feb 2017 at 18:31:42
    Re: clear triggers, sharepoint list

    I think a longer term solution would be to check if the SP item exists in the SQL table before adding. And If the SP item has a SQL row id, then it shouldn't be added

     

    Something along the lines of:

     

    New SP Item trigger

     

    Condition: SPItemSQLID = '

     

    IF YES (SPItemSQLID='')

     

    Get Rows from SQL

    ODATA Filter: SQLColumnName eq SomeValueFromTrigger

     

    Condition: empty(body('Get_rows')?['value'])

    IF YES (empty rows)

     

    Add SQL Row

     

    IF NO (empty rows)

     

    Do Nothing

     

    IF NO (SPItemSQLID='')

     

    Do Nothing

  • v-monli-msft Profile Picture
    on 14 Feb 2017 at 08:53:11
    Re: clear triggers, sharepoint list

    Hi rormiston,

     

    I think you need to delete the old flow and create a new one to avoid this issue.

     

    Regards,

    Mona

  • rormiston Profile Picture
    4 on 14 Feb 2017 at 04:17:17
    Re: clear triggers, sharepoint list
    I added several rows to my SP list, and then turned flow back on about 10 min after. I'm on the highest tier account type, so I assume that I'm on 5 min cycles. When I turned flow back on, it added the rows to the SQL table and sent the ID's to the new rows replacing the SQL ID# I had already put in the SP table manually, so I had to manually change them back so the update flow would work when needed.

    It made me wonder if I didn't wait long enough, or if a new row trigger holds?
  • v-monli-msft Profile Picture
    on 14 Feb 2017 at 04:02:37
    Re: clear triggers, sharepoint list

    Hi rormiston,

     

    I'm not sure if I understand your question clearly. I think as soon as you have added all these items to sp list that has already exist in sql, then you can turn the flow back on... Not sure what you mean by "how long", please help to explain more. 

     

    Regards,

    Mona

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

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 497 Super User 2025 Season 1

#2
David_MA Profile Picture

David_MA 436 Super User 2025 Season 1

#3
Riyaz_riz11 Profile Picture

Riyaz_riz11 244 Super User 2025 Season 1

Loading started
Loading complete