Unanswered

PowerApps Gallery Error (DataVerse)

(2) Share

Report

Posted on by TJ-15101834-0

New to PowerApps and running into an issue using a Gallery. The Gallery in the Second Container I need to be able to add Materials Descriptions (Separate table from the main Table) and need it to connect to the main table by the PRID# in the Main table. Error I am receiving is (Note this is in DataVerse)

Update(
    MaterialLines,
    First(Filter(MaterialLines, PRID = LookUp(
        Requisitions,
        PRID = GalOpenReq.Selected.PRID
    ))),
    {Materials: Self.Text}
)
//Filter(MaterialLines,LookUp(Requisitions, PRID=GalOpenReq.Selected.PRID,PRID)  )

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

Sort by

WarrenBelz 156,386 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hi TJ-15101834-0

Firstly, this would be a better structure - your issue is that your Lookup in Requisitions is returning an entire record - you need the field you are trying to compare
With( { _PRID: LookUp( Requisitions, PRID = GalOpenReq.Selected.PRID ).MatchingField }, Patch( MaterialLines, LookUp( MaterialLines, PRID = _PRID ), {Materials: Self.Text} ) )

If it is PRID, then why bother with the other LookUp ?
Patch( MaterialLines, LookUp( MaterialLines, PRID = galOpenReq.Selected.PRID ), {Materials: Self.Text} )

If this is the same gallery as the input text box then
Patch( MaterialLines, LookUp( MaterialLines, PRID = ThisItem.PRID ), {Materials: Self.Text} )

Please click Does this answer your question if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it a Like.
MVP (Business Applications) Visit my blog Practical Power Apps Buy me a coffee

Was this reply helpful? Yes No
TJ-15101834-0 9 on at

Like
a
(0)

Report
Copy link

Link copied!

Is there a special Syntax if the PRID in the "MaterialsLines" Table is a Lookup Field to Requisitions Table PRID Field? PRID is the Foreign Key to the Main Table "Requisitions". I am trying to update the "MaterialLines" Table using the PRID #.

Was this reply helpful? Yes No
WarrenBelz 156,386 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

If your data source is Dataverse - I will leave this to others as I do not use it (I am SharePoint only which I assumed was yours as you did not state what you were using)

Was this reply helpful? Yes No