PowerApps Challenge

[Anonymous]

Hello everyone ,

I started using PowerApps before 1,5 month. I am still doing really basic things and i need your help to improve.  In the Following pic I have 2 dropdowns as you can see. I am sending the info to the receivers Gallery as seperate Cards/Lines. I was wondering if i can make them comunicate and send my data for both Dropdowns to the same Card (e.g. by adding an extra TextBox and show the value of my AZD dropdown/ second dropdown) and then i am sending them to the galleries, "An" and "CC" , and if there is a way to save the data from all three Galleries with the button "SP" above the bin to my sharePoint list.

Thank you all!

[v-monli-msft · Accepted solution]

Hi @Anonymous ,

You can make the picked values from 2 dropdown controls to show in a text box by setting below formula in the Text property:

Concatenate( Dropdown1.Selected.Value," ",Dropdown2.Selected.Value)

To update record to SharePoint not using SubmitForm function, you will need to use Patch function. Set a formula similar to below one:

Patch(ListName,Defaults(ListName),{Title:TextInput1.Text,Choice:{
        Value: Dropdown1.Selected.Value,
        '@odata.type': "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference"},
...
        })

In this example, Choice is the column name of a choice column. This formula will create a new item in "ListName" SharePoint list. Different column types will need different syntaxes in Patch function. 

Regards,

Mona