Hi there,
I have a list like this:
COLUMN 1 | COLUMN 2 | COLUMN 3 |
item 1 | fruit | candy | apples | snickers |
item 2 | fruit | candy | pear | strawberry | kit-kat |
And I'd like to take that list and create a new lookup table that looks like this:
COLUMN 4 | COLUMN 5 |
item 1 | fruit |
item 1 | candy |
item 1 | apples |
item 1 | snickers |
item 2 | fruit |
item 2 | candy |
item 2 | pear |
item 2 | strawberry |
item 2 | kit-kat |
I am brand new to using flow. I'd like to first create a batch job to run the flow for the existing data. Afterward, I'd like it set up to run everytime an item is created or modified. Reason for that is during a users session they often upload a new item or edit an existing item.
I can do this so quick using python and excel, but I can't even begin to conceptualize it in power automate and haven't been able to find a related post for this problem yet.
Any help would be great!
Here is how you can do it...
My Compose 2 expression is as below. Here we are splitting column 1 and column 2 on the separator and then making a union of the output arrays.-->
Then we are running loop on the compose output. Finally in the insert, I am adding trim so that it removes spaces. Expression is as below.. trim(items('Apply_to_each_3'))
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
Learn to digitize and optimize business processes and connect all your applications to share data in real time.
User | Count |
---|---|
30 | |
30 | |
29 | |
22 | |
11 |