Forum Discussion
SharePoint List Flow - Displaying Unique ID
In your Flow, when you're pulling data from the SharePoint list, add a https://learn.microsoft.com/en-us/power-automate/data-operations action right after getting your list item. This will help format the text before it goes into your document.
For a single line of text field, use this expression:
body('Get_item')?['TextFieldName']
For a multiple lines of text field, use this expression:
body('Get_item')?['MultiLineFieldName']
For a number field, use this expression:
body('Get_item')?['NumberFieldName']
For a date/time field, use this expression:
body('Get_item')?['DateFieldName']
Place this Compose action between your "Get Item" and your "Create Word Document" steps. Then, when you're setting up your Word document template, use the output from the Compose action instead of directly using the SharePoint field.
This gives you just the clean text without all the extra SharePoint ID information that usually comes with it. The Compose action basically acts as a filter, stripping away everything except the text you actually want to see in your document.
Apologies for the late response, I am new to Power Automate and one of the Sharepoint list that I have has multiple columns, and some of those column has different columns inside of them. When I try to reference the body('Get_items')?['MultiLineFieldName'] with the name of the main column it just returns the body('Get_items')?['MultiLineFieldName'] in the Word Document. I have been trying to research this issue while working with your suggestion. I have tried using a Parse JSON to filter out as well. My flow is manually triggered by a button, Maybe I am doing something wrong here
Any help is appreciated.