Hello - I am trying to get an email to send when a new item is added to a SharePoint when a specific field is triggered. You can see by the picture I have two (there are more) processes. The first "HOME TYPE = SDU" works and sends the email, however, it will not send based on the zip code in the other.
What am I doing wrong? In my mind, if SDU is not selected, it would automatically flow to look for the zip code and send it to the respective person.
Solved! Go to Solution.
@kylevallentine This is not a correct way to create array. Filter array is used when you have list of collection and want to filter column value etc.
This will not help you here.
Simply write all your zip codes in a compose action seperated by comma.
Then in condition use this-
Outputs('compose') contains yourzip column.
Please 'Thumbs Up' the posts that helped you and 'Mark as Solution' if my post answered your question.
Move "CORISSA" to the leftmost "If no".
Thanks for the tip. That didn't work. There are a few layers of zip codes I am trying to layer so maybe that is causing something? Seems pretty straightforward, but the email only sends to the initial home type and doesn't use the "NO" side of things. Attached is a photo of how I set it up.
.
@kylevallentine Pls use one compose action and pass you zip column in it. Run your flow and see compose output. In this way you will get to know what actual value is coming from zip column.
Is one list item column zip contains all these zip codes in first right condition block or one for one line item. If it is one for one line item then you should try with contains in logic.
Please 'Thumbs Up' the posts that helped you and 'Mark as Solution' if my post answered your question.
@Hardesh15 Thanks for the tip and I think that is absolutely what I need! Yes - there are a lot of zip codes. How was I set up the logic expression? I posted a simplified pic of what I am trying now and the error I am getting.
Create the array ZipArr that contains all zip codes you need and change the condition to
ZipArr contains (zipValue)
@VictorIvanidze - thank you! Makes sense. I am stuck at the "from". I put in the SharePoint address, but that didn't work and there is no dynamic content given other than the formulas. What am I missing now?
I added the "Initialize variable" before the filter array as well.
@kylevallentine This is not a correct way to create array. Filter array is used when you have list of collection and want to filter column value etc.
This will not help you here.
Simply write all your zip codes in a compose action seperated by comma.
Then in condition use this-
Outputs('compose') contains yourzip column.
Please 'Thumbs Up' the posts that helped you and 'Mark as Solution' if my post answered your question.
@Hardesh15 - that seemed to work a lot better. It did work in a test environment, but when I actually submitted the form and it converted to the SharePoint list, nothing was sent.
Now it is giving me this:
Working now. I removed the "zip" and put the actual ones in there.
Learn to digitize and optimize business processes and connect all your applications to share data in real time.
Read the latest about new experiences and capabilities in the Power Automate product blog.
If you are a small business ISV/Reseller, share your thoughts with our research team.
User | Count |
---|---|
26 | |
25 | |
23 | |
23 | |
14 |
User | Count |
---|---|
46 | |
33 | |
32 | |
31 | |
30 |