Comparing table value to text value

[Anonymous]

Hi,

I'm trying to implement write back functionality in the PBI report using a Power Apps embedded in it. The source for PBI is a SP Excel. 

Upon selecting an item in the gallery view the records are not getting reflected in the Edit Form screen. The condition I have used is given below. Please help me in figuring this out
LookUp(Table1,'Supplier ID',Gallery1.Selected.'Supplier ID'). 

Any post regarding this would be appreciated.

Thanks in advance.

[WarrenBelz]

Hi @Anonymous ,

I think you need

LookUp(
   Table1,
   'Supplier ID' = Gallery1.Selected.'Supplier ID'
)

Please click Accept as solution 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 Thumbs Up.

Visit my blog Practical Power Apps

[Anonymous]

Hi @WarrenBelz ,

Thanks for your solution.
 It seems now the error is due to server response.

[WarrenBelz]

Hi @Anonymous ,

I cannot see your data and can only rely on the values you posted. The code I provided is valid if the field 'Supplier ID' is in both Gallery1 and Table1 and is either numeric or Text. What type of field is it ?

[Anonymous]

It's a numeric data type.

[WarrenBelz]

@Anonymous ,

From the error it appears to be Text in the Gallery, so try this

LookUp(
   Table1,
   'Supplier ID' = Value(Gallery1.Selected.'Supplier ID')
)

You simply need to match the two items in both value and data type.

Please click Accept as solution 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 Thumbs Up.

Visit my blog Practical Power Apps

[Anonymous]

@WarrenBelz ,

I tried the above solution as well as various combinations but still the same. 

[WarrenBelz]

@Anonymous ,

You simply need to match the data types - If Supplier ID is numeric, then assuming the same field is available in Gallery 1, then one of

'Supplier ID' = Value(Gallery1.Selected.'Supplier ID')

or

'Supplier ID' = Gallery1.Selected.'Supplier ID'

has to work. Can you please check your data as I can only respond to the information you have posted.

[Anonymous]

@WarrenBelz ,

Sorry for the pestering you in this.

Let me explain the process and what I have done. 

I have created an excel file and converted it into Table and stored in a SharePoint Folder.

Next, I've created a PBI report by fetching data from the SharePoint Folder and published the report in a workspace. 

In the PBI service I have created an Power Apps visuals containing the  Req No. and Item fields to implement the write back functionality (i.e. Perform CRUD operation on the source file).

In the Power Apps I've imported the source file via Excel Online (Business). 
Note: All the columns are are text datatype.

Please refer the below image for the Power Apps I'm trying to create. Highlighted formula in the Edit form is causing an issue.

My objective is to display the data selected data in the gallery into the edit form

Thank you @WarrenBelz , for being so patient and helpful. Let me know if you need anything else.

[Anonymous]

@WarrenBelz , the error I'm receiving is given below.