cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Anonymous
Not applicable

Appropriate use for Power Apps

Appropriate use for Power Apps,

Im Trying to determine if Power Apps can be used in this application or if I need something with abit more of a backend such as .NET.

Can Power Apps be used do the following:

Table A (sharepoint list A). Contains a set of results from a test.

IE Test 1, Test 2, Test 3, For Product 1, At location 1, Sample ID 1;

 

Table B (also sharepoint) contains a list of specs to compare the results too.

IE Test 1, For Product 1, At location 1,

Test 1, For Product 2, At Location 1,

Test 2, For Product 1, At location 2;

And so on

 

Table C (sharepoint) Will be filled by Power Apps comparing Table A to Table B.

Sample ID1, Passed for Location 2,

Sample ID1, Failed For Location 1;

 

Some filtering will need to be done because Table A will specify the Product and Location and Depending on the Product and its location will indicate what specs it needs to be compared too in Table B.

 

Can this be achieved within Power Apps and if so what methods or mechanisms should I use to achieve such a goal?

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Community Support
Community Support

Re: Appropriate use for Power Apps

Hi @Anonymous ,

Could you please share a bit more about your scenario?

Could you please show more details about the compare logic between the Table A and Table B?

 

Based on the needs that you mentioned, I think the PowerApps could achieve your needs. If you want to compare the Table A and Table B, I think the ForAll function may help in your scenario.

More details about ForAll function, please check the following article:

ForAll function

You could consider take a try with the following formula (add a Button, set the OnSelect property to following):

ForAll(
       TableA,
       If(
           If(
              !IsBlank(LookUp(Table2, ProductColumn = TableA[@ProductColumn] && LocationColumn = TableA[@LocationColumn])),
              Collect(
                     TableC,
                     {
                       Column1: "xxx",
                       Column2: "xxxxx"
                     }
              )
           )
       )
)

 

More details about comparing two tables, please check and see if the following threads would help in your scenario:

https://powerusers.microsoft.com/t5/Expressions-and-Formulas/Compare-2-tables-and-show-list-of-what-is-not-duplicated/m-p/92973

https://powerusers.microsoft.com/t5/Building-Power-Apps/Compare-two-collections-and-list-only-no-matchin-data/m-p/290087

 

Best regards,

Community Support Team _ Kris Dai
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

1 REPLY 1
Highlighted
Community Support
Community Support

Re: Appropriate use for Power Apps

Hi @Anonymous ,

Could you please share a bit more about your scenario?

Could you please show more details about the compare logic between the Table A and Table B?

 

Based on the needs that you mentioned, I think the PowerApps could achieve your needs. If you want to compare the Table A and Table B, I think the ForAll function may help in your scenario.

More details about ForAll function, please check the following article:

ForAll function

You could consider take a try with the following formula (add a Button, set the OnSelect property to following):

ForAll(
       TableA,
       If(
           If(
              !IsBlank(LookUp(Table2, ProductColumn = TableA[@ProductColumn] && LocationColumn = TableA[@LocationColumn])),
              Collect(
                     TableC,
                     {
                       Column1: "xxx",
                       Column2: "xxxxx"
                     }
              )
           )
       )
)

 

More details about comparing two tables, please check and see if the following threads would help in your scenario:

https://powerusers.microsoft.com/t5/Expressions-and-Formulas/Compare-2-tables-and-show-list-of-what-is-not-duplicated/m-p/92973

https://powerusers.microsoft.com/t5/Building-Power-Apps/Compare-two-collections-and-list-only-no-matchin-data/m-p/290087

 

Best regards,

Community Support Team _ Kris Dai
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

Helpful resources

Announcements
secondImage

Demo-Extravaganza 2020

Check out these cool Power Apps & vote on your favorite!

secondImage

Community Highlights

Check out whats happening in Power Apps

secondImage

Community User Group Member Badges

FIll out a quick form to claim your community user group member badge today!

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors
Users online (10,491)