Need help loop trough all records

[Radoslavov]

Hi all. 

i tries searching for the answer but I wasn't able to find any solution, so my last action is to ask here.

I have a workflow which when a email address is received from Power Virtual Agent, it will go in Dynamics CRM, will search for an existing account with this email address, and if available i want to return all subscriptions.

I have a custom entity called subscriptions, that contains a certain product (OOB entity in CRM), contains start and expiration date, and account (lookup to Account entity).

So if a user ask the bot when my subscription expires, the bot will ask the user for an email address, power automate will search for an account with this email address, and then will loop trough all subscriptions of the account and will say something like. "i see the following subscriptions are available for the Account (account name field) which expires on Expiration Date filed

So basically here we have two entities involved

Account and Subscription.

From Account i need the Account Name filed which i can get with the List records step where i'm filtering the result by email address input from the user.

From subscription i need only the expiration date filed.

This is the WF how it looks like so far.

here I'm searching for subscriptions where account is the same as the previous result

And here is basically where i'm stuck in getting the details for each result (each subscription)

I'm sharing also a subscription entity solution for dynamics crm in case someone want to test it.

https://crm632903-my.sharepoint.com/:u:/g/personal/admin_crm632903_onmicrosoft_com/Ea_bVHucYBVLqfZHC...

So if the account have 3 subscriptions i should be able to get each of these 3 subscription's expiration dates values and pass it over to the bot as Output results.

Hope manage to explain the scenario well.

Let me know if you have more clarification.

Regards

Kiril

[fchopo]

Hello @Radoslavov 

After getting the account record, you should:

1) Check if there's at least one element (condition).

2) Get Account value of the first element.

3) Get the subscriptions for that account.

Hope it helps!

Ferran

[Radoslavov]

Hi @fchopo ,

I've added the extra steps however now I'm trying to add as outputs the subscription properties such as Subscription number and Expiration date, which i can see from the list of options but still get the error message: The output you selected is inside a collection and needs to be looped over to be accessed. This action cannot be inside a foreach.

Any suggestions how to add this properties?

Regards

Kiril

[fchopo]

Hello @Radoslavov 

I would add the results to a string variable, and then return it to PVA (after the apply to each):

Hope it helps!

Ferran

[Radoslavov]

Great, i think that I'm only missing something as i'm unable to select anything for name as on your picture. I guess there should be a step somewhere with additional actions.

Apologies it is my first time using array functions in flow. Once i understand how it works for sure will get better.

Regards

Kiril

[fchopo]

Hello @Radoslavov 

Sorry, I forgot to mention I used an "Initialize Variable" action at the beginning of the flow:

Regards,

Ferran

[Radoslavov]

Still not working

i did the following changes

If(greater(length(outputs('Get_Account')?['body/value']),0), true, false)

`but my flow fails

Any idea what might have gone wrong in the flow?

regards

Kiril

[fchopo]

Hello @Radoslavov 

In the "Get Subscription Details" action you are using a filter expression that is not allowed, since the crbc2_Account field is a binary one and could not be compared with a string value. Could you use the following filter?

crbc2_account_value eq '...'

Have a look at this thread about comparing guid values: Solved: Filter Query in List Records not working for Looku... - Power Platform Community (microsoft....

Regards,

Ferran

[Radoslavov]

Nope,

Could not find a property named 'crbc2_account_value' on type 'Microsoft.Dynamics.CRM.crbc2_subscriptions'.

I dont know what else to try.

regards

Kiril

[Radoslavov]

perhaps there is another way to build the flow to achieve the same result?

[fchopo]

Hello @Radoslavov 

We are getting closer. If we want to know the internal name of the crbc2_account column, you should excute the flow, or at least the action, and inspect the output. Could you please create another flow and add the Get Subscriptions action and see the output results? There we will be able to see the column names.

Regards,

Ferran

[fchopo · Accepted solution]

Hello again @Radoslavov 

I've doing some tests on my side and this sample is working fine:

In this case, the filter query expression is:

_cr7dd_account_value eq '@{outputs('Compose_-_Get_Account_ID')}'

So the column name is "_cr7dd_account_value". Maybe in your case you have to place an "_" in front of the column name too.

Hope it helps!

Ferran

[Radoslavov]

OMG! Finally, it worked!

Thank you so much for the patience and time spent on this.

This is the outcome:

And this is the fixed flow:

indeed it was the _ in from of the crbc2_account along with additional _value but with a combination with Account (the unique identifier of the account) instead of the Output from the  Compose for Account step, as I already know the account from the Get Account step filtered by the email address send by the customer, which step returned TRUE (0) as such account exists in the CDS.

Once again, thank you for helping me with this, I can't wait to extend this even further as now I know the logic and behind.

Stay safe and God bless.

Regards

Kiril