Get value from lookup column in sharepoint into CSV file

(1) Share

Report

Posted on by lalford09

163

Hi,

I have a flow that Creates a CSV file, however within that file it pulls data from a lookup column in SharePoint called GI_TechObj_Application. When I then open the excel file that data comes through like this:

[{"Id":5197,"Value":"A Cloud Guru"},{"Id":4689,"Value":"MXR has changed"},{"Id":5249,"Value":"Zenith"}]

However I only need the data after Value, for example A Cloud Guru, MXR has changed, Zenith.

Here is my flow:

I was using item?['GI_TechObj_Application'] to get the value into the Create CSV table.

Any help would be appreciated.

Categories:

General topics

I have the same question (0)

All responses (3)

Answers (0)

Sort by

lbendlin 8,711 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

That column comes over as an array of values. You need to specify how you want to delimit the values without interfering with the CSV field delimiter.

Was this reply helpful? Yes No
SudeepGhatakNZ 14,396 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

@lalford09

I have attached a sample flow.

This flow retrieves items from a SharePoint list and creates an HTML table with the retrieved data.

The Manager and Pricing fields are People and Lookup column respectively.

It loops through each item, extracts the "Title" and "Manager" fields, and concatenates the values from the "Pricing" field into a string. Finally, it creates an HTML table using the extracted data. You could swap it with a CSV action.

Output:

Dealingwithmultic...

Was this reply helpful? Yes No
lalford09 163 on at

Like (1)

Report
Copy link

Link copied!

@SudeepGhatakNZ Thanks for your reply, but how can I change your flow so that I'm not using a Get Items, as it get all my items from the app itself on the click of a button like so:

ForAll(col_All,
Collect(col_AllExport,
{
Title: ThisRecord.Title,
ID: ThisRecord.ID,
Created: ThisRecord.Created,
'Created By': ThisRecord.'Created By'.Email,
Modified: ThisRecord.Modified,
LookupCol: ThisRecord.LookupCol
}));
Set(varCSVFile, Export.Run(JSON(col_AllExport, JSONFormat.IncludeBinaryData & JSONFormat.IgnoreUnsupportedTypes)).filelink);

So it gets the data from a collection, passes that into the flow, runs the flow and then passes the file back into the app.

Was this reply helpful? Yes No