Hi @spencerham,
Would you like to fill in & overwrite the User column or append to it (e.g. User1; User2; User3)?
Option 1 would include a Patch and 2 LookUp functions:
Patch(
'Tool Data',
LookUp(
'Tool Data',
//If Tool ID is a text field, remove the Value() function
//Change TextInputToolID to the correct name
'Tool ID' = Value(TextInputToolID.Text)
),
{
User: LookUp(
'User Data',
//If Badge ID is a text field, remove the Value() function
//Change TextInputBadgeID to the correct name
'Badge ID' = Value(TextInputBadgeID.Text)
).Name
}
)
Option 2 would involve a small adjustment in order to append & not overwrite the value:
With(
{
lookUpRecord: LookUp(
'Tool Data',
//If Tool ID is a text field, remove the Value() function
//Change TextInputToolID to the correct name
'Tool ID' = Value(TextInputToolID.Text)
)
},
Patch(
'Tool Data',
lookUpRecord,
{
Title: lookUpRecord.User & "; " & LookUp(
'User Data',
//If Badge ID is a text field, remove the Value() function
//Change TextInputBadgeID to the correct name
'Badge ID' = Value(TextInputBadgeID.Text)
).Name
}
)
)
Adjust the code / names where necessary.
If this solves your question, would you be so kind as to accept it as a solution.
Thanks!
