For all - Submit form in powerapps

[Hasini]

Hello all,

Can we use submit form with in forall

My Scenario,

I have list of records in one data source say "SelectedItems"; and i have target datasource "ItemLines"

I need to create all the records from Datasource "SelectedItems" to "ItemLines" using Submit form 

As i have some issue in fetching errors in patch function

I need suggestion/help to implement using submit form within forall

Thanks in advance

[DavesTechTips]

Hi @Hasini ,

This would depend on how you are selecting the records from the source datasource. I will assume that you have a gallery on the source datasource and that you want to first select all the items, then click on a button to push them to the destination datasource.

To do this, you could have a checkbox on the gallery with the following formula on the CheckBox OnCheck (Not OnSelect) that would add the item to a collection if the CheckBox is selected.:

Collect(colSelectedItems,ThisItem)

Similarly you would have a formula on the same CheckBox OnUnCheck:

Remove(colSelectedItems,ThisItem)

Do display the check in the CheckBox only if the item is found in the collection, specify the following formula in the CheckBox Default:

ThisItem in colSelectedItems

On a button or some other action, you could now right all the items from the colSelectedItems to the destination datasource. OnSelect:

Collect(DestinationDataSource,colSelectedItems)

ForAll in the above scenario won't work the best because it will issue multiple 'save' requests to the datasource which will also affect performance.

Let me know if you don't come right.

Dawid van Heerden
Follow on Twitter: @davestechtips
Subscribe to YouTube: https://www.youtube.com/davestechtips?sub_confirmation=1
**If you found this reply helpful, please like it and mark this as the answer to close the topic and make it easier to find for other people with similar questions.

[Hasini]

 HI @DavesTechTips  

Thanks for the reply.

I have used the same technique as you mentioned .

Just i  need to know whether we can do submit the form of target entity , by inputting the value from collection

[DavesTechTips]

Hi @Hasini ,

What extra functionality as you hoping to gain by submitting the form for the destination entity?

[Hasini]

I need to create bulk lines from my initial entity to target entity

where ill select multiple records from initial entity ..

The selected lines are need to be inserted into the target entity

on insertion i need to capture errors of each record i need to display for the user

[DavesTechTips]

In the case you would use the method I mentioned above to get the records in the colSelectedItems gallery.

You then use the form with the following:

Form.DataSource:

DestinationDataSource

Form.Item:

First(colSelectedItems)

Form.OnSuccess:

Remove(colSelectedItems, First(colSelectedItems))

You then just need a submit button to trigger the save to the destination datasource in the onselect:

SubmitForm(FormName)

Let me know if you don't come right.

Dawid van Heerden

Follow on Twitter: @DavesTechTips

Subscribe to YouTube: https://www.youtube.com/davestechtips?sub_confirmation=1

**If you found this reply helpful, please give it a thumbs up and Accept as Solution to close the topic and make it easier to find for other people with similar questions.

[Hasini]

Hi @DavesTechTips 

I am getting the following error when i use collection as item in my form where datasource is destinationDataEntity

[v-xida-msft · Accepted solution]

Hi @Hasini ,

Do you want to use SubmitForm function within ForAll function?

The SubmitForm function is used to submit a single one form data back to related data source. If you want to SubmitForm function within ForAll function, I afraid that there is no way to achieve your needs in PowerApps currently.

As an alternative solution, I think the Patch function could achieve your needs. I have made a test on my side, please try the following formula within your app (set the OnSelect property of "Submit" button😞

ForAll(
        SelectedItems,
        Patch(
              ItemLines,
              Defaults(ItemLines),
              {
                Column1: SelectedItems[@Column1],
                Column2: SelectedItems[@Column2],
                Column3: SelectedItems[@Column3],
                ...
                ...
              }
        )
)

Note: The SelectedItems[@ColumnName] formula is used to reference column value from the SelectedItems data source.

More details about Disambiguation operator (@) in PowerApps, please check the following article:

https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/operators#disambiguation-oper...

Best regards,

[DavesTechTips]

Form.Item should be set to 

First(colSelectedItems)

[Hasini]

I have used First(colSelectedItem) . am getting the same error