New answers tagged

0

Formate the lookup field as following(remember to change the source list for yourself): { "$schema": "https://developer.microsoft.com/json-schemas/sp/v1/column-formatting.schema.json", "elmType": "a", "txtContent": "@currentField.lookupValue", "attributes": { "href&...


0

Use below code to update lookup column with multiple selection: <script src="https://code.jquery.com/jquery-1.11.1.min.js" type="text/javascript"></script> <script type="text/javascript"> $(document).ready(function(){ $.ajax({ url: _spPageContextInfo.webAbsoluteUrl + "/_api/web/...


0

You can make API calls via the "Call HTTP Web Service" action available in SharePoint 2013 workflows. More information can be found here: Working with Web Services in SharePoint Workflows using SharePoint Designer 2013


0

Not sure how to make the API call in SP Designer (it's a hassle!) but your data should be something like this: 'ColumnNameId': {"results": [59, 60] } Note that you need to add 'Id' to the column name. The results object contains an array of the IDs of the lookup items.


3

I made a simple demo for you. First this is the list Entidades: Then create the list Diario: Then create a lookup column Entidade_FK, make sure Get information form Entidade, the selected column is Entidade_ID and check the Nome: At last: If you don't want to display the column Entidade_FK, you can choose to hide it, just go to List Settings>View>...


0

According to my understanding of the SharePoint list, it is not the same as the database table, there is no concept of primary key, foreign key in SharePoint.SharePoint is one of the leading portal technologies, not a relational database. The lookup column can only select the value from the source list column's value. This is similar to the foreign key, but ...


1

When you want to use a lookup column in SharePoint, you don't need to build a lookup key manually. SharePoint takes care of that. You just select which list you want to use as the source for the lookup column and which column of that list should be used for the visible data drop-down. SharePoint then takes care of the lookup architecture and internally uses ...


1

Yes, you can use lookup columns in SharePoint Online. You can find all the information in below Microsoft documentation: Create list relationships by using unique and lookup columns Note that all colum types are not supported to use as a lookup column, you can find list of all supported and unsupported column types in above documentation.


0

i have successfull doing this: 1 - Add list b as datasource 2 - Do the filteer by ID Filter(Choices([@Divisao].Diretoria);Id in Filter(Diretoria;Empresa.Id=DataCardValue9.Selected.Id).ID) (in pt-br we use ';' and not ',')


2

Try the following formula: DataCardValue3.Items = Filter(Choices([@ListA].Diretoria),Value in Filter(ListB,DataCardValue2.Selected.Value=Empresa).Title) DataCardValue2 is the data card for the Choice column Empresa. DataCardValue3 is the data card for the Lookup column Diretoria


0

if you switch from using workflows to deploy your lists to for example PnP PowerShell you should be able to keep a central template using PnP Templates. That should be able to maintain your lookups and update fields accordingly. if that's not enough you can even write c# code using Extensibility Providers if for whatever reason you have to keep workflows, ...


Top 50 recent answers are included