Issue with extracting Number type column from a sharepoint list to a CSV file

(1) Share

Report

Posted on by nephar

I am trying to extract columns of type Number from sharepoint list to a csv file. One of the Columns has a default value of 1 and another one with no default blank. My flow is using Get item, xml, create csv table and create file ACTIONS. I tried with the following expressions

if(equals(xpath(item(), 'string(//Field_6/text())'), ''), 1, number(xpath(item(), 'string(//Field_6/text())'))) and

if(not(empty(xpath(item(), 'string(//Field_6/text())'))), number(xpath(item(), 'string(//Field_6/text())')), 1)

But this is setting field_6 value to 1 and not reading the actual value !

Can anyone suggest me what is wrong with this expression and provide the correct syntax please.

Categories:

Business Process Flows

I have the same question (0)

All responses (3)

Answers (0)

Suggested answer

Michael E. Gernaey 51,937 Super User 2025 Season 2 on at

Like (2)

Report

Issue with extracting Number type column from a sharepoint list to a CSV file

Hi,

I am sorry but I am confused. What XML as you talking about? Sharepoint has no XML columns, so I have no idea what you are talking about.

Please share more details on the columns, their data types etc. Also share the flow, please don't try to explain it, as so many people forget things,typos, oopsees.

Share the details for more help.

For example this is not valid

'string(//Field_6/text())'

you do not place single quotes around the function/expression string so again, please share exactly whats in your flow and clarify what the Error is,

Was this reply helpful? Yes No
nephar 6 on at

Like (0)

Report

Issue with extracting Number type column from a sharepoint list to a CSV file

@FLMike Apologies for wrong term, actually it is Compose action I renamed as xml. My flow is -

Compose(xml) Input expression is -

xml(json(concat('{"root": { value:', outputs('Get_items')?['body/value'], '}}')))

Field_6 Data type is Number and default vale is set to 1. Similarly Field_7 data type is Number and no default value is set for Field_7.
Can anyone please suggest me the best expression to extract these two number columns into a csv file ?

Was this reply helpful? Yes No
Suggested answer

nephar 6 on at

Like (0)

Report

Issue with extracting Number type column from a sharepoint list to a CSV file

@FLMike Apologies for wrong term, actually it is Compose action I renamed as xml. My flow is -

Compose(xml) expression is -

xml(json(concat('{"root": { value:', outputs('Get_items')?['body/value'], '}}')))

Field_6 Data type is Number and default vale is set to 1. Similarly Field_7 data type is Number and no default value is set for Field_7. When I run the flow I just get the default value and not the exact value for Field_6. Can any one explain why I am getting all values=Default and not the exact value ?

Was this reply helpful? Yes No