1st Question - New to PowerApps

(0) Share

Report

Posted on by Can_SJ

Hello Administrator I guess?

I am new to power apps and I was developing my first app and found the first challenge:

In my app the user select the product, the product origin and the product destination, what I want is to retrieve the Duty date based on those 3 conditions.

i.e

DrpProduct = Apple

DrpDestination = USA

DrpOrigin = Argentina

Result:

Tariff = 2007.99.48.00

Rate = 12%

I don't know if this is the correct excel table structure or what is the best method to get this data along with the formulas.

This is a sample of my data:

Any help will be greatly appreciated.

Categories:

Building Power Apps

I have the same question (0)

All responses (7)

Answers (1)

Sort by

Hamed Ghodrat 37 on at

Like (1)

Report
Copy link

Link copied!

Hi @Can_SJ

Please read the following document and write back if you could not solve the issue.
https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-filter-lookup
My recommendation is to use the filter as you may receive multiple records as a result of your query.
If the result with the combination of your filter is unique, then you can use lookup.
Using the First(Filter()) will also give you a unique answer but I don't recommend it because of performance issues.

Good luck
Max

Was this reply helpful? Yes No
eka24 20,925 on at

Like (1)

Report
Copy link

Link copied!

Welcome to the community. There's a lot of support here to help you achieve your aim.

First of all on your structure, I would suggest you include and additional Column for ID, if it not there already.

Then use this formula to retrieve the Duty Date;

LookUp(TableName, IDColumn= Dropdown1.Selected.Value,DutyDateColumn)

Am assuming that user select the options from a Dropdown.

Give it a try and give feedback.

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

Was this reply helpful? Yes No
Sajarac 3,284 on at

Like (0)

Report
Copy link

Link copied!

Wow, thank you very much for your prompt response, I was not expecting a Sunday response. I don't have an ID column but I could definitely ADD one or move my list to a share point.

But I don't quite understand the formula. So, you say just with that formula and the 3 conditions the user can identify the value?

Was this reply helpful? Yes No
Verified answer

rubin_boer 4,843 Super User 2024 Season 1 on at

Like (1)

Report
Copy link

Link copied!

hi there

with your Source Being "yourSource" you can lookup the results you seek.
Set(varGetTarrif,lookup(yourSource, PRODUCT = DrpProduct.selextedtext.value && DESTINATION = DrpDestination .selectedtext.value && ORIGIN = DrpOrigin.selectedtext.vale, TARRIF));
Set(varGetRate,lookup(yourSource, PRODUCT = DrpProduct.selextedtext.value && DESTINATION = DrpDestination .selectedtext.value && ORIGIN = DrpOrigin.selectedtext.vale, GENERAL))

now set the labels text field to varGetTarrif for tarrif and another label to varGetRate for the rate.

the controls for the selection are drop down inputs. there are other ways to do this as well using a collection, the lookup is a good way to start.

Was this reply helpful? Yes No
eka24 20,925 on at

Like (0)

Report
Copy link

Link copied!

That other reason I suggested you add an ID Column to identify the record. Since they are on the same row, the lookup function will pull the corresponding duty date.

Where are you selecting the orgin from, Dropdown?

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

Was this reply helpful? Yes No
Can_SJ 25 on at

Like (0)

Report
Copy link

Link copied!

Yes,

DrpProduct = Apple
DrpDestination = USA
DrpOrigin = Argentina

Result:
Tariff = 2007.99.48.00
Rate = 12%

Was this reply helpful? Yes No
Can_SJ 25 on at

Like (0)

Report
Copy link

Link copied!

Hi there, sorry to bother you but I can not get this function to work properly:

My dropdows are:
DropProduct = Apricot
DropDest = USA
DropCountry = Turkey

I would like to see in two labels

Tariff = 0811.90.80.80
Rate = 14.50%

Any help please?

Was this reply helpful? Yes No