cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
RLeite
Helper II
Helper II

Compare text from powerapps with text on excel.

Hello everyone.

 

On powerapps, I used the CONCATENATE function to have the result of 2 DROPDOWN. My result is a text. 

I'd like to compare that text with the DEPARTMENT column on excel. The result is the same cell on the TARGET column.  

My excel table is called TABELA_DEP_TARGET.

 

Annotation 2022-01-14 164305.jpg

1 ACCEPTED SOLUTION

Accepted Solutions

@RLeite ,

Concat is a bad name for a field as it is also a Power Apps command, however you should not need it. If this is the Text of Label6

With(
   {
      wValues:
      Dropdownl_2.Selected.PROJECT & Dropdown2.Selected.DEPARTMENT
   },
   LookUp(
      AddColumns(
         TABELA_DEP_TARGET,
         "ProjDept",
         PROJECT & DEPARTMENT
      ),
      ProjDept = wValues
   )
).TARGET

 

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

 

View solution in original post

7 REPLIES 7
WarrenBelz
Super User
Super User

Hi @RLeite ,

You would need something like

Filter(
   TABELA_DEP_TARGET,
   DEPARTMENT = Dropdown1.Selected.xxxx & Dropdown2.Selected.xxxx
).TARGET

xxxx is the output (Value/Result/FieldName) of the dropdown.

 

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

WarrenBelz
Super User
Super User

Hi @RLeite ,

Just checking if you got the result you were looking for on this thread. Happy to help further if not.

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

Hello. 

 

Unfortunately, I didn't got the result I was expecting, as you can see in the image bellow. 

In fact, I didn't get any result at all.

By the way, my TARGET is LABEL6.

 

Annotation 2022-01-18 083233.jpg

@RLeite ,

Why do you have Concat= in there - your code is not what I posted.

I needed to change the name of some fileds. Now, my status is this: 

 

(on PowerApps):

DEPARTMENT - DropDown1

PROJECT - Dropdown1_2

TARGET - Label6

 

(on Excel)

01.JPG

Thank you.

 

@RLeite ,

Concat is a bad name for a field as it is also a Power Apps command, however you should not need it. If this is the Text of Label6

With(
   {
      wValues:
      Dropdownl_2.Selected.PROJECT & Dropdown2.Selected.DEPARTMENT
   },
   LookUp(
      AddColumns(
         TABELA_DEP_TARGET,
         "ProjDept",
         PROJECT & DEPARTMENT
      ),
      ProjDept = wValues
   )
).TARGET

 

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

 

Hello.

 

Thank you very much for your help.

I just needed to change the data row limit (from 500 to 1000).

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

PA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.

PA.JPG

New Release Planning Portal (Preview)

Check out our new release planning portal, an interactive way to plan and prepare for upcoming features in Power Platform.

Top Solution Authors
Top Kudoed Authors
Users online (2,925)