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:

General Questions

All responses (3)

Answers (0)

WarrenBelz 146,702 Most Valuable Professional on at

Like (0)

Report

PowerApps Gallery Error

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)
TJ-15101834-0 9 on at

Like (0)

Report

PowerApps Gallery Error

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 #.
WarrenBelz 146,702 Most Valuable Professional on at

Like (0)

Report
PowerApps Gallery Error

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