cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
sajarac
Kudo Kingpin
Kudo Kingpin

Push Notification error too many child clauses

Hi there. I am currently trying to send a push notification to my app users "around 50" users and I am getting this error:

 

The request failed with error: '{"odata.error":{"code":"Request_UnsupportedQuery","message":{"lang":"en","value":"Too many child clauses specified in search filter expression containing 'OR' operators: 96. Max allowed: 15."},"requestId":"170d................"

 

 

sajarac_0-1632753146467.png

 

Any help please?

 

Thanks in advance

2 ACCEPTED SOLUTIONS

Accepted Solutions
Pstork1
Dual Super User III
Dual Super User III

You can't use an array of email addresses for the recipients.  You have to use a semicolon delimited list of email addresses.  That's why you are getting the error.



-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

View solution in original post

@sajarac 

1. Initialize a string variable

2. Use an apply to each action for body('Select')

3. Inside an apply yo each action use Append to a string variable. Use the variable initialized on step 1 on Name and items('Apply_to_each')?['email'];

gabibalaban_1-1634149509414.png

 

@Pstork1, sorry for my interference !😊

View solution in original post

16 REPLIES 16
Pstork1
Dual Super User III
Dual Super User III

Which action are you getting the error on?  



-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Hi, thank you very much for your prompt response. I am getting the error in the last step

 

sajarac_0-1632834746165.png

 

Hi @Pstork1 , sorry to bother you. Did you have some time to check about this issue?

thanks in advance

Pstork1
Dual Super User III
Dual Super User III

Can you show me a screenshot of the configuration for the push notification?



-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Thank you very much for your prompt response.

 

Here is:

 

sajarac_0-1634135870060.png

 

Pstork1
Dual Super User III
Dual Super User III

You can't use an array of email addresses for the recipients.  You have to use a semicolon delimited list of email addresses.  That's why you are getting the error.



-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

View solution in original post

OK. So this means that in the recipients instead of the Output I need to convert that output to a list with semicolon?

Sorry just learning. Could you please let me know how?

@sajarac 

1. Initialize a string variable

2. Use an apply to each action for body('Select')

3. Inside an apply yo each action use Append to a string variable. Use the variable initialized on step 1 on Name and items('Apply_to_each')?['email'];

gabibalaban_1-1634149509414.png

 

@Pstork1, sorry for my interference !😊

View solution in original post

Sorry,

 

Like this?

 

sajarac_0-1634150083758.png

 

yes ...

in apply to each ...

      steps of previous ...  put (with the help of dynamic content -> expressions) : body('Select')

in append to a string variable ...

      value (also with the help of dynamic content -> expressions): items('Apply_to_each')?['email']

     and let the ; near the formula.

 

sajarac_0-1634151008313.png

 

sajarac_1-1634150942778.png

 

 

Unable to process template language expressions in action 'Append_to_string_variable' inputs at line '1' and column '15393': 'The template language expression 'items('Apply_to_each')?['email']' cannot be evaluated because property 'email' cannot be selected. Property selection is not supported on values of type 'String'. Please see https://aka.ms/logicexpressions for usage details.'.

@sajarac ,

Sorry, It seems that I didn't pay to much attention to your select action. The correct formula is without ['email']:

items('Apply_to_each')

sajarac
Kudo Kingpin
Kudo Kingpin

Hi. 

Sorry to be a pain but the flow still complaining.

 

sajarac_0-1634211788734.png

 

gabibalaban
Super User
Super User

@sajarac ,

For Push Notification use: variables('varEmails')

gabibalaban_0-1634212158890.png

 

@sajarac ,

If everything works fine, please accept as solution the @Pstork1 's answer. 

Thank you !

sajarac
Kudo Kingpin
Kudo Kingpin

Thank you very much to both @Pstork1 and @gabibalaban , Just to recap and help other users sending a PUSH notification for many users :

 

You can't use an array of email addresses for the recipients.  You have to use a semicolon delimited list of email addresses.  That's why you are getting the error.

 

And t change that array you need to do:

 

1. Initialize a string variable

2. Use an apply to each action for body('Select')

3. Inside an apply yo each action use Append to a string variable. Use the variable initialized on step 1 on Name and items('Apply_to_each');

 

Thanks again both for taking the time to check this!

 

🙂

 

 

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Users online (2,910)