1

I have a PowerApps screen with two forms side-by-side. Form A displays an item from List A in display mode, and Form B shows an item from list B in Edit mode, where the item in List B has the same RequestID value. I'm having the hardest time figuring out how to pass the parameter from Form A to Form B so that Form B loads the correct item. I've tried using Search, Filter, and Lookup, but in all cases, it throws an error in my formula. An example:

Filter(SharePointListA,RequestID=DataCardValue12.Text)

Or

Search(SharePointListA,DataCardValue12.Text,"RequestID")

What am I doing wrong?

Improve this question

1 Answer 1

Reset to default
1

It could be a couple of things:

  • RequestID is type number so you need to have RequestID=Value(DataCardValue12.Text) instead of RequestID=DataCardValue12.Text
  • Filter and Search both return a table/collection and your form needs a Record - LookUp on the other hand returns a Record. So either use LookUp (with Value as above) or use First(Filter(...)).

A screenshot of the Form B properties pane or the error message you get could help understand what is happening

Improve this answer
1
  • The solution was a re-write of the Lookup query. Thanks for pointing me in the right direction!
    – Scott Davis
    Commented Jun 10, 2021 at 17:59

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.