Hey people,
I tried chatGPT, I tried Copilot, I tried videos, I tried Google searches, but I can't find any answer (and I assume it should be quite simple).
I want to create a list for my Sharepoint. A list from all 'cities' in the personal information of all users - bonus if cities can be made unique and not show up 100 times.
This is what I have so far (already sorry that it's german):
My thoughts:
-> Trigger (manually for now, no idea how to trigger it)
-> initialize variable (array) empty
-> search for users V2
-> loop through all users
-> "Select" from previous 'value', map: 'City' value: item()?['city']
-> "add to array" (City) (output from Select)
-> Create List
Last one, creating an element/list is my biggest issue, I have no options to select any output from the previous loop and I don't get why. I have the option to directly select City ('Ort') from the previous 'Search for users' which makes me wonder if I think too complicated or if Power Automate is smart enough to automatically generate an array if I just completely ignore the whole loop inbetween? Also I have no idea how to test it.
Thanks in advance :)