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:

General Questions

All responses (7)

Answers (1)

Can_SJ 25 on at

Like (0)

Report

Re: 1st Question - New to PowerApps

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?
Can_SJ 25 on at

Like (0)

Report

Re: 1st Question - New to PowerApps

Yes,

DrpProduct = Apple
DrpDestination = USA
DrpOrigin = Argentina

Result:
Tariff = 2007.99.48.00
Rate = 12%
eka24 20,921 on at

Like (0)

Report

Re: 1st Question - New to PowerApps

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.
Verified answer

rubin_boer 4,841 Super User 2024 Season 1 on at

Like (1)

Report

Re: 1st Question - New to PowerApps

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.
Sajarac 3,263 on at

Like (0)

Report

Re: 1st Question - New to PowerApps

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?
eka24 20,921 on at

Like (1)

Report

Re: 1st Question - New to PowerApps

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.
Hamed Ghodrat 37 on at

Like (1)

Report

Re: 1st Question - New to PowerApps

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