Hello, Expert need some help, I have a SharePoint list (called A) which is connected to a power app. When a new Item is added to the list I would like to check the existing value from one of the text box called DataCardValue7 and if the value is present in another SharePoint List (called B). If yes then I need to change the value to "Match Found"
This is what I have so far, not sure if this is correct.
If(LookUp('B','Title'=DataCardValue7.Text, true),DataCardValue7.Text='Match Found');SubmitForm(SharePointForm1)
Also, the text in red is being rejected as an error.

Report
All responses (
Answers (