Skip to main content

Notifications

Power Automate - General Discussion
Unanswered

clear triggers, sharepoint list

(0) ShareShare
ReportReport
Posted on 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
    michowl on at
    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
    michowl on at
    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
    v-monli-msft on at
    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
    rormiston 4 on at
    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
    v-monli-msft on at
    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

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,580

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,909

Leaderboard