cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
invintern
Helper II
Helper II

List Rows in Dataverse containing [custom variable]; Multiple Results Given; How to pick the right choice?

Hi,

 

I have developed a Flow which watches a Planner Group, sees a Card being created/closed, follows a logical path to its linked Planner and create a duplicate there/close the duplicate there.

 

This intentionally allows Client Relations to work from their own Planner Group while the relevant items find there way to the Planner Plans of each Account.

 

Essentially, when a Card is created, Client Relations uses a set list of names to trigger these Flows.

 

In this case, the Short List trigger name is 'OC.'

 

Flow sees that, looks into D365 field Short Names for anything CONTAINING OC, pulls up that account, finds its Team Channel, sends it down the path to its Team of the same name (OC).

 

BUT I have two Accounts with Short Names CONTAINING OC: OC and Block.

 

We have a database of about 90 Accounts, so this hasn't come up before, but I am sure it will again.

 

invintern_0-1650494593407.png

invintern_3-1650494697119.png

invintern_4-1650494715994.png

I thought I could use a filter to choose the Account I want, but the filter seems to filter out everything,

 

invintern_5-1650494783227.png

invintern_6-1650494804640.png

As you can see, the Filter looks for anything in its results equal to 'handwritten account name' "OC."

 

I assumed that the filter would see that result 2 of my Apply to Each contains the OC I am looking for....but it looks like PA including them into 1 string that cannot be filtered by Array.

 

I want to parse that "OC" value from the Filter so I can attach it to my text ' - task list' for "oc - task list' - How can I do this?

1 REPLY 1
takolota
Super User
Super User

@invintern 

 

Please confirm I am getting this straight.

You have a process that depends on something like an account name containing OC, but you can’t set it to equal OC because the account name may have something other than OC that will change. Correct?

 

Is it possible to standardize the format so OC always comes at the end or something?

That way you could just use a split of the name to check for OC?

Like 

IF

Last(

Split(‘Joe OC’, ‘ ‘)

)

EQUALS OC

THEN…

Helpful resources

Announcements
Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Difinity Conference 2022

Difinity Conference 2022

Register today for two amazing days of learning, featuring intensive learning sessions across multiple tracks, led by engaging and dynamic experts.

European SharePoint Conference

European SharePoint Conference

The European SharePoint Conference returns live and in-person November 28-December 1 with 4 Microsoft Keynotes, 9 Tutorials, and 120 Sessions.

Users online (2,738)