web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Welcome to the Power Platform Communities
Season of Giving Solutions is Here!
Explore Copilot Studio Forums, Blogs & Galleries!
News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Generate Word Document...
Power Automate
Unanswered

Generate Word Documents Froms SharePoint Lists

(0) ShareShare
ReportReport
Posted on by Community Power Pla...

Hey, I've created a flow that transfer list items into a word documents.  I was able to transfer single line text but I couldn't transfer multi options! What do you think is the issue?

 

Here is the flow I'm using and it's transferring (Project Name, Reference No., and dept) because they are a text not options.

update properties1.PNG

 

And here the list items after filling the list form.

update properties2.PNG

 

image.png

 

 

And here is the word file after updating. It catches only the text inputs.

update properties3.PNG

 

 

 

 

 

 

Please let me know if you have been in this situation.

 

Categories:
Building flows
I have the same question (0)
  • Community Power Platform Member Profile Picture
    Community Power Pla... on at

    Hi @Jay-Encodian,

     

    My post was marked as a Spam. I guess because of the run history.

     

    So I updated the post. Please let me know.

  • Jay-Encodian Profile Picture
    Jay-Encodian 2,920 on at

    Hi @Anonymous 

    The reason the fields aren't appearing in Word will be down the column type... can you confirm which type of column the fields are that you cannot see? (Managed Metadata, choice, etc.)

    I can't give you the explicit method for adding the data to the 'Populate a Word template' action (assuming that is what you're using) without knowing the column type.... but if you want to see all of the data from the SharePoint action do this:

    1. In the expression field type: string()

    1.png

     2. Click 'Dynamic Data'

    2.png

    You should now see all of the SharePoint fields...

    HTH

    Jay

  • Community Power Platform Member Profile Picture
    Community Power Pla... on at

    Hi @Jay-Encodian ,

     

    I'm using Update file properties, not populate a word template as you see below:

    image.png

     

    Regarding the reason, here is where they got added into the document:

     

     

    {
 "@odata.etag": "\"5\"",
 "ItemInternalId": "12",
 "ID": 12,
 "Title": "Business Case Approval Sheet.docx",
 "Project_x0020_Name": "IRSP Towers",
 "Reference_x0020_No": "23421",
 "Dept": "DSA",
 "Permenant_x0020_Committee_x0020_Members": [
 {
 "@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",
 "Id": 0,
 "Value": "CEO"
 },
 {
 "@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",
 "Id": 1,
 "Value": "CSD Director"
 },
 {
 "@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",
 "Id": 2,
 "Value": "CSSO"
 },
 {
 "@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",
 "Id": 3,
 "Value": "CFO"
 },
 {
 "@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",
 "Id": 4,
 "Value": "GRC Director"
 },
 {
 "@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",
 "Id": 5,
 "Value": "SQE Director"
 }
 ],
 "Permenant_x0020_Committee_x0020_Members@odata.type": "#Collection(Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference)",
 "Permenant_x0020_Committee_x0020_Members#Id": [
 0,
 1,
 2,
 3,
 4,
 5
 ],
 "Permenant_x0020_Committee_x0020_Members#Id@odata.type": "#Collection(Int64)",
 "Additional_x0020_Permanent_x0020_Members_x0020_for_x0020_technical_x0020_projects": [
 {
 "@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",
 "Id": 0,
 "Value": "CTO"
 },
 {
 "@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",
 "Id": 1,
 "Value": "COO"
 }
 ],
 "Additional_x0020_Permanent_x0020_Members_x0020_for_x0020_technical_x0020_projects@odata.type": "#Collection(Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference)",
 "Additional_x0020_Permanent_x0020_Members_x0020_for_x0020_technical_x0020_projects#Id": [
 0,
 1
 ],
 "Additional_x0020_Permanent_x0020_Members_x0020_for_x0020_technical_x0020_projects#Id@odata.type": "#Collection(Int64)",
 "Variable_x0020_Members": [
 {
 "@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",
 "Id": 0,
 "Value": "<Business Owner>"
 },
 {
 "@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",
 "Id": 1,
 "Value": "<Technical Owner>"
 }
 ],
 "Variable_x0020_Members@odata.type": "#Collection(Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference)",
 "Variable_x0020_Members#Id": [
 0,
 1
 ],
 "Variable_x0020_Members#Id@odata.type": "#Collection(Int64)",
 "Modified": "2019-12-15T13:34:09Z",
 "Editor": {
 "@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser",
 "Claims": "i:0#.f|membership|mabalamri@sans.com.sa",
 "DisplayName": "Mohammed A. Alamri",
 "Email": "mabalamri@sans.com.sa",
 "Picture": "https://sansksa.sharepoint.com/sites/Elibrary/General Documents/_layouts/15/UserPhoto.aspx?Size=L&AccountName=mabalamri@sans.com.sa",
 "Department": "SED",
 "JobTitle": "Analyses"
 },
 "Editor#Claims": "i:0#.f|membership|mabalamri@sans.com.sa",
 "OData__dlc_DocId": "5A44CPU4C3JC-1838921421-12",
 "OData__dlc_DocIdUrl": "https://sansksa.sharepoint.com/sites/Elibrary/General Documents/_layouts/15/DocIdRedir.aspx?ID=5A44CPU4C3JC-1838921421-12",
 "Created": "2019-12-15T13:23:59Z",
 "Author": {
 "@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser",
 "Claims": "i:0#.f|membership|mabalamri@sans.com.sa",
 "DisplayName": "Mohammed A. Alamri",
 "Email": "mabalamri@sans.com.sa",
 "Picture": "https://sansksa.sharepoint.com/sites/Elibrary/General Documents/_layouts/15/UserPhoto.aspx?Size=L&AccountName=mabalamri@sans.com.sa",
 "Department": "SED",
 "JobTitle": "Analyses"
 },
 "Author#Claims": "i:0#.f|membership|mabalamri@sans.com.sa",
 "OData__DisplayName": "",
 "{Identifier}": "Business%2bCase%2bApproval%2bSheets%252fBusiness%2bCase%2bApproval%2bSheet.docx",
 "{IsFolder}": false,
 "{Thumbnail}": {
 "Large": "https://northeurope1-mediap.svc.ms/transform/thumbnail?provider=spo&inputFormat=docx&cs=fFNQTw&docid=https%3a%2f%2fsansksa.sharepoint.com%3a443%2f_api%2fv2.0%2fdrives%2fb!TruTC1J5u0mGOkCYREmCGHqqQAMzGlZAhlHzmcwdgSGT4GWlZqLkTaKpicNpRLVE%2fitems%2f013KXTNGWZ3FWZUS5TRRGLJHZ3B2RAQKI6%3fversion%3dPublished&access_token=eyJ0eXAiOiJKV1QiLCJhbGciOiJub25lIn0.eyJhdWQiOiIwMDAwMDAwMy0wMDAwLTBmZjEtY2UwMC0wMDAwMDAwMDAwMDAvc2Fuc2tzYS5zaGFyZXBvaW50LmNvbUAwNDJiMzllZC0xNzBjLTQzNjItODY5OS0xYTAxNTAxYjMzYzkiLCJpc3MiOiIwMDAwMDAwMy0wMDAwLTBmZjEtY2UwMC0wMDAwMDAwMDAwMDAiLCJuYmYiOiIxNTc2NDE2ODQ5IiwiZXhwIjoiMTU3NjQzODQ0OSIsImVuZHBvaW50dXJsIjoiMXg5TDUzZ3hiZm9DM1MyaWRXUk1HUklrS3pQZkpyOWM4K2FxVjFWT3pVVT0iLCJlbmRwb2ludHVybExlbmd0aCI6IjExNCIsImlzbG9vcGJhY2siOiJUcnVlIiwiY2lkIjoiT0RrelpXWTFNemd0T0dZek5DMDBNMlExTFRnM1pESXRNemN3TVRVd1pXRmxNR1EwIiwidmVyIjoiaGFzaGVkcHJvb2Z0b2tlbiIsInNpdGVpZCI6Ik1HSTVNMkppTkdVdE56azFNaTAwT1dKaUxUZzJNMkV0TkRBNU9EUTBORGs0TWpFNCIsImFwcF9kaXNwbGF5bmFtZSI6IkFwcCBTZXJ2aWNlIiwiZ2l2ZW5fbmFtZSI6Ik1vaGFtbWVkIiwiZmFtaWx5X25hbWUiOiJBbGFtcmkiLCJuYW1laWQiOiIwIy5mfG1lbWJlcnNoaXB8bWFiYWxhbXJpQHNhbnMuY29tLnNhIiwibmlpIjoibWljcm9zb2Z0LnNoYXJlcG9pbnQiLCJpc3VzZXIiOiJ0cnVlIiwiY2FjaGVrZXkiOiIwaC5mfG1lbWJlcnNoaXB8MTAwMzIwMDA3ZWM3Yzg5YkBsaXZlLmNvbSIsInNoYXJpbmdpZCI6IjMxMmQ4MjM4LTQ0MmQtNDE5NC1hZWQ4LWMwMWZkODJmMDRkOSIsInR0IjoiMCIsInVzZVBlcnNpc3RlbnRDb29raWUiOm51bGx9.Z2hidlhvTjk1cFRkRldjTnR3akxjQVhRYkNzMUxhaVBwUENDekVobXgxYz0&width=800&height=800",
 "Medium": "https://northeurope1-mediap.svc.ms/transform/thumbnail?provider=spo&inputFormat=docx&cs=fFNQTw&docid=https%3a%2f%2fsansksa.sharepoint.com%3a443%2f_api%2fv2.0%2fdrives%2fb!TruTC1J5u0mGOkCYREmCGHqqQAMzGlZAhlHzmcwdgSGT4GWlZqLkTaKpicNpRLVE%2fitems%2f013KXTNGWZ3FWZUS5TRRGLJHZ3B2RAQKI6%3fversion%3dPublished&access_token=eyJ0eXAiOiJKV1QiLCJhbGciOiJub25lIn0.eyJhdWQiOiIwMDAwMDAwMy0wMDAwLTBmZjEtY2UwMC0wMDAwMDAwMDAwMDAvc2Fuc2tzYS5zaGFyZXBvaW50LmNvbUAwNDJiMzllZC0xNzBjLTQzNjItODY5OS0xYTAxNTAxYjMzYzkiLCJpc3MiOiIwMDAwMDAwMy0wMDAwLTBmZjEtY2UwMC0wMDAwMDAwMDAwMDAiLCJuYmYiOiIxNTc2NDE2ODQ5IiwiZXhwIjoiMTU3NjQzODQ0OSIsImVuZHBvaW50dXJsIjoiMXg5TDUzZ3hiZm9DM1MyaWRXUk1HUklrS3pQZkpyOWM4K2FxVjFWT3pVVT0iLCJlbmRwb2ludHVybExlbmd0aCI6IjExNCIsImlzbG9vcGJhY2siOiJUcnVlIiwiY2lkIjoiT0RrelpXWTFNemd0T0dZek5DMDBNMlExTFRnM1pESXRNemN3TVRVd1pXRmxNR1EwIiwidmVyIjoiaGFzaGVkcHJvb2Z0b2tlbiIsInNpdGVpZCI6Ik1HSTVNMkppTkdVdE56azFNaTAwT1dKaUxUZzJNMkV0TkRBNU9EUTBORGs0TWpFNCIsImFwcF9kaXNwbGF5bmFtZSI6IkFwcCBTZXJ2aWNlIiwiZ2l2ZW5fbmFtZSI6Ik1vaGFtbWVkIiwiZmFtaWx5X25hbWUiOiJBbGFtcmkiLCJuYW1laWQiOiIwIy5mfG1lbWJlcnNoaXB8bWFiYWxhbXJpQHNhbnMuY29tLnNhIiwibmlpIjoibWljcm9zb2Z0LnNoYXJlcG9pbnQiLCJpc3VzZXIiOiJ0cnVlIiwiY2FjaGVrZXkiOiIwaC5mfG1lbWJlcnNoaXB8MTAwMzIwMDA3ZWM3Yzg5YkBsaXZlLmNvbSIsInNoYXJpbmdpZCI6IjMxMmQ4MjM4LTQ0MmQtNDE5NC1hZWQ4LWMwMWZkODJmMDRkOSIsInR0IjoiMCIsInVzZVBlcnNpc3RlbnRDb29raWUiOm51bGx9.Z2hidlhvTjk1cFRkRldjTnR3akxjQVhRYkNzMUxhaVBwUENDekVobXgxYz0&width=176&height=176",
 "Small": "https://northeurope1-mediap.svc.ms/transform/thumbnail?provider=spo&inputFormat=docx&cs=fFNQTw&docid=https%3a%2f%2fsansksa.sharepoint.com%3a443%2f_api%2fv2.0%2fdrives%2fb!TruTC1J5u0mGOkCYREmCGHqqQAMzGlZAhlHzmcwdgSGT4GWlZqLkTaKpicNpRLVE%2fitems%2f013KXTNGWZ3FWZUS5TRRGLJHZ3B2RAQKI6%3fversion%3dPublished&access_token=eyJ0eXAiOiJKV1QiLCJhbGciOiJub25lIn0.eyJhdWQiOiIwMDAwMDAwMy0wMDAwLTBmZjEtY2UwMC0wMDAwMDAwMDAwMDAvc2Fuc2tzYS5zaGFyZXBvaW50LmNvbUAwNDJiMzllZC0xNzBjLTQzNjItODY5OS0xYTAxNTAxYjMzYzkiLCJpc3MiOiIwMDAwMDAwMy0wMDAwLTBmZjEtY2UwMC0wMDAwMDAwMDAwMDAiLCJuYmYiOiIxNTc2NDE2ODQ5IiwiZXhwIjoiMTU3NjQzODQ0OSIsImVuZHBvaW50dXJsIjoiMXg5TDUzZ3hiZm9DM1MyaWRXUk1HUklrS3pQZkpyOWM4K2FxVjFWT3pVVT0iLCJlbmRwb2ludHVybExlbmd0aCI6IjExNCIsImlzbG9vcGJhY2siOiJUcnVlIiwiY2lkIjoiT0RrelpXWTFNemd0T0dZek5DMDBNMlExTFRnM1pESXRNemN3TVRVd1pXRmxNR1EwIiwidmVyIjoiaGFzaGVkcHJvb2Z0b2tlbiIsInNpdGVpZCI6Ik1HSTVNMkppTkdVdE56azFNaTAwT1dKaUxUZzJNMkV0TkRBNU9EUTBORGs0TWpFNCIsImFwcF9kaXNwbGF5bmFtZSI6IkFwcCBTZXJ2aWNlIiwiZ2l2ZW5fbmFtZSI6Ik1vaGFtbWVkIiwiZmFtaWx5X25hbWUiOiJBbGFtcmkiLCJuYW1laWQiOiIwIy5mfG1lbWJlcnNoaXB8bWFiYWxhbXJpQHNhbnMuY29tLnNhIiwibmlpIjoibWljcm9zb2Z0LnNoYXJlcG9pbnQiLCJpc3VzZXIiOiJ0cnVlIiwiY2FjaGVrZXkiOiIwaC5mfG1lbWJlcnNoaXB8MTAwMzIwMDA3ZWM3Yzg5YkBsaXZlLmNvbSIsInNoYXJpbmdpZCI6IjMxMmQ4MjM4LTQ0MmQtNDE5NC1hZWQ4LWMwMWZkODJmMDRkOSIsInR0IjoiMCIsInVzZVBlcnNpc3RlbnRDb29raWUiOm51bGx9.Z2hidlhvTjk1cFRkRldjTnR3akxjQVhRYkNzMUxhaVBwUENDekVobXgxYz0&width=96&height=96"
 },
 "{Link}": "https://sansksa.sharepoint.com/sites/Elibrary/General%20Documents/Business%20Case%20Approval%20Sheets/Business%20Case%20Approval%20Sheet.docx?d=w9a6dd9d9b34b4c8cb49f3b0ea208291e",
 "{Name}": "Business Case Approval Sheet",
 "{FilenameWithExtension}": "Business Case Approval Sheet.docx",
 "{Path}": "Business Case Approval Sheets/",
 "{ContentType}": {
 "@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedContentType",
 "Id": "0x010100C93A16F808DF5D4681CE5D2025B0FED500AACFDEC68D7E6C48AD2A4AD3C5F525A6",
 "Name": "BC Approval Sheet"
 },
 "{ContentType}#Id": "0x010100C93A16F808DF5D4681CE5D2025B0FED500AACFDEC68D7E6C48AD2A4AD3C5F525A6",
 "{IsCheckedOut}": false,
 "{VersionNumber}": "5.0"
}

     

    image.png

  • Jay-Encodian Profile Picture
    Jay-Encodian 2,920 on at

    ok @Anonymous 

    Re-looking at your flow... you're not using the 'Populate a word template; your updating the metadata of the document library and using quick parts to display the data...

    Quick parts don't support all of the column types... so what you may need to do is change the column which you want to map to a quick part to a text column... then in your 'Update File Properties' you'll need to make sure the data is formatted as a string using the 'string()' expression before adding.

    HTH

    Jay

  • Community Power Platform Member Profile Picture
    Community Power Pla... on at

    Hi@Jay-Encodian,

     

    If I change the column type in library, I should also change it in the site and the content type too. And this would kill the idea of the multi options. I hope there is a way that helps with using multiple choices instead of only Text.

  • Verified answer
    Jay-Encodian Profile Picture
    Jay-Encodian 2,920 on at

    Hi @Anonymous 

    I don't think you need to do that... the issue is mapping the data.

    So lets say you have a multi choice column called 'Countries'... add another column called 'Countries - Text' which is a text value.

    In your 'Flow' get the data from choice column, loop through the entries to create a string containing the entries and the write that into the 'Countries - Text' column which is then mapped to the documents quick part.

    Here is a quick example of how to get the data from a choice column and map to a comma delimited list:

    1.png

     

    This will produce:

    1.png

     

    From:

    2.png

     

    Obviously you'll write the data into the SharePoint list column where I sent it in an email.

    HTH

    Jay

  • Community Power Platform Member Profile Picture
    Community Power Pla... on at

    @Jay-EncodianSorry I was out of work. I will try it and let you know. Thank you

  • Community Power Platform Member Profile Picture
    Community Power Pla... on at

    Your solution is working @Jay-Encodian,

     

    I just tested it and it worked perfectly!!

     

    These are the steps I followed as you taught me earlier

     

    100.PNG101.PNG102.PNG

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Welcome to the Power Platform Communities
Season of Giving Solutions is Here!
Explore Copilot Studio Forums, Blogs & Galleries!

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 522 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 364 Moderator

#3
abm abm Profile Picture

abm abm 243 Most Valuable Professional

Last 30 days Overall leaderboard

Featured topics

Share your ideas and struggles with building Power Automate flows!
Survey: Power Automate mobile app
How to Ask for Help with Your Power Automate Workflow
Flows are not visible for users who sign in with their personal accounts
Start and wait for an approval action
Restore a deleted flow
List of actions cheat sheet for Power Automate Desktop
Question for everyone : How are you using Create Text GPT in AI Builder?
Welcome to the Power Automate forum!

Product updates

Microsoft Power Platform Community release plans