New answers tagged

1

For now, SharePoint Online list validation does not support lookup column. If you need that, You may need to use Power Apps. You can start from here: https://techwizard.cloud/2020/02/08/powerapps-sharepoint-online-list-field-validation/


0

Items list showing ItemTitle and ItemCategory Create a Lookup Column (ItemOrdered) in Invoice list pointing to Items list showing ItemTitle and ItemCategory in Invoice list Invoice List Showing ItemTitle and ItemCategory


1

Lookup column does not have a transfer inheritance relationship. You could merge ItemCategory list and Item list.


0

In fact you can easily find many examples. Here are some scripts for your reference: https://www.sharepointdiary.com/2017/03/sharepoint-online-powershell-to-update-lookup-field.html#:~:text=PnP%20PowerShell%20to%20Set%20Lookup,of%20the%20parent%20lookup%20item. https://social.msdn.microsoft.com/Forums/en-US/ef8e8806-6d03-40e6-be4c-f98b89974941/how-do-i-set-...


0

Tried to figure our where to add these without creating another Answer. I don't see the 'Active' Status automatically updating on the Member Training List. Though it is updating on the Member List, and the flow says the run 'succeeded'


0

I got my accounts crossed. Posted a response to you comment as another questions. Your suggestion worked. However, the Update item in the flow is forcing (as a "required" field; not my choice), for some reason; I'm not even using in in my work. This is forcing the Update to update the wrong items because the SP Id no's are not the same for each ...


0

The way I would handle that is not by having a lookup back to the Members list, but by creating a Flow (Power Automate) that kicks off when items in the Members list are updated, and then finds the item in the Members Training list that corresponds to the "member" that just got updated (via a unique ID, if you have that, or maybe by member name, or ...


0

Whether this issue occurs in the classic experience or modern experience? What is the type of the column in the list? You could re-create a lookup column, compare the result.


Top 50 recent answers are included