Unanswered

How to copy true/false from one SharePoint list to another

(0) Share

Report

Posted on by Tobias12

Can I copy true/false values from one SharePoint list to another if both lists have identical columns?
How can I achieve this effectively?

Categories:

Building flows

I have the same question (0)

All responses (6)

Answers (0)

Tobias12 18 on at

Like (0)

Report

Here is a small extract of the relevant columns which I receive when downloading the output after simply getting the items from the one Sharepoint list:

"Name1": true,
"Name2": true,
"Name3": "x",

Was this reply helpful? Yes No
creativeopinion 10,502 Super User 2025 Season 2 on at

Like (0)

Report

@Tobias12 Can you confirm what type of column you are using? Is it a Yes/No column, choice or text column?

In the meantime, you might find this tutorial helpful: 5 Power Automate Troubleshooting FAQs and Helpful Tips for Creating Better Flows

In this Power Automate tutorial, I explore 5 frequently asked questions that pop up when troubleshooting a flow. If you’d like to to level up your Power Automate flow skills and learn how to troubleshoot your Power Automate flow—this tutorial is for you!

IN THIS VIDEO:

✅ How to troubleshoot a false Condition action result

✅ How to get dynamic content when it isn’t selectable from the list of dynamic content

✅ How to troubleshoot an Apply to Each action that isn’t looping through

✅ How to troubleshoot a skipped Apply to Each action

✅ How to troubleshoot a Filter Query

✅ How to use a SharePoint yes/no column in a Filter Query

✅ How to use Compose actions to troubleshoot a Power Automate flow

✅ How to troubleshoot multiple emails being sent

✅ How to troubleshoot multiple Teams messages being sent

Hope this helps!

If I helped you solve your problem—please mark my post as a solution ✅.
Consider giving me a 👍 if you liked my response!

👉 Level up your Power Automate skills by checking out my tutorials on YouTube
👉 Tips and Tricks on TikTok and Instagram

Was this reply helpful? Yes No
v-qiaqi@microsoft.com on at

Like (0)

Report

Hi @Tobias12,

Was this reply helpful? Yes No
Tobias12 18 on at

Like (0)

Report

Hi Qi,

thank you for your reply.
I have 4 questions, maybe you could answer them 🙂

1)
Regarding the common column:
I created a new column called "Original ID" in the second list where the values are based on the IDs of the first list.
Now, do I have to insert in the ID field the added column "Original ID" of the second list, or the ID column of the primary list? I tried to find the column "Original ID" there but I was not able to find it.

2) What role does the field "Profile Claims" play here?

3) When inserting in title the field "Title". How does the PowerAutomate Run know which column is to be updated here? Do the names of column have to match?

4) Also I would like to update multiple columns in one run. Is that also possible here?

Was this reply helpful? Yes No
Tobias12 18 on at

Like (0)

Report

Hey, it is a yes/no column.
Unfortunately, your video does not help me here 😞

Was this reply helpful? Yes No
creativeopinion 10,502 Super User 2025 Season 2 on at

Like (0)

Report

@Tobias12 To copy data from one SP List to another you need the SP ID of the item you want to update—which you have.

However, it's always best practice to filter out the items you want to update first. How are you filtering out the items you want to update? Is there a specific property (aka column) or properties that you want your items to have before you update them?

Was this reply helpful? Yes No