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

help with formulas

Hi,

 

I have created a SharePoint list that contains list of Items with quantities and prices.

 

I want to create a Power app that allows me when choosing an item to show the quantity and price of that item.

 

can someone help with with which function I can do that?

 

Thanks

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Super User III
Super User III

Re: help with formulas

Use
LookUp(ItemList, Description= ddDescription.Selected.Description,UnitPrice)

View solution in original post

15 REPLIES 15
Highlighted
Super User III
Super User III

Re: help with formulas

Hi @JeanYouni ,

Are you saying you have not created it yet?

This forum is happy to help you with code if you get stuck or specific questions you may have - can you elaborate further?

Highlighted
Helper I
Helper I

Re: help with formulas

I have created it and I was trying to use the lookup function to get what I want but it isnt working, and I'm not sure if the lookup function is the correct way to do it
Highlighted
Super User III
Super User III

Re: help with formulas

OK @JeanYouni ,

Happy to help - can you please supply the code you are trying to use and a bit of a description on what you are trying to achieve.

Highlighted
Helper I
Helper I

Re: help with formulas

ok

 

so from my sharepoint list I created a powerapp from the customize form, since I only need to read from the sharepoint list.

 

THen in the power apps I changed the description box to drop down.

 

in the price box I inserted the below formula

 

LookUp(ItemList, Description= ddDescription, UnitPrice)

 

but I get an error for the formula

Highlighted
Advocate V
Advocate V

Re: help with formulas

Can you share some screenshots? I don't really get your problem because if you create a customized forms App, this fields should work automatically.

 

What type of fields are the quantities and price in your sharepoint list?

Highlighted
Helper I
Helper I

Re: help with formulas

I have attached a couple of screen shots

Highlighted
Advocate V
Advocate V

Re: help with formulas

Point your mouse over the red line under the "=". There you should get a good tooltip information.

Highlighted
Super User III
Super User III

Re: help with formulas

LookUp(ItemList, Description= ddDescription.Selected.Value,UnitPrice)

Or
If Distinct
LookUp(ItemList, Description= ddDescription.Selected.Result,UnitPrice)


I believe ddDescription is a 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.




Highlighted
Helper I
Helper I

Re: help with formulas

I tried your formulas but still I get an error on the (=) sign when i put my mouse on it, it tells me invalid argument type.

 

both formulas gave the error

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Watch Now

Experience what’s next for Power Apps

See the latest Power Apps innovations, updates, and demos from the Microsoft Business Applications Launch Event.

Power Platform ISV Studio

Power Platform ISV Studio

ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors
Users online (6,683)