Share
Report
6Hi,
I have a flow where I would like to remove items in a SharePoint list and also in an SQL server. I'm hitting issues there.
See below the details:
This is the SharePoint list: one column is called "ParseurItemID" which has unique values.
I also have an SQL table where the ParseurItemID is recorded (might have duplicate, I can make sure there is no duplicate for the column ParseurItemID, but for the time being I would like to accommodate the ParseurItemID to have some duplication if possible)
On a click of a "Button" below I would like to remove from the "ParseurItemID" in pink / purple below (it is in an editform, field called PaseurItemID_datacard1, and it's the datacardvalue10) in:
- The sharepoint list "Purchase Invoices" (in yellow below)
- The SQL table "Power_Automate_CSI_Purchase_Invoice_Auto_Processing" (in yellow below)
To remove it from the SharePoint List I tried:
- Remove('Purchase Invoices',LookUp('Purchase Invoices',ParseurItemID=DataCardValue10))
- Remove('Purchase Invoices',LookUp('Purchase Invoices',ParseurItemID=DataCardValue10.Value))
- Remove if as well.
- and multiple other patch / remove from what I could find.
So far all my test failed ! If one of you has an advice on this it would be great.
Last but not least, if I want to alter the record and not delete it there is the patch function that I tried as well, without success neither. If you have a tip on the patch it would be great as well.
Thanks a lot to the community, as always !
NickyD.
All responses (
Answers (
