updating an action via power automate

Jenny Mulcock

Hello brains,

Would anyone be able to help me out with my PA flow? I am trying to build a very simple flow that finds actions based on an NXT list and updates them to completed. The flow runs successfully but nothing happens to the actions in RE. There are definitely results in the list.

Any help welcomed! I can always go back to running a global change in DB view but was hoping not to have to do that!

Many thanks

Alex Wong

@Jenny Mulcock
you said your flow runs, so first thing to check is go into the flow that completed, and check the actions to see if the output is your desired output. The first one to check is the “find action in my nxt list” and see if the output has an array of constituent action. If the output is just [], that means your “apply to each” is not going to have anything to work with

if you do have output from the list, then go into your Apply to each and check the update a constituent action and see what output is there.

1 issue that is possible, which would be pretty bad, is you use the wrong “ID” field for “Action ID” to locate which action to update, can you “mouseover" the ID dynamic field and see what it is (youc an highlight the ID field and copy it and paste here.

Ben Lambert

@Jenny Mulcock another thing to check is how the concept of action “completed” is configured in your instance of Raiser's Edge. The system supports two models: one is a simple boolean (Yes/No) field typically represented as a checkbox in the UI, and the other is a more complex representation using the action status code tables (where you indicate which action status table entries semantically mean “Completed”). Here is a link to the documentation in case it helps.

Alex Wong

@Ben Lambert
from the look of the action screenshot, I think the “Yes” and “Completed” is a drop down selection that was selected, rather than typed in. So that should be ok.

Jenny Mulcock

@Alex Wong thank you for this, I'll check it and see what I can find.

Jenny Mulcock

Hi @Alex Wong, I've done what you suggested and it turns out there are no actions found in the ‘Find actions from my list’ step of the flow. The thing is, there are definitely actions in that list, so I'm confused as to why they wouldn't be coming through in the flow. I haven't added any additional criteria so it's a bit baffling!

Do you have any suggestions at this point? It's such a simple flow I really don't know what I could be doing wrong!

Alex Wong

@Jenny Mulcock
you are saying there are definitely actions in the list, and from the screenshot, it seems like you saved a constituent action list in RE NXT that you are pulling up. what is the filter used on that list in NXT?

Can you provide additional screenshots on the flow run info? also screenshot on the filter used on the list in NXT webview and the expected # of results

Jenny Mulcock

@Alex Wong the list in NXT. I've deliberatley set it up this way to test it. Two records expected:

Jenny Mulcock

@Alex Wong results in the flow:

Jenny Mulcock

Hey @Alex Wong, thank you so much for your help, I've actually been able to get it working, it just turned out my list was corrupt! The flow is now working perfectly!