web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Apps
Answered

Patch Gallery

(0) ShareShare
ReportReport
Posted on by 271

Hi,

Below is the Screenshot from a Canvas. 

Sam70_0-1712511289523.png

When saved, the list is like - 

Sam70_2-1712511817791.png

The issue is: For track name - Voice, the value is 1,7,8 whereas it should be NA,4,9.

Sam70_3-1712511941633.png This is the patch function that has been used. Title are in Gallery3 and Track are in Gallery1.

Need help. 

Regards

 

 

Categories:
I have the same question (0)
  • Anil_g Profile Picture
    668 Moderator on at

    @Sam70 


    Looks like depending on the BB.Track value you need to write an if condition in for rating to either pick Cbox1 or Cbox2 .. something like below

     

    rating: If(BB.Track = "Data",AA.CBox1.Selected.Value,AA.Cbox2.Selected.Value)

    cheers

  • Sam70 Profile Picture
    271 on at

    Hi @Anil_g ,

    Now receiving an Error

    Sam70_0-1712556048493.png

    What could be the reason?

    Regards

  • Sam70 Profile Picture
    271 on at

    Hi @Anil_g , Tried your solution but Rating value is not changing

    Sam70_0-1712577273218.png

    Regards

     

  • Anil_g Profile Picture
    668 Moderator on at

    @Sam70 

     

    Looks like the if condition is failing always..try to check the condition track = "Data" may be text() can solve

     

    cheers

  • mmbr1606 Profile Picture
    14,605 Super User 2025 Season 2 on at

    can you please copy paste your code here so we do not need to retype?

     

    thanks in advance

     

  • Sam70 Profile Picture
    271 on at

    Hi @mmbr1606 , Below is the code -

     

    ForAll(Gallery1.AllItems As BB,ForAll(Gallery3.AllItems As AA,Patch('HeatMap Transaction',Defaults('HeatMap Transaction'),{Title:AA.Title,
     VDU:VDUCombo.Selected.Value,Category:CategoryCombo.Selected.Value,Rating:If(BB.Label1.Text="Data",AA.CBox1.Selected.Value,AA.CBox2.Selected.Value),Remarks:AA.RemarksText.Text,Track:BB.Label1.Text})))
     
    Regards
  • Sam70 Profile Picture
    271 on at

    Hi @Anil_g , 

    I have used Rating: If("Data" in BB.Label1.Text,AA.CBox1.Selected.Value,AA.Cbox2.Selected.Value) and this works perfect. Thanks for Helping.

  • Verified answer
    Anil_g Profile Picture
    668 Moderator on at

    @Sam70 

     

    Awesome glad it helped you . 

    cheers

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 739 Most Valuable Professional

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 343 Super User 2025 Season 2

#3
Power Platform 1919 Profile Picture

Power Platform 1919 268

Last 30 days Overall leaderboard