Answered

How to get multiple gallery data into single ID sharepoint column

(0) Share

Report

Posted on by B8

258

I had created a Gallery which added a multiple category (DataCardValueCategory) and Assign To(DataCardValueAssignedTo) which add Email. now i have to store all the category and and Assign to person email at particular column of SharePoint so that Approval can be sent according to the Assign To.

I have a SharePoint list which has Category and Assign To column but it is adding all into different row not in a single column.

How would i perform so that it could be in single row and approval should be sent according to assign person one by one.

I know about the Automate Flow just need how i can save the data into single row.

Categories:

Building Power Apps

I have the same question (0)

All responses (7)

Answers (1)

v-zhoqian-msft Microsoft Employee on at

Like (0)

Report

Hi @B8 ,

Do you want to put all three rows of data in the picture into one row of SharePoint? Or the controls in the picture are multi-select combo box, and you want to put the multiple results of each row into a row of SharePoint?

Was this reply helpful? Yes No
B8 258 on at

Like (0)

Report

yes I want to put all three rows of data in the picture into one row of SharePoint.

Was this reply helpful? Yes No
Verified answer

WarrenBelz 153,073 Most Valuable Professional on at

Like (0)

Report
Hi @B8 ,

This will put them on one Text field, each on a new line

Concat( GalleryName.AllItems, Category & " " & 'Assign to', Char(10) )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

MVP (Business Applications) Visit my blog Practical Power Apps

Was this reply helpful? Yes No
B8 258 on at

Like (0)

Report

I have to add one text field also and then add this code in that ?
And how would I Patch this code in my SharePoint list.

in my gallery - OnSelect I have written this code.

Patch(
ColGridDataTwo,
ThisItem,
{
Category: DataCardValueCategory.Selected,
'Assigned To': DataCardValueAssignedTo.Selected
}
);

Was this reply helpful? Yes No
WarrenBelz 153,073 Most Valuable Professional on at

Like (0)

Report
@B8 ,

Like this I beleive

Patch( ColGridDataTwo, ThisItem, { YourNewTextField: Concat( GalleryName.AllItems, Category & " " & 'Assign to', Char(10) ) } )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

MVP (Business Applications) Visit my blog Practical Power Apps

Was this reply helpful? Yes No
B8 258 on at

Like (0)

Report

Its not working

How would I Create my SharePoint list according to this. I want to save my Gallery value and the i have to make Automate flow for one by one its should go to every category. If it is approve it goes to next category and so on.

Was this reply helpful? Yes No
WarrenBelz 153,073 Most Valuable Professional on at

Like (0)

Report

@B8 ,

Sorry, now I am quite lost as to what you are trying to do. The question you asked was How would i perform so that it could be in single row and approval should be sent according to assign person one by one. and that can be achieved with the code I provided

Was this reply helpful? Yes No