Compare text from powerapps with text on excel.

[RLeite]

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.

[WarrenBelz]

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]

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

[RLeite]

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.

[WarrenBelz]

@RLeite ,

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

[RLeite]

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)

 

Thank you.

[WarrenBelz · Accepted solution]

@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

[RLeite]

Hello.

Thank you very much for your help.

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