Answered

Comparing table value to text value

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

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.

Categories:

Building Power Apps

I have the same question (0)

All responses (11)

Answers (1)

Sort by

WarrenBelz 156,123 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
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

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @WarrenBelz ,

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

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

Like
a
(0)

Report
Copy link

Link copied!

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 ?

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

It's a numeric data type.

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

Like
a
(0)

Report
Copy link

Link copied!
@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

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

@WarrenBelz ,

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

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

Like
a
(0)

Report
Copy link

Link copied!
@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.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

@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.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Verified answer

WarrenBelz 156,123 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
@Anonymous

Are you saying now it is Text (not numeric as previously noted). You have not stated the Items of Gallery1, but assuming it is based on the Table, then

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

is correct. This is the most basic of data matches and simply should work if both values are of the same data type. Also when you noted importing the data from Excel, is this into a SharePoint List (Table1). If so, go to the List Settings, select the 'Supplier ID' column and look at the end of the URL at the top to see what the actual field name is.

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

Was this reply helpful? Yes No