web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / “Select “ null value
Power Automate
Answered

“Select “ null value

(0) ShareShare
ReportReport
Posted on by 44

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.

 

IMG_8928.jpeg

IMG_8929.jpeg

IMG_8930.jpeg

IMG_8931.jpeg

 

 

Categories:
I have the same question (0)
  • Verified answer
    v-yueyun-msft Profile Picture
    Microsoft Employee on at

    Hi , @Alondrae05 

    According to your description, this is my understanding to your need:

    vyueyunmsft_0-1715650270398.png

    This is my test flow:

    vyueyunmsft_3-1715650324232.png

     

    The Compose action is used to create the test data:

    vyueyunmsft_2-1715650309040.png

    vyueyunmsft_4-1715650343462.png

    The other actions:

    vyueyunmsft_6-1715650456833.png

     

    chunk(outputs('Compose'),6)

    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

     

     

  • AE-12082315-0 Profile Picture
    44 on at

    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.

     

    IMG_8942.jpeg

    IMG_8943.jpeg

     

  • Verified answer
    v-yueyun-msft Profile Picture
    Microsoft Employee on at

    Hi , @Alondrae05 

    Thanks for your response , if you want to add the row to sharepoint you can refer to:

    vyueyunmsft_0-1715739820979.png

     

    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

     

  • AE-12082315-0 Profile Picture
    44 on at

    You are the best, it also worked. Thank you so much! 

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Congratulations to the March Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Haque Profile Picture

Haque 608

#2
Valantis Profile Picture

Valantis 416

#3
11manish Profile Picture

11manish 348

Last 30 days Overall leaderboard