Split String and match to column

(0) Share

Report

Posted on by mark90

Hi,

I'm I have a SharePoint list with 50 Concenated columns. 25 columns are dropdown columns and 25 are related comments.

I'm trying to write a flow which will split the dropdown values and then write to a SharePoint list as a single line item with its related comment.

I'd also like to only submit certain dropdown values into the SharePoint list (if possible)

Data Examples:

Title Column A Column B

Project A Observation, Conformance, Improvement All good, more work, test one

Project B Observation, Conformance, Improvement All good, more work, test one

I want to then take only 'observation' + comment into the new Sharepoint list,

Thanks for the help!

Categories:

Building flows

I have the same question (0)

All responses (7)

Answers (1)

Sort by

KvB1 1,596 on at

Like (0)

Report
Copy link

Link copied!

Hi, so column A is a dropdown column, and column B is just text?

The 'certain' dropdown values you want to submit into the list, are they fixed?

Was this reply helpful? Yes No
mark90 25 on at

Like (0)

Report
Copy link

Link copied!

Yeah all data in drop down column is fixed text,

Only comments column is free text,

Thanks for the help @KvB1

Was this reply helpful? Yes No
KvB1 1,596 on at

Like (0)

Report
Copy link

Link copied!

I mean, is the sharepoint column for column A a choice column, or single line of text?

Was this reply helpful? Yes No
mark90 25 on at

Like (0)

Report
Copy link

Link copied!

single line of text, thanks

Was this reply helpful? Yes No
KvB1 1,596 on at

Like (0)

Report
Copy link

Link copied!

Okay, you could for example use the 'when an item is created' trigger in combination with an odata filter
startswith(Column, 'Observation')

This means the flow will be triggered when an item is created and Column A starts with Observation.

Then you fill a field concatenating the 2 fields that you want. We can create an expression splitting the Column A by the comma and taking the first, but since we already have an odata filter that filters on this, you can also just hardcode it since its impossible for another value to be in that position.

Something like:
concat('Observation, ','Column B')

Was this reply helpful? Yes No
mark90 25 on at

Like (0)

Report
Copy link

Link copied!

Hey,

That's really cool, few questions;

1) I have 50 columns with drop down values so 50 columns which could start with observation, will this still work with the Odatafilter?

2) my column B comments column, (also 50 matching columns) has concatenated values already. I'd need to split the column and match the corresponding value. Ie. Column A value 3 = observation then Column B value 3 = matching comment

I'd then use these values and save them into a list,

Thanks so much for the help!

Was this reply helpful? Yes No
Verified answer

KvB1 1,596 on at

Like (1)

Report
Copy link

Link copied!

1) Do you mean that there are 50 columns that look like 'Column A' in your example in the sharepoint list? The filter applies to the column specified, and if you really have 50 columns (that really seems like a large amount) you would have to add a filter for each column

2) The way it works, is that you can filter on a column, and it will return the entire row. For example, you filter on 'Column A' matching, or starting with, a specific value, then it will return the row that passes that filter. So if by matching comment you mean: 'the text stored in a different column of the same row', then this will be a good approach

Was this reply helpful? Yes No