Answered

Submit multiple rows across multiple standard columns at once

(0) Share

Report

Posted on by tricia_toh

If I want my users to be able to copy and paste multiple rows into a form across 4 standard columns, for example, and submit the form, how can I do so? I also need each column to allow data validation.

See table example below that ideally I want users to see. Not sure if Powerapps is able to do this but would

Name	Item	Qty	Price

Thank you for your help!

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

eka24 20,923 on at

Like (0)

Report

What Datasource are you using, excel or SharePoint. What you have to do is to connect the Datasource to a form in Powerapps.

Then after you have filled the form, submit the form to the Datasource;

Insert a button and OnSelect put:
SubmitForm(TheformName)

If that doesn't help explain where you want to copy from and where you want to paste to.
------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

Was this reply helpful? Yes No
Verified answer

v-yutliu-msft on at

Like (0)

Report
Hi @tricia_toh ,

Do you want to copy some existing data to a form and submit the form?

Could you tell me:

1)whether where the data is and where do you want to save data is the same data source?

2)do you want to create multiple items one time? However, one form could only display/edit/create one item in one time.

3)the fields data type?

Actually, I think your demands is not very clear.

Could you describe more clearly?

I assume that you want to use an item in listA loading in the form for listB and you want to create a new item in listB.

Date type are exactly the same in listA and listB.

If so, you could set like this:

1)the form's data source: listA

Item: the item that you want to display

2)formula to update:

Patch(listB,Defaults(listB),{field1:datacard1.Update,field2:datacard2.Update,field3:datacard3.Update,field4:datacard4.Update })

Best regards,

Was this reply helpful? Yes No