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.'.
