cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Super User
Super User

Get a value by comparing other filled in fields from a datasource

Hey guys

 

 

I think someone posted a simular question like this but I'm not sure.

 

So I'm working on some different kind of ways to make a lunch app and here is were I'm stuck.

I want to get a price value but the price depends on some other filled in fields like Size, Variety and eventually also on the description of a Sandwich.

Could this be achieved with a Collection on the OnVisible of the screen and then search the price in the same screen for those particular filled in values?

 

Kind regards

 

 

Tom





Did I answer your question? Mark my post as a solution!

Proud to be a Flownaut!





2 ACCEPTED SOLUTIONS

Accepted Solutions
Community Support Team
Community Support Team

Re: Get a value by comparing other filled in fields from a datasource

Hi Tom_Slosse,

 

According to your description, I create an app by following ways:
1. Set the OnVisible property of a Screen as:

ClearCollect(test,{Price:10,size:100,variety:"variety1"},{Price:20,size:200,variety:"variety2"})
2. Add a Text input control and a Text box control
3. Set the Text property of the Text box control as:

LookUp(test,size=Value(TextInput2.Text),Price)&LookUp(test,variety=TextInput2.Text,Price)
4. Then when I enter the size or the variety in the Text input control, the corresponding price will be shown on the Text box control.

3.PNG

 

Hope this could be a reference for you. Please feel free reply if you need more help.

 

Best regards,
Mabel Mao

Community Support Team _ Mabel Mao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Super User
Super User

Re: Get a value by comparing other filled in fields from a datasource

Hey all

 

 

I found a solution to my problem to get the price from other filled in fields.

First off I removed the collection because I didn't need it in the end.

And I fixed the problem with the help off @v-yamao-msft her previous post with LookUp() function.

So thank you for giving me that insight

 

So what I did was this:

LookUp(<data_source>, <SPColumn>= <field>.Text [&& <otherColumnsThatNeedToBeComparedToGetTheResult = <field>.Text], <ResultColumn>)

Hope this helps some others as well.

 

Kind regards

 

 

Tom





Did I answer your question? Mark my post as a solution!

Proud to be a Flownaut!





View solution in original post

4 REPLIES 4
Community Support Team
Community Support Team

Re: Get a value by comparing other filled in fields from a datasource

Hi Tom_Slosse,

 

According to your description, I create an app by following ways:
1. Set the OnVisible property of a Screen as:

ClearCollect(test,{Price:10,size:100,variety:"variety1"},{Price:20,size:200,variety:"variety2"})
2. Add a Text input control and a Text box control
3. Set the Text property of the Text box control as:

LookUp(test,size=Value(TextInput2.Text),Price)&LookUp(test,variety=TextInput2.Text,Price)
4. Then when I enter the size or the variety in the Text input control, the corresponding price will be shown on the Text box control.

3.PNG

 

Hope this could be a reference for you. Please feel free reply if you need more help.

 

Best regards,
Mabel Mao

Community Support Team _ Mabel Mao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Super User
Super User

Re: Get a value by comparing other filled in fields from a datasource

Hey @v-yamao-msft

 

 

Thanks for your response, I think I can get my head around this a bit more.

I'll let you know if it works 🙂

 

Kind regards

 

 

Tom





Did I answer your question? Mark my post as a solution!

Proud to be a Flownaut!





Super User
Super User

Re: Get a value by comparing other filled in fields from a datasource

Hey @v-yamao-msft

 

 

It works with a static price indeed thanks for making this clear.

But now I still didn't get the price out of my SharePoint list that matches the description, Variety and Size.

Because price is a table value and it seems that I cant convert it to a Text value.

 

The pictures below show a working version:

Onvis_Prijs.PNGText_prijs.PNG

 

These pictures below is what I need to achieve and let it work:

Onvis_prijs_nonstatic.PNG

Text_prijs_nonstatic2.PNG

Any idea how to do this?

 

Also I want to say thank you for your effort and make some things clear so far!

 

Kind regards 

 

 

Tom

 





Did I answer your question? Mark my post as a solution!

Proud to be a Flownaut!





Super User
Super User

Re: Get a value by comparing other filled in fields from a datasource

Hey all

 

 

I found a solution to my problem to get the price from other filled in fields.

First off I removed the collection because I didn't need it in the end.

And I fixed the problem with the help off @v-yamao-msft her previous post with LookUp() function.

So thank you for giving me that insight

 

So what I did was this:

LookUp(<data_source>, <SPColumn>= <field>.Text [&& <otherColumnsThatNeedToBeComparedToGetTheResult = <field>.Text], <ResultColumn>)

Hope this helps some others as well.

 

Kind regards

 

 

Tom





Did I answer your question? Mark my post as a solution!

Proud to be a Flownaut!





View solution in original post

Helpful resources

Announcements
thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

Top Kudoed Authors
Users Online
Currently online: 122 members 5,457 guests
Please welcome our newest community members: