Unanswered

SPL Create/Delete Item

(0) Share

Report

Posted on by EG-31080115-0

118

I have (2) SPL's that are identical. One is for active use with PowerApps and the second I am using as an archive. The Flow I am trying to create would, on recurrence basis, look for a date in SPL#1 associated with the record. If a date exists the Flow would create that item in SPL#2 then delete it from SPL#1. My Flow works up to the point of deleting the record from SPL#1. Any advice?

Categories:

Building flows

I have the same question (0)

All responses (7)

Answers (0)

MarconettiMarco 3,812 Super User 2024 Season 1 on at

Like (0)

Report

Hello @Microbes ,

which kind of error are you getting? can you show it in details?

BR,

Marco

Was this reply helpful? Yes No
EG-31080115-0 118 on at

Like (0)

Report

@MarconettiMarco ,
There is no error. The Flow executes, the item is created in SPL#2 ("archive") but is not deleted from SPL#1 ("active"). So, SPL#2 quickly becomes saturated with redundant items because they are not being deleted from SPL#1.

Was this reply helpful? Yes No
MarconettiMarco 3,812 Super User 2024 Season 1 on at

Like (0)

Report

Hello @Microbes ,

I've replicated the scenario and all is working fine from my side:

I've noticed in your screenshots that you have 2 Apply to each controls. You should have only one Apply to each loop that refers to the "value" grabbed from the "Get items" action.

Please let me know if the issue is fixed.

I may not have all the answers, but I'm curious and passionate enough to keep looking for answers and to keep sharing them.

If I have answered your question, please mark my post as Solved.
If you like my response, please give it a Thumbs Up.

My blog site about Power Automate: https://powerautomatejoy.com/

BR,

Marco

Was this reply helpful? Yes No
EG-31080115-0 118 on at

Like (0)

Report

@MarconettiMarco ,
Thanks for the response. I have (2) Apply_to_Each because I want the Flow to evaluate the date on condition of Now-7days. If true, then Create Item (in SPL#2) then Delete Item (from SPL#1). I guess I could have two separate Flows, one for Creating and one for Deleting, with the Delete Flow set to run recurrent an hour after the Create Flow, but was hoping to do both actions in one Flow.

Was this reply helpful? Yes No
MarconettiMarco 3,812 Super User 2024 Season 1 on at

Like (0)

Report

Hello @Microbes ,

if you're referring to the same "Get items" array, you don't need 2 Apply to each loops.

BR,

Marco

Was this reply helpful? Yes No
EG-31080115-0 118 on at

Like (0)

Report

@MarconettiMarco ,
Good to know, thanks. So, in your opinion, if I remove the second Apply_to_each after the Condition and have the Create and Delete actions in series as they are now, it should work?

Was this reply helpful? Yes No
MarconettiMarco 3,812 Super User 2024 Season 1 on at

Like (0)

Report

Hello @Microbes ,

I think so, from my side it's working.

Please let me know if the issue is fixed.

I may not have all the answers, but I'm curious and passionate enough to keep looking for answers and to keep sharing them.

If I have answered your question, please mark my post as Solved.
If you like my response, please give it a Thumbs Up.

My blog site about Power Automate: https://powerautomatejoy.com/

BR,

Marco

Was this reply helpful? Yes No