Forum Discussion
Using Flow to copy SP list items to another list fails to copy Yes/No values. RESOLVED
A quick easy solution to achieve this is as follows:
1. In SharePoint, Create new list from another SharePoint list
2. Open New List and Navigate to List Settings (Cog) at top right of page.
3. Note down each "Yes/No" column name so any changes to column types you know which ones to change back if required.
4. Change all the YES/NO column types in new list to single line of text (Column Type). Save
5. Go back to your Flow and to the "Get Items" option and re-connect Dynamic values for all Yes/No options and link each one to the appropriate "Yes/No" field in the Dynamic lookup "Get Items" list. As you see below, I changed the "Yes/No" fields from "NO" to each ones own dynamic lookup field name.
The SharePoint (Get Items) option in Flow should now populate the new list columns as below: (Column Names Hidden for privacy reasons.)
You could take it further in the flow and prevent duplicates copying and many other options.
IMPORTANT: Don't forget that if you intend using the new list with an app or same app, you will need to change the column types back from "single line of text" back to "YES/NO" column type.
Hope that helps someone as I have seen other more complicated methods.
A quick easy solution to achieve this is as follows:
1. In SharePoint, Create new list from another SharePoint list
2. Open New List and Navigate to List Settings (Cog) at top right of page.
3. Note down each "Yes/No" column name so any changes to column types you know which ones to change back if required.
4. Change all the YES/NO column types in new list to single line of text (Column Type). Save
5. Go back to your Flow and to the "Get Items" option and re-connect Dynamic values for all Yes/No options and link each one to the appropriate "Yes/No" field in the Dynamic lookup "Get Items" list. As you see below, I changed the "Yes/No" fields from "NO" to each ones own dynamic lookup field name.
The SharePoint (Get Items) option in Flow should now populate the new list columns as below: (Column Names Hidden for privacy reasons.)
You could take it further in the flow and prevent duplicates copying and many other options.
IMPORTANT: Don't forget that if you intend using the new list with an app or same app, you will need to change the column types back from "single line of text" back to "YES/NO" column type.
Hope that helps someone as I have seen other more complicated methods.
