Unanswered

Inserting selected gallery records with additional fields to another

(0) Share

Report

Posted on by haripriya_adus

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?

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

v-xiaochen-msft on at

Like (0)

Report

Hi @haripriya_adus ,

I did a sample for you.

Best Regards,

Wearsky

Was this reply helpful? Yes No
haripriya_adus 10 on at

Like (0)

Report

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))

Was this reply helpful? Yes No
v-xiaochen-msft on at

Like (0)

Report

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

Was this reply helpful? Yes No