i am trying to build a flow which would help me achieve following requirements but i am not sure how it can be done.
I have a sharePoint list which has different projects with single selection People Picker as IT Lead.
Now what i want to do is to collect all projects as per IT Lead and create an csv for it and mail it to IT Leaders.
Not sure how it can be done, any help would be really appreciated.
My approach would be:
Does that make sense?
This can probably be done with a union function and a couple of other data operations actions like select and filter array.
I have found an example Power Automate Community blog with such an approach:
Hope this helps a bit and let us know if you need any additional help setting it up.
@Paulie78 it does make sense, but do you have a sample power automate workflow that i can look at so that i can get it more clearly?
it would help alot!!
@Paulie78 i was able to get the unique names in array. But when i use filter array it does provide me output.
My filter array does not work properly. it does not match with the email id and provide an output.
it does not match anything and provide an output. if it provides output then i can create an csv file but it does not provide output.
It looks right, stick two compose actions before the filter array. Put IT Lead Email in one, and
@Paulie78 i tried but no luck.
Using filter array, when I see the inputs for filter array, it shows the whole record is being sent as an input. I tried putting compose action and it is showing the correct email id. however, it does not match with IT Lead email.
Stuck here, not able to move forward. Please help!
@Paulie78 i tired using another people picker value also but it is not working. It gets the unqiue names in array but filtering array does not work. Not even sure why it is not working.
Check out new user group experience and if you are a leader please create your group
See the latest Power Automate innovations, updates, and demos from the Microsoft Business Applications Launch Event.
Many congratulations to the Season 1 2021 Flownaut Crew!
ISV Studio is the go-to Power Platform destination for ISV’s to monitor & manage applications post-AppSource publish.