Power Automate - Using Flows

Answered

sharepoint Get Items error when trying to read emty column

(0) Share

Report

Posted on by MGamal89

Dears,

I created an action to read from a SharePoint list.

It reads the items but when I checked the body, it only contains the columns with data.

How I can read other columns too, the ones with empty values as this gives me an error when I trying to insert the item in Excel file.

Edit:

the case is that

1- I read the list items using SharePoint get items Action.

2- loop on items using apply to each

3- insert the item in DB using an on-premise gateway.

the error occurred when I try to insert an item with incomplete data, say my list has 5 fields, it gives an error if I only insert 3 fields and not the five.

Unable to process template language expressions in action 'Insert_row_(V2)' inputs at line '1' and column '2815': 'The template language expression 'item()['Revised_x0020_Baseline_x0020_Pla']' cannot be evaluated because property 'Revised_x0020_Baseline_x0020_Pla' doesn't exist, available properties are '@odata.etag, ItemInternalId, ID, Title, Baseline0_x0020_Planned_x0020__x, Actual_x0020__x0025_, {Identifier}, {IsFolder}, {Thumbnail}, {Link}, {Name}, {FilenameWithExtension}, {Path}, {FullPath}, {HasAttachments}, {VersionNumber}'. Please see https://aka.ms/logicexpressions for usage details.'.

All responses (6)

Answers (2)

MGamal89 8 on at

Like (0)

Report

Re: sharepoint Get Items error when trying to read emty column

I didn't try it, but I think it will work too.
I used Contain function.
Thanks for your reply.
MGamal89 8 on at

Like (0)

Report

Re: sharepoint Get Items error when trying to read emty column

it Works. Also i used Contain function and it works too.
Thanks.
Verified answer

v-alzhan-msft on at

Like (0)

Report
Re: sharepoint Get Items error when trying to read emty column

Hi @MGamal89 ,

Take a try with expression for each column insert to the server:

if(equals(length(ColumnExpression),0),null, ColumnExpression)

Example:

if(equals(length(items('Apply_to_each')?['Title']),0),null,items('Apply_to_each')?['Title'])

Best Regards,

Alice

Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Verified answer

ScottShearer 25,208 Most Valuable Professional on at

Like (0)

Report

Re: sharepoint Get Items error when trying to read emty column

@MGamal89

Haven't tested this, but give this a try...

Replace all references to SharePoint columns that are not required columns with an expression similar to my example below. My example references the title column:

if(equals(body('Get_item')['Title'],null),null,body('Get_item')['Title'])
MGamal89 8 on at

Like (0)

Report

Re: sharepoint Get Items error when trying to read emty column

Thanks for your reply.
I updated the main message with a screenshot of the flow section with the error.
Also, I added a scenario of what I'm doing to see the error
ScottShearer 25,208 Most Valuable Professional on at

Like (0)

Report

Re: sharepoint Get Items error when trying to read emty column

@MGamal89

Please post a screen shot of your Flow in edit mode - that will be a big help to those trrying to assist.

Community site session details

sharepoint Get Items error when trying to read emty column

Helpful resources

News and Announcements

Quick Links

🌸 Community Spring Festival 2025 Challenge 🌸

Markus Franz – Community Spotlight

Kudos to the March Top 10 Community Stars!

Leaderboard

Featured topics

Product updates

Community site session details

sharepoint Get Items error when trying to read emty column

Helpful resources

News and Announcements

Quick Links

🌸 Community Spring Festival 2025 Challenge 🌸

Markus Franz – Community Spotlight

Kudos to the March Top 10 Community Stars!

Subscribe to this forum!

Select categories

Leaderboard

Featured topics

Product updates