cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Larussa
Helper I
Helper I

Search/Filter/Lookup

I need tour help.I have 3 columns on Excel sheet. The first column has to start number, example: 1. Second column has final number example: 10. The third colomn has one Text, example: New York. I would like one fórmula on App, if I text one number between 1 and 10, example 1, 2 ,3,4,6,6,7,8,9 or 10, result the word " New York.". I tried, Lookup, Filter and Search but It didn't work.

1 ACCEPTED SOLUTION

Accepted Solutions

@Larussa 

Seems there's a data type mis-match  ... somewhere. Try this

LookUp(
       IMPORTACAONEW;
       Value(CEPInicial) <= Value(Label9.Text)&&
       Value(CEPFinal) >= Value(Label9.Text);
       DirecaoTriagem
)

 

 

 

View solution in original post

7 REPLIES 7
Eelman
Super User
Super User

@Larussa 

Add a TextInput control to your app and call it NumInput.

 

Then add a label to your app and set this as the Text property

LookUp(yourExcelTableName, Start<=Value(NumInput.Text) && End>=Value(NumInput.Text),Text)

Note:

- your Excel table must be a Table in Excel

- Column headings of your table are; 'Start', 'End' and 'Text'

- replace 'yourExcelTableName' with the name of your source/Excel table 

v-bofeng-msft
Community Support
Community Support

Hi @Larussa :

I'm not quite sure what your request is. The following is my guess. If there is an error, please point it out.

Case1:You have a text input box,and if you input a number between 1 and 10,then filter the records whose third colomn is "New York".

If so,try this code:

 

IF(Value(TextInput1.Text)<=10 && Value(TextInput1.Text)>=1,Filter(yourdatasource,'The third colomn'="New York"))

 

Case2:You want to update the "third colomn" value of the record in the data source with the value of "Second column" between 1 and 10 to "New York"

If so,try this code:

 

UpdateIf(yourdatesource,'Second column'<=10 && 'Second column'>=10,{'The third colomn':"New York"})

 

If the above two cases do not meet your requirements, could you describe your requirements in detail and provide your code and screenshots?

I think these links will help you a lot:

https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-filter-lookup

https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-update-updateif

Best Regards,

Bof

Thanks a lot @Eelman , but it unforunately it didn't work. It's my formula: 

 

LookUp(IMPORTACAONEW;CEPInicial<=Value(Label9.Text)&&CEPFinal>=Value(Label9.Text);DirecaoTriagem)

 

error message: invalid argument, expected numeric value

 

 

 

Thanks you @v-bofeng-msft, but It did't work.

 

it's my fomula:

If(Value(Label9.Text)<=Cepfinal && Value(Label9.Text)>=Cepinicial;Filter(IMPORTACAONEW;'The third colomn'="DirecaoTriagem"))

 

invalid argument, expected text.

@Larussa 

Seems there's a data type mis-match  ... somewhere. Try this

LookUp(
       IMPORTACAONEW;
       Value(CEPInicial) <= Value(Label9.Text)&&
       Value(CEPFinal) >= Value(Label9.Text);
       DirecaoTriagem
)

 

 

 

View solution in original post

Congratulations @Eelman 

 

It's work very well

 

Thanks you

Great job!

Helpful resources

Announcements
PA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

secondImage

Power Apps Community Call

Please join us on Wednesday, October 20th, at 8a PDT. Come and learn from our amazing speakers!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Top Solution Authors
Top Kudoed Authors
Users online (1,542)