How to Create a Table in Microsoft Dataverse
Microsoft Dataverse, formerly known as Common Data Service (CDS), is a cloud-based data storage and management platform provided by Microsoft as part of its Power Platform. It allows users to securely store and manage data from various sources, such as Dynamics 365, Office 365, Power Apps, and Power Automate, and use that data to build custom business applications.Needing help (workaround) with Lookup Column value showing read-only on SharePoint Mobile
Hello, I am having issues with SharePoint Online Mobile App not showing the value of a Lookup field. Property managers are always out in the field, and they need property addresses to display on their mobile devices. I created a Site Column that is a Lookup field to have a master list of properties, to keep one source of "truth", so I only have to make changes to property additions/subtractions in one place, allowing the change to ripple throughout SharePoint. The issue that I run into is the mobile app shows "Read Only" for the property address on the mobile app, and doesn't show the actual property address. I do NOT want to have to update a dozen lists each time properties change, so I am asking for some assistance on how to overcome this challenge. I know JSON can achieve this by taking the Lookup value, and applying it to a text field, but I do not know JSON to this point. It is also a little clunky to have to add so many additional fields when the data is already in the custom list, but not showing on the mobile app. Does anyone have a workaround for this issue? Thank you in advance! This was my first post on this community thread. Kind Regards, Chris
Can we use VLookup to fill in fields from Scattered Data ?
Hi, I wanted to know that is it possible to use VLookup to fill in data in a certain row by matching it from different rows rather than just from a single row. In the attached image, I want to fill in the cells next to "Yellow" i.e. (H4) & "Pink" i.e. (H7) by using the same formula I used to in H2 cell which is "=VLOOKUP(G2:G7,A2:E12,2,0) ". NOTE - That I have selected the table array from "A2:E12" which covers the values of D11, E11 & D12, E12 in which the "Yellow" and "Pink" information is given. I do realise that the source has become different now, but is there a way in which I can fill in H4 & H7 through ANY FORMULA (if Vlookup can't be used) where I don't have to restructure the data in the sheet. Thank You in advance.Is this a bug? Look up column to External List error - SP2016
Hello folks - I am trying to find out if this is a bug with the product, or an issue with my farm. So, I wanted to reach out to the community to get help on something tested. (SharePoint 2016) Please consider this scenario. I've this tested on both on-premise farms and results are same. Prerequisites: Make sure to have a BCS External Content Type to a SQL database of your choice Make sure to create an External List using this ECT to the said SQL database Steps: Browse to Site Columns on a site collection (Same site collection that external list is on) Create a new site column, select type Lookup - Give a good name that you can remember Select "Get information from: " drop down to the External List you've already created, and select a column Hit "OK" Questions: Do you get an error? If you browse back to Site Columns do you see the column actually created but type is listed as "External Data" ? Please let me know your findings here. Thanks! Ali
SharePoint List lookup Column not Available in Power Automate
I have a SharePoint List Lookup Column, however when I go to make a flow to export/share the data from the SharePoint list, the lookup column values do not appear. Does anyone know a way to use flow to export data from a SharePoint list lookup column to somewhere like excel or another SharePoint? Thanks!
Hiding Lookup Column Values
Hello, I'm using a lookup column that displays dates in MM/dd/yyyy format from another SPO list. In my SPO form this lookup works well as a drop down for date selection. How can I hide values/dates in this lookup column/dropdown that have passed without deleting them? Is there a formula I can use to achieve this?Modern experience Filters pane for Multivalued Lookup column misbehaving
We have an Online (M365) SharePoint, Modern experience, hosting a Document Library “DocLib”, with a [Countries] multivalued lookup column targeting column [Country] in a “Countries” List. This List also contains a [Region] column which relates any country to a specific region, and this column is imported in “DocLib” resulting in another column, [Countries:Region]. As [Countries] is multivalued, [Countries:Region] appears to be multivalued as well. But filtering, using the standard Filters pane behaves strangely on [Countries:Region]. We expected to be able to filter on any individual region a document can be relating to (through the countries the document is relating to). However, here is what we get: Instead of individual [Region] values, we get, in the Filters pane, individual “Sets of Regions” resulting from all regions related to all countries in [Countries] but there is more… Selecting individual Regions, work just as expected. In the picture you see Regions “Middle-East” and “Africa” selected and on the left, you can see that any document with at least one country belonging to these regions are displayed On the other hand selecting “Middle-East; Middle-East” in the Filters pane, which results from relating a document to both Oman and Saudi Arabia in my exemple, gives no result at all My expectation would be – Having in the [Countries:Region] Filters pane any individual distinct regions linked to the countries the documents in the view are relating to THIS IS NOT WORKING Also, No "combinations of regions" should appear in the pane, they do not work anyway Selecting the regions in the Filters pane would keep the documents that relates at least one of these selected regions - THIS IS WORKING JUST FINE Except that not all regions are displayed if not appearing individually and alone on any of the document of the view! Is this a bug? Did I miss something?
