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?
Go to Solution.
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:
You could consider take a try with the following formula (add a Button, set the OnSelect property to following):
!IsBlank(LookUp(Table2, ProductColumn = TableA[@ProductColumn] && LocationColumn = TableA[@LocationColumn])),
More details about comparing two tables, please check and see if the following threads would help in your scenario:
View solution in original post
Check out these cool Power Apps & vote on your favorite!
Check out whats happening in Power Apps
FIll out a quick form to claim your community user group member badge today!
Features releasing from October 2020 through March 2021