export drop down SP List fields

Like (0) Share

Report

Posted on 14 Dec 2020 16:01:15 by Coopedup

310

Hi all,

There are so many of these requests and so many options and issues that it amazes me the MS haven't built something for this (I mean the connecting of two MS products shouldn't be this hard)!

I have a SP list where I want to export my filtered Gallery records via a flow automate.

My first approach was to concat the fields I needed (actually all 26 of them!) and export them to a csv. This gave me issues where a user had put in a "," in their text and would very badly format across multiple columns.

I've then tried JSON, but a lot of my fields are "complex" drop downs etc. so the JSON option fails and making a text replica of this data is not great.

I'd rather use the first option but need to somehow account for "," in the field and prevent them becoming a separator (equally can I write to an xls file and avoid the commas?) . Can this be done?

Neil

All responses (3)

Answers (1)

Verified answer

Coopedup 310 on 17 Dec 2020 at 09:06:37

Like (0)

Report

Re: export drop down SP List fields

Because of my data source type and the field content (drop downs and fields that contained commas), I had to go around the houses for this.
Each filed that needs to report on which either a drop down or person look up has been replicated in the SP List as a simple single line text field. In my app I added these as hidden fields that would copy the data card value from original interacted drop list or person lookup. I then build a collection with my text only fields and fed that collection into JSON.

Best note for all. If you are building a JSON parser in MS Automate, feed in the test with null fields first. I've found that my data is not always populated (historical reasons) which meant the parser will build based on data present and give a not null error.
Coopedup 310 on 15 Dec 2020 at 10:01:34

Like (0)

Report

Re: export drop down SP List fields

I had seen this video and is one of those situations that gives a solution but more issues. My organisation will not allow users to install 3rd party code. So I'll keep on looking!

rsaikrishna

3,703 on 14 Dec 2020 at 16:14:50

Like (0)

Report

Re: export drop down SP List fields

@Coopedup

Check this @aprildunnam video on export to excel:

https://www.youtube.com/watch?v=xqUBFJfNvyM&ab_channel=AprilDunnam

The component will provide an option to export direct to excel.

Regards

Krishna Rachakonda

If this reply helped you to solve the issue, please mark the post as Accepted Solution. Marking this post as Accepted Solution, will help many other users to use this post to solve same or similar issue without re-posting the issue in the group. Saves a lot of time for everyone.