Hello All,
I created a flow that sends me an email whenever an item is update in my sharepoint list. The email consists of 5 columns (technology, name of the field that change, previous field value, current field value and updated by).
I created a second flow that is supposed to extract the value of the HTML table I get via email (see picture of the table I get) and add those values to a second sharepoint list. However when I run the flow on the “select “ “from” step (highlighted in picture) I can see the changes I made which is good but in the “output “ of the select the fields I need show as “null”
this is the function I have for each of the field in the “select “ step
technology : split(item(),’^’)[0]. This one works fine
Name of the field that change: split(item(),’^’)?[1]
previous field value: split(item(),’^’)?[2]
the last two shows as NULL
what I need:
A function that allows me to get the value shown in select“inputs “ (highlighted in picture) so I can add those values to a second sharepoint list.
You are the best, it also worked. Thank you so much!
Hi , @Alondrae05
Thanks for your response , if you want to add the row to sharepoint you can refer to:
item()?['Technology']
item()?['Name of Field that Changed']
item()?['Previous Field Value']
item()?['Current Field Value']
item()?['Updated By']
If this reply can help you , you can click mark this reply as solution (Accept solution) which can help more people, thanks in advance!
Best Regards,
Yueyun Zhang
It worked! Thank you so much. I have another question. Maybe you can help me. Now I need to add the values individually to a sharepoint list. I tried to add the expression you provided individually to each of the columns I need in the “create item” action but it did not work.
what I need:
-how can I add the values of the “compose 2” individually and add it to the “create item” action where is highlighted in picture.
Hi , @Alondrae05
According to your description, this is my understanding to your need:
This is my test flow:
The Compose action is used to create the test data:
The other actions:
item()?[0]
split(item()?[1],'^')?[1]
split(item()?[2],'^')?[1]
split(item()?[3],'^')?[1]
split(item()?[4],'^')?[1]
outputs('Compose_3')
If this reply can help you , you can click mark this reply as solution (Accept solution) which can help more people, thanks in advance!
Best Regards,
Yueyun Zhang