SharePoint List "Lookup" columns not available in Get Items in Flow
I have seen this discussion before (see https://jgvjg48436.lithium.com/t5/General-Power-Automate/Missing-Columns-from-SharePoint-List-in-Flow/td-p/239360) but suggested solutions have not resolved my issue. So, I am looking for some more guidance or suggestions. I have a SharePoint list with a Look-up column. Using Get Items in a cloud flow this field does not display. Setup SharePoint List called "ARB Meetings" SharePoint List called "Decision Register", this has a lookup column to the ARB Meetings list. Get Item Note, I have tried using Limit columns by View and created a new view including the required lookup column, without success. In the Decision Register SharePoint List, there are some items where the ARB Meetings column is blank, I don't know if this could cause an issue? Co-Pilot Help I have asked Co-Pilot for help, which gave me plently of good options I have tried the following without success: If your lookup column is not showing in the Get items action in Power Automate, here are a few steps you can try to resolve the issue: Check List Views: Ensure that the lookup column is included in the default view of your SharePoint list. Sometimes, columns not included in the view might not appear in Power Automatehttps://jgvjg48436.lithium.com/t5/Building-Flows/Get-items-not-showing-lookup-column/td-p/859264. Refresh the Flow: After adding the lookup column to your list, refresh your Power Automate flow. You might need to close and reopen the flow designer to see the updated columnshttps://jgvjg48436.lithium.com/t5/General-Power-Automate/Missing-Columns-from-SharePoint-List-in-Flow/td-p/239360. Limit Columns by View: In the Get items action, use the Limit columns by view option to select a view that includes the lookup column. This can help ensure that the column is retrievedhttps://jgvjg48436.lithium.com/t5/General-Power-Automate/Missing-Columns-from-SharePoint-List-in-Flow/td-p/239360. Check Column Settings: Verify that the lookup column is properly configured in SharePoint. Ensure it is not hidden or restricted in any wayhttps://jgvjg48436.lithium.com/t5/Building-Flows/Get-items-not-showing-lookup-column/td-p/859264. Pagination Settings: If your list has a large number of items, enable pagination in the Get items action settings. This can help retrieve all items, including those with lookup columnshttps://learn.microsoft.com/en-us/sharepoint/dev/business-apps/power-automate/guidance/working-with-get-items-and-get-files. If these steps don't resolve the issue, you might want to try creating a new flow from scratch to see if the lookup column appears. Sometimes, starting fresh can help Power Automate recognize new or updated columns. Let me know if you need further assistance or if there's anything else I can help with! References [1] https://jgvjg48436.lithium.com/t5/Building-Flows/Get-items-not-showing-lookup-column/td-p/859264 [2] https://jgvjg48436.lithium.com/t5/General-Power-Automate/Missing-Columns-from-SharePoint-List-in-Flow/td-p/239360 [3] https://learn.microsoft.com/en-us/sharepoint/dev/business-apps/power-automate/guidance/working-with-get-items-and-get-files Thank-you, Irene
Custom Formatter for Read-Only Fields conditional based on other columns
Hello! Does anyone know if it's possible with the fieldsettings, readonly formatting, to make it conditional based on a Person field? It's a multi people field if that makes a difference? I ideally want to make certain fields read only based on who is viewing it (without having to use a Power App customised form!). This is what I want (but I know the syntax is likely all wrong!) but not sure if it's possible to use an IF statement with boolean statements? { "sections": [ {} ], "fieldsettings": [ { "name": "Comments", "readonly": "=if([$People.email] == me, false, true)" } ] }
ID Calculated Column Not Showing
I have created a calculated column to show the ID in an opened List item. This is using =ID in the formula box. However, in the actual List item, the vasty majority are showing ID as 0: There does not seem to be a pattern for this, Does anyone have an explanation for this?MS List Column Width Forced
Hi, I've had a number of MS lists and been able to enter grid view and amend the width of columns and the text doesn't overflow which I want to keep the overall list width smaller; but as of yesterday all my columns are forced to be as wide as the text, meaning the that 1 column can be multiple screens wide for multi-line columns and they can't be resized smaller Is this a bug? Any help appreciated.
Create reference number in SharePoint lists with each new entry
Migrating an Excel table into SP lists, so I can existing reference numbering system, so with each new entry I need this to increase by one. Let's say the current ref number is R5687 how to I ensure that subsequent entries are allocated a reference number, which is one more last the last
MS List - View a list of columns, including internal column name and column alias
I'm trying to make sense of column names in MS Lists. It seems like columns can have both an internal/system name and an alias. For example, my Title column (internal/system name) is displayed as a custom "Asset ID" column in the Microsoft Lists app. Is there a way to view a list of all column names, and the list would show both the internal/system column name and the column alias? Like this:Ultimate Polling and Quiz Experience with Polls app: The Replacement for Forms app in Teams meeting
Initially Forms app was launched in Teams - for different experiences based on the sync vs async user scenarios, as it points to polling experience in meetings for quick creation to launch, while it points to survey experience in the context of Teams channel.To provide an intuitive and easy-to-access experience , Polls app was launched - a dedicated app for all your polling and quiz needs in Teams meeting and chat. We are glad to see that hosting an effective and interactive meeting just got easier after the launch of Polls.Import picklist values for SharePoint List choice field
I have a column in a SharePoint List that uses the choice field type. I'm able to manually enter each choice value by copying/pasting text from an Excel spreadsheet. Is there a way to import a long list of values directly into SharePoint to save time?
