Unanswered

Checking against LOOKUP column and adding in a new item

(0) Share

Report

Posted on by Frashe

Hi Microsoft Community,

I have a 'LOOKUP' column which is against the 'Title' (Single line of text) column. In this column, I have many different IDs which I need my automation to check if 'ID' is existing, then add a NEW ID into the LOOKUP column.

I am having difficulty because I dont know how to add into the Array/JSON, how can I do this?

Deeply appreciated.

Categories:

General topics

I have the same question (0)

All responses (2)

Answers (0)

Michael E. Gernaey 53,928 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi @Frashe

Sorry read it wrong, but atm I dont quite follow. I am guessing this is SharePoint, and it are you using some Concated string? and Concated by what?

If I have helped you, I would really appreciate if you please Mark my answer as Resolved/Answered, and give it a thumbs up, so it can help others

Cheers

Thank You
Michael Gernaey MCT | MCSE | MCP | Self-Contractor| Ex-Microsoft
https://gernaeysoftware.com
LinkedIn: https://www.linkedin.com/in/michaelgernaey

Was this reply helpful? Yes No
Frashe 22 on at

Like (0)

Report
Copy link

Link copied!

Hi @Michael , apologies, let me try to paint a clearer picture.

I have a SharePoint list 'A' which contains my programme codes, and title.
I have a SharePoint list 'B', which has a 'LOOKUP' SharePoint column pulling from SharePoint list 'A'. So for an item in SharePoint list 'B', it can contain many programme codes.

I wish to create an automation which will check with programme code X is present in SharePoint list B item, then it will help to add another value. I am having difficulties, trying to add a new item under an array item under the SharePoint 'LOOKUP' column. Below, I am trying to add the new programme code into my array, then try to Update Item of that particular row.

Thank you!

Was this reply helpful? Yes No