Hi
I'm trying to log emails from certain domains to an Excel list. How can I specify the list of domains to watch for by using a table in an Excel file? i.e. if email is from [any of the domains in table 1] add the message to [table 2].
I've managed to do this, but need to 'hardcode' the domains into the flow. Can anyone tell me how I can read them from table 1?
thanks!
Hi @ineichenM
You can achieve this using a filter array action.
Get rows from your excel table, filter the result based on the domain of the incoming email, using a condition on the length of the filter array greater than 0 (i.e. filter returns a match) you either have a match -> yes or no match -> no branch.
So:
List Rows
Filter Result from above on Domain
Check if length(filterarray)> 0
Yes or No
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Cheers,
Damien
P.S. take a look at my new blog here and like & subscribe to my YouTube Channel thanks 😉
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
Announcing a new way to share your feedback with the Power Automate Team.
Learn to digitize and optimize business processes and connect all your applications to share data in real time.
User | Count |
---|---|
64 | |
23 | |
16 | |
15 | |
11 |
User | Count |
---|---|
121 | |
36 | |
32 | |
28 | |
26 |