Answered

SharePoint List Create Item Returns 'Null' Value for valid SharePoint List Multi-Line Column Value

(0) Share

Report

Posted on by IPush2Prod

I have a simple cloud flow that takes details from a newly created SharePoint List item, and inserts them into 3 separate SharePoint Lists. The 'Create Item' action is pulling all of the correct dynamic content, except for a field that contains multi-line text, which is returned as 'null':

Doing some research it appears that a similar issue occurred whenever the multi-line column was set to 'append changes' but I do not have that setting enabled.

The only thing I could think of is the suggested dynamic content is not correcting pulling the Item ID of newly created item, or it isn't there yet.

I tried creating a separate 'update item' action but it returned the same 'null' value for the Description field.

Categories:

Building flows

I have the same question (0)

All responses (6)

Answers (1)

Ellis Karim 11,695 Super User 2025 Season 2 on at

Like (0)

Report

Hi @IPush2Prod ,

The null value would mean that the column does not contain any data :

Can you share your flow?

Ellis
____________________________________
If I have answered your question, please mark the post as ☑️ Solved.
If you like my response, please give it a Thumbs Up.
My Blog Site

Was this reply helpful? Yes No
IPush2Prod 8 on at

Like (0)

Report

Hey Ellis thanks for your reply.

I understand that Power Automate believes there is no data, but I have confirmed that the data is there.

I cannot share my entire flow, is there something specific you would like to see?

Was this reply helpful? Yes No
Ellis Karim 11,695 Super User 2025 Season 2 on at

Like (0)

Report

Hi @IPush2Prod ,

I would only need to see the high-level actions.

What is the trigger action? The trigger body contains the data that you are using to update your three other lists?

For Testing: After the flow runs can you confirm that the description column contains data? Use a compose variable to store description by adding the compose action after the trigger. Then use the compose variable to update the other lists.

Ellis
____________________________________
If I have answered your question, please mark the post as ☑️ Solved.
If you like my response, please give it a Thumbs Up.
My Blog Site

Was this reply helpful? Yes No
IPush2Prod 8 on at

Like (0)

Report

That's a great idea! I went ahead and added a 'Compose' action to collect data from all three columns.

Here is the overview of the flow, along with the results of the 'Compose' step:

I'm starting to think that the data entered into the SharePoint list is not immediately available whenever the item is created first, I might have to check the pipe further up.

Edit: To be clear, the data is there 'now' but since the trigger is 'when a new item is created' the data has not yet been recorded/settled.

Was this reply helpful? Yes No
Verified answer

Ellis Karim 11,695 Super User 2025 Season 2 on at

Like (0)

Report

Place the compose variable as shown above. After the flow has run, examine the content of the compose action.

Then in your Create Item #1, Create Item #2 and Create Item #3 actions use the compose variable to update the Description columns.

What results do you see?

Ellis
____________________________________
If I have answered your question, please mark the post as ☑️ Solved.
If you like my response, please give it a Thumbs Up.
My Blog Site

Was this reply helpful? Yes No
IPush2Prod 8 on at

Like (0)

Report

I have replaced the trigger to whenever an item is 'created or updated' and confirmed that the description is now there. Thanks for the troubleshooting steps!

Was this reply helpful? Yes No