Share
Report
201Hi @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:
| PersonalID | Name |
| 10 | Name10 |
| ... | ... |
User-SP-List (List for Lookup):
| PersonalID | Name | ID |
| 10 | Name10 | 1 |
| 11 | Name11 | 2 |
| ... | ... | ... |
| 19 | Name19 | 10 |
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):
| PersonalID | Name | PersonalID(Lookup) | Name(LookUp) |
| 10 | Name10 | 19 | Name19 |
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?
All responses (
Answers (
