Answered

Use Flow to combine multiple columns into one, in the SAME Sharepoint List

(2) Share

Report

Posted on by Squirrels

Hi hi,

I am trying to use a Power Automate Flow to combine three columns in a Sharepoint List, and save the combination into the SAME Sharepoint List.

It appears most resources I have found show examples of variations, but I am not making sense of what to do differently in my use-case.

Any chance you have a tutorial handy for this case or can illustrate the steps?

EDIT: The reason I am looking to do this is simply to have a column that I can use as a LookUp source in other Sharepoint Lists... Because apparently one cannot LookUp Calculated column-types =(

Thanks so much!

What I am trying to achieve:

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (0)

Sort by

Squirrels 52 on at

Like (1)

Report
Copy link

Link copied!

Actually, it just occurred to me...

I have a Calculated column already which combined the information I am trying to LookUp. Is it maybe better to simplify the flow by simply having the flow copy that information into a pre-created Single Line of Text column?

Hmm.. I will search for a how-to on copying one column now and update this with my findings.

Thanks!

Was this reply helpful? Yes No
Suggested answer

Squirrels 52 on at

Like (1)

Report
Copy link

Link copied!

This is how I copied the column, noting that my trigger is when a row is added or modified (using "When an item is created or modified"), and that I was unsure how to bypass an error due to a required choice selection column and simply made that column okay to be empty in the List settings.

And now my LookUp of the copied Calculated value column works great! And I do not have to add the time overhead to my PowerApp waiting for the flow to run.

Was this reply helpful? Yes No
Squirrels 52 on at

Like (1)

Report
Copy link

Link copied!

Yikes...

Another lesson learned! FLOW LIMITS!

As this all mentally digests, I realize that my trigger is to make a change to the thing wanting to make a change on a change! 😅 Obviously!

So while the above indeed works in a basic manner... Off to a Reza or Shane YouTube Video (starting here for those following my breadcrumbs https://www.youtube.com/watch?v=oKN4_5o2NUA)! 😂

-Squirrels

Was this reply helpful? Yes No