Sharepoint List Issue

(0) Share

Report

Posted on by dan1234

Hi everyone,

I am posting here to get some help from the experts.

I am new to the Power Automate and was trying to build a flow that can help get the data from a List in Sharepoint once a month, like a real-time snapshot and output the same to a CSV file.

The file format should be csv file, and it can't be an excel.

We can't connect directly to SharePoint due to the need to track it historically.

The issue is that users have the option to put a hyphen at the start of a description input, e.g. - text is text, etc.; in CSV file, it is recognised as a formula as it is a minus sign.

I am attaching the image and file to understand it better and the options I select in flow.

Has anyone found any similar situation and been able to solve it? Any help would be much appreciated.

Categories:

Using flows

I have the same question (0)

All responses (4)

Answers (1)

Expiscornovus 33,189 Most Valuable Professional on at

Like (0)

Report

Hi @dan1234,

You could put quotes around the values so they are recognized as text.

Was this reply helpful? Yes No
dan1234 6 on at

Like (0)

Report

Hello,

Thanks a lot this is working. Just a question is there an option to add a column in between in “ crate csv file” after we create the flow? I mean like to append a new row after column 1 and column 2 at a later point. I am trying to hit enter shift + enter and option’s available but no luck yet.

Thanks again.

Was this reply helpful? Yes No
dan1234 6 on at

Like (0)

Report

Hello,

Thanks a lot this is working. Just a question is there an option to add a column in between in “ crate csv file” after we create the flow? I mean like to append a new row after column 1 and column 2 at a later point. I am trying to hit enter shift + enter and option’s available but no luck yet.

Thanks again.

Was this reply helpful? Yes No
Verified answer

Expiscornovus 33,189 Most Valuable Professional on at

Like (0)

Report

Hi @dan1234,

It should be possible to add or remove custom header rows after the flow has been created.

Was this reply helpful? Yes No