none
Use One Field to Update Another RRS feed

  • Question

  • I have 2 SharePoint Online lists.

    List #1 - Students

    • Field #1 - StateCode
    • eld #2 - StateName

    List #2 - States

    • Field #1 - Abbreviation
    • Field #2 - Description

    Scenario:

    1. A user in the list named Students changes the value of StateCode (or enters a new value for StateCode). For example, user enters NC.
    2. The flow finds the row in the list named States where Abbreviation is NC. The flow gets the value of Description in that row (e.g., North Carolina).
    3. The flow goes to the row that the user was editing in the list named Students. The user sets the value of StateName in that row to North Carolina.
    How would I accomplish this? I need to use O365 tools only (e.g., either Microsoft Flow and/or PowerApps). Thank you.

    Tuesday, April 9, 2019 1:23 AM

All replies

  • Hi @RobynneH33,

    Two possible solutions:

    1. (Easy) Make the StateCode a lookup field and include Description as an additional field

    2. (Harder) Flow follows this general logic:

    - Flow is triggered on change/create of Students list

    - Get all items from States list

    - Filter out the State item using the trigger info ( triggerBody()?[StateCode] )

    - Update Item with the filtered field

    Hope I understood your question and I hope this helps

    v/r,

    Bill

    Thursday, May 16, 2019 2:22 PM