cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
haripriya_adus
Frequent Visitor

Inserting selected gallery records with additional fields to another

I have table1 as source for a gallery, but the gallery has some additional controls. On selecting records on the gallery, the records to be added to may be collection and then insert to another table on button click?

1 ACCEPTED SOLUTION

Accepted Solutions
v-xiaochen-msft
Community Support
Community Support

Hi @haripriya_adus ,

 

I did a sample for you.

vxiaochenmsft_0-1652247683687.png

vxiaochenmsft_1-1652247688868.png

vxiaochenmsft_2-1652247699774.png

vxiaochenmsft_3-1652247768299.png

 

 

Best Regards,

Wearsky

View solution in original post

3 REPLIES 3
v-xiaochen-msft
Community Support
Community Support

Hi @haripriya_adus ,

 

I did a sample for you.

vxiaochenmsft_0-1652247683687.png

vxiaochenmsft_1-1652247688868.png

vxiaochenmsft_2-1652247699774.png

vxiaochenmsft_3-1652247768299.png

 

 

Best Regards,

Wearsky

haripriya_adus
Frequent Visitor

Thank you Wearsky. Made some progress on this but landed on another issue. My backend is dataverse. I am currently blocked on this particular issue. I am inserted selected records from a gallery based on oncheck of a checkbox to selectedActivities2 collection, which is working fine. On click of a button, I wrote this formula that should insert record to sup table with selected activity in a lookup column. The code works fine when the name is hardcoded, and the new record in sup table shows 'Activity1' value in lookup column, but the same does not work when I replace the hardcoded value with the collection field  'ActivityName'. I tried with Lookup, Filter, but nothing works. Desperately looking for help on this, if someone can kindly resolve this for me

ForAll(selectedActivities2,
Patch(Sup,
Defaults(Sup),
{
//ActivityId:LookUp(MyActivities,Name="Activity1"),
ActivityId:First(Filter(MyActivities,Name=ActivityName))

v-xiaochen-msft
Community Support
Community Support

Hi @haripriya_adus ,

 

Have a good day.

It seems like this is a new question.

If you are having a new question, I suggest you create a new post to ask for help because users in the forum are more focused on new posts.

 

Best Regards,

Wearsky

Helpful resources

Announcements
Power Platform Call June 2022 768x460.png

Power Platform Community Call

Join us for the next call on August 17, 2022 at 8am PDT.

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Users online (3,951)