Prospect Status for Constituent of Action Record

Reuben Schmitz

@Alex Wong
Or do you need to reference the message itself: {"statusCode":404,"headers":{"Cache-Control":"no-cache","Pragma":"no-cache","Strict-Transport-Security":"max-age=31536000;includeSubDomains","Content-Security-Policy":"frame-ancestors 'self' https://host.nxt.blackbaud.com","section-io-id":"2c98c4c088c878bc83d92ed437e56523","Timing-Allow-Origin":"*","x-ms-apihub-cached-response":"true","x-ms-apihub-obo":"false","Date":"Wed, 29 Nov 2023 14:51:30 GMT","Content-Length":"238","Content-Type":"application/json","Expires":"-1"},"body":[{"message":"The requested operation could not be fulfilled","error_name":"RequestNotFulfilled","error_code":404,"raw_message":"The requested operation could not be fulfilled","error_args":[]}]}

Carol Grant

@Reuben Schmitz- Hi Reuben, we have all run into this at some point. I did post this issue and Glen helped me out. Here is the link to that post.

I hope that helps.

Glen Hutson

@Reuben Schmitz

Instead if using if & empty, try using coalesce. This got me through in testing the scenario. Null and empty are different things. Coalesce helps with “null” as in “nothing exists”. This checks for the constituent prospect status and if there's not one at all, will then print ‘No Status Found’

coalesce(outputs('Get_constituent_prospect_status')?['body/status'],'No Status Found')

Reuben Schmitz

@Glen Hutson unfortunately, the flow isn't getting to the conditional - it hangs up in the “Get Constituent Prospect Status” part.

Glen Hutson

@Reuben Schmitz:

@Glen Hutson unfortunately, the flow isn't getting to the conditional - it hangs up in the “Get Constituent Prospect Status” part.

The step after the “Get Constituent Prospect Status” will need to have the “run after” configured for both “Is successful” and “has failed”

That way, you get beyond that step and then use coalesce to check the results of that step without erroring out.

Reuben Schmitz

@Carol Grant thanks for responding. I had seen the post, but the solution didn't seem to fit what I am trying to do. However, would you be albe to send me a screenshot of your final solution? As noted, the problem I have is that the flow is getting hung up on the "Get Constituent Prospect Status and doesn't get to the conditional - it would be interesting to see your flow that gets past this.

Reuben Schmitz

@Glen Hutson
That is what Alex had suggested as well - and I have done that, but it hasn't helped to-date.

Still getting the same error at the Get Constituent Prospect Status part: {"statusCode":404,"headers":{"Cache-Control":"no-cache","Pragma":"no-cache","Strict-Transport-Security":"max-age=31536000;includeSubDomains","Content-Security-Policy":"frame-ancestors 'self' https://host.nxt.blackbaud.com","section-io-id":"6badc2522c892a7858f11c501967aceb","Timing-Allow-Origin":"*","x-ms-apihub-cached-response":"true","x-ms-apihub-obo":"false","Date":"Wed, 29 Nov 2023 16:29:46 GMT","Content-Length":"238","Content-Type":"application/json","Expires":"-1"},"body":[{"message":"The requested operation could not be fulfilled","error_name":"RequestNotFulfilled","error_code":404,"raw_message":"The requested operation could not be fulfilled","error_args":[]}]}

Reuben Schmitz

@Glen Hutson
Glen, I should have read your post more closely - I did add that to the next part and it appears to be working now.

Reuben Schmitz

@Carol Grant Carol, I was able to get it working after all - no need for the screenshot. Thanks again for reaching out.

Reuben Schmitz

@Alex Wong
Thanks again for all your help on this. As it turns out, Glen pointed out that I needed to adjust the “configure after run” on the following Apply to each, not just the Get Constituent Prospect Status. It is now working and no further assistance on this is needed. Thanks again!

Alex Wong

@Reuben Schmitz
no problem. I should be more clear that the configure run after is on the action following the get prospect status, not the get prospect status action itself.

I was half way finish creating this flow to see where you might have the issue. I am creating it on the new editing mode, though not using copilot, so it's a good exercise for me to get to know the new editor better and provide feedback on it

@Heather McLean are you going to start a new post to gather power automate's new editor's feedback or you want me to start it

Carol Grant

@Reuben Schmitz- Glad you got it working!

Heather McLean

@Reuben Schmitz - Me, too! FYI - I did escalate internally that the Prospect Status response error isn't clear to see if we can make this easier in the future.

Reuben Schmitz

@Alex Wong This is from the meeting yesterday and, while I dislike leaning on your willingness to help, I am guessing this is an easy fix for you that somehow is escaping me. I had actually thought of a conditional when working on this, but wasn't sure how a conditional would be configured. Looking at it further, i am still not sure and not getting it correct. This is what I have - is it obvious what I am missing?

Alex Wong

@Reuben Schmitz
trying to refresh my memory on what you are working on here.

Is your condition trying to solve the issue of when there is no action solicitor?

Reuben Schmitz

@Alex Wong this is a continuation of what we were talking about at the USer Group meeting yesterday - trying to get the results to display a blank when there is no Constituent Solicitor assigned - you had suggested using a conditional - which I am looking to do, but am unsure how to tell the “No” (i.e., no Solicitor on the reocrd" to display a blank result in my email.

Reuben Schmitz

@Alex Wong Simply put, in a conditional like this, how do you get a “blank” display for use below (to avoid the system pulling in random information instead)?

Alex Wong

@Reuben Schmitz
you currently have a variable that store the constituent solicitor as you get the name of the solicitor in the “yes” path. In your “no” path, you just set the same variable to empty string.

I remember setting variable require you to put something in there, so what you can do is in the expression tab, type in string('')
This is 2 single quote inside the paranthesis, not 1 double quote.

side note in case you are not handling it this way: the “yes” path for your condition should only have actions that is for getting the solicitor constituent records and adding to the variable for solicitor name. Other actions should be outside of the condition so regardless of “yes” or “no” on the condition, it will get executed.

Reuben Schmitz

@Alex Wong To your second question - it is trying to solve the issue when there is no Constituent Solicitor on the record.