Patch combination of pairs

(0) Share

Report

Posted on by SlyFox

Hello,

My power app has two Combo Box:

Combo Box 1 Name: ComboBox_USR_Logon

Connected to SQL table: D_Users

Layout: Double

Primary Text: USR_LogonName VARCHAR(50)

Secondary text: USR_FullName VARCHAR(50)

SearchField: USR_FullName

Combo Box 2 Name: ComboBox_selectUGP

Connected to SQL table: D_Groups

Layout: Double

Primary Text: UGP_Nr VARCHAR(50)

Secondary text: UPG_Name VARCHAR(50)

SearchField: UGP_Name

I need a button with a function that will write to the SQL Table all combinations of the selected UGP_Nr.

A pair of UGP_Nr combinations must be separated by *

Table for writing:

Name: GroupsCombination_per_User

It has two fields:

Field1: USR_LogonName VARCHAR(50)

Field2: UGP_Nr_Combinations VARCHAR(50)

Sample data:

ComboBox_USR_Logon: USER1

ComboBox_selectUGP: 2000, 2351, 1345

The table should be written in the following form:

USER1, 2000*2351

USER1, 2351*2000

USER1, 2351*1345

USER1, 1345*2351

USER1, 1345*2000

USER1, 2000*1345

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

victorcp 2,350 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!
Hi,

You can create a collection with all the combination, to do that I created two loops to iterate over all the selected items if the positions is diferent it will add that item to the collection and then Patch it to your database.

Here is the code:

Clear(colCombination); With( {vCountSelected:CountRows(ComboBox_selectUGP.SelectedItems), vItems:ComboBox_selectUGP.SelectedItems}, ForAll( Sequence(vCountSelected) As vIterator1, ForAll( Sequence(vCountSelected) As vIterator2, If( vIterator1.Value<>vIterator2.Value, Collect( colCombination, { USR_LogonName: ComboBox_USR_Logon.Selected.USR_LogonName, UGP_Nr_Combinations:Index(vItems,vIterator1.Value).Value & "*" & Index(vItems,vIterator2.Value).Value } ) ) ) ) ); Patch( GroupsCombination_per_User, colCombination );

Any doubts please let me know

Was this reply helpful? Yes No
SlyFox 30 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi,
The function returned an error, the screenshot in the attachment

Was this reply helpful? Yes No
Verified answer

victorcp 2,350 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
Sorry my mistake, value is not recognize because it doesn't exist, I have corrected the formula:

Clear(colCombination); With( {vCountSelected:CountRows(ComboBox_selectUGP.SelectedItems), vItems:ComboBox_selectUGP.SelectedItems}, ForAll( Sequence(vCountSelected) As vIterator1, ForAll( Sequence(vCountSelected) As vIterator2, If( vIterator1.Value<>vIterator2.Value, Collect( colCombination, { USR_LogonName: ComboBox_USR_Logon.Selected.USR_LogonName, UGP_Nr_Combinations:Index(vItems,vIterator1.Value).UGP_Nr & "*" & Index(vItems,vIterator2.Value).UGP_Nr } ) ) ) ) ); Patch( GroupsCombination_per_User, colCombination );

S

Was this reply helpful? Yes No