Delete Sharepoint Row based on SQL ID

(0) Share

Report

Posted on by craig_01

153

Hi There,

I currently have x1 flow that takes sales order data from a SQL Table and populates a sharepoint list for other team members to interface with.

However i want to create another flow that keeps the sharepoint list tidy, by removing the row if the sales order data from SQL is marked as despatched (desaptch column).

Any tips on best approach to do this?

Thansks

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (0)

abm abm 32,865 Most Valuable Professional on at

Like (0)

Report

Hi @craig_01

You need to retrieve the records SQL based on a filter where marked as dispatched. Once you got the records then you need an identifier to match something like Order number or something in SharePoint. Believe this is already populated by your existing flow. Using that common identifier Filter the SharePoint records and delete it.

1. SQL to retrieve the dispatched records

2. Iterate in a loop all the records

3. Use the Order Number (From SQL) to filter against SharePoint Get Items

4. Next Delete Item using the SharePoint Id

Thanks

Was this reply helpful? Yes No
craig_01 153 on at

Like (0)

Report

@abm Thanks for reply.. But i need a bit more guidance.

My current flow is working which populates a Sharepoint List, and part of the flow is that it inserts a SQLID into a column.

The new flow that i want to create, reads data from a different table, that has a column status which states "OUT", this table also will contain the same SQLID reference.

So under a re-occuring flow, want to get data from the new table, and if the status is "OUT" against the respective SQLIDs, i want to delete the row from the Sharepoint List.

Thx

Was this reply helpful? Yes No
craig_01 153 on at

Like (0)

Report

Hi @abm,

Can you show me a sample flow please, im not sure about this.

Thanks

Was this reply helpful? Yes No