topic MS Flow Power automate condition in ArcGIS Survey123 Questions

MS Flow Power automate condition

SusanMathai — Mon, 24 Aug 2020 18:06:53 GMT

Need some help on this MS Power Flow design. I have a list of locations, my requirement is, if a user selects a location in the survey, the flow need to check against the listed locations conditions and based on the locations list, an email should trigger to be sent to appropriate email ids. I tried using contains expression but it didn't work. Can anybody spot the right syntax to use in this condition flow shown below?

Re: MS Flow Power automate condition

Jim-Moore — Tue, 25 Aug 2020 01:15:12 GMT

Hi Susan

Perhaps the following design work? In this case, the location field is checked against three possible values inside an OR group. For the condition to pass, the first field must be "non_compliant" AND the location field must be one of three possible values:

Best,

Jim

Re: MS Flow Power automate condition

SusanMathai — Tue, 25 Aug 2020 02:59:22 GMT

Hi Jim,

Thanks for the reply, I did think about your idea but since I had a long list of locations to be itemized, was hesitant to chart it down. Nevertheless, I'll give it a try!.

Re: MS Flow Power automate condition

JamesTedrick — Fri, 28 Aug 2020 02:38:10 GMT

Hi Susan,

Jim asked me take a look at this as well. A way that might work more scalable with large lists is to look up the values from a table such as an Excel Sheet - Is there a way to pull data from one Excel table, ... - Power Platform Community provides guidance for a potential solution.