cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
dobroo
Advocate II
Advocate II

Lookup Column update Value

Hi @ALL,

 

I need help with this flow (automate):

I have an Excel-Spreadsheet with a column called "personalID" and in the SP-List a column called "personalID" (text-column) and a lookup-column "personalID (Lookup)" (the list linked is called User).

 

Excel-Spreadsheet:

PersonalIDName
10Name10
......

 

User-SP-List (List for Lookup):

PersonalIDNameID
10Name101
11Name112
.........
19Name1910

 

 

Bildschirmfoto 2021-01-01 um 20.30.14.png

The Flow will create items in the SP-List. I have the following issue:

The value in the Excel-Spreadsheet is 10.

 

When I start the flow, the flow creates an SP-item like this:

 

SP-List (data from flow):

PersonalIDName
PersonalID(Lookup)Name(LookUp)
10Name1019Name19

 

If I set the dynamic content with PersonalID(Excel-object) the flow creates the value 19 not 10!!!

 

If I set the value manually to 10 the flow creates the value correct to 10.

 

Which formula do I have to enter in the lookup-column so that the correct variable is used for this column?

 

0 REPLIES 0

Helpful resources

Announcements
MPA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

secondImage

Are Your Ready?

Test your skills now with the Cloud Skill Challenge.

Top Solution Authors
Users online (36,002)