Skip to main content

Notifications

Power Automate - General Discussion
Answered

“Select “ null value

(0) ShareShare
ReportReport
Posted on by 40

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

 

 

  • AE-12082315-0 Profile Picture
    AE-12082315-0 40 on at
    Re: “Select “ null value

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

  • Verified answer
    Re: “Select “ null value

    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
    AE-12082315-0 40 on at
    Re: “Select “ null value

    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
    Re: “Select “ null value

    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

     

     

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

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,495

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,822

Leaderboard