export drop down SP List fields

(0) Share

Report

Posted on by Coopedup

355

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

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

rsaikrishna

3,703 Microsoft Employee on at

Like (0)

Report

Copy link

Link copied!

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

Was this reply helpful? Yes No

Coopedup 355 on at

Like (0)

Report
Copy link

Link copied!

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!

Was this reply helpful? Yes No
Verified answer

Coopedup 355 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No