How to update a Sharepoint list when it has a Vlookup column

(1) Share

Report

Posted on by Ange Lyons

Hi Everyone

Using Power AutoMate i am hoping you can help with the following.

I am trying to update a SharePoint list that is a Vlookup Column from a selection in microsoft forms

I have created a form and one of the fields has a drop down, i want what is selected from the drop down in forms to populate the SharePoint list which is the vlookup column, not sure if this is possible.

Currently my flow is as follows (it does say the flow is succeeded but SharePoint list is not populating)

When a new response is submitted

Get response details
initialize variable
apply to each
condition
if yes update item.

@efialttes

The Title in my drop down in forms is "Select your unit Code" the vlookup column in Sharepoint is " UnitCode"

Any help would be appreciated.

Thank you

Categories:

Business Process Flows

Power AutoMate.png

All responses (1)

Answers (0)

efialttes 14,756 on at

Like (1)

Report

How to update a Sharepoint list when it has a Vlookup column

Hi @Ange_Lyons !

What's the title of your drop-down question in Microsoft Forms? Is it "Select the quality...", the one you added in the 'Initializa variable' action block?
If so, what type of colum is 'Qualification code' in your SP list? Is it of type lookup column, or choice column?

The more information context you provide, the faster you will get a useful response
Thanx!