You’re offline. This is a read only version of the page.
Announcements
59
Hey PowerApps community,
I'm facing a challenging issue with my application, and I'd appreciate your help. Let me break down the steps involved to give you a better idea of the situation. I have a ComboBox where you can select multiple brands, and a Dropdown menu that is filtered based on the ComboBox selection to display the stores associated with the selected brand(s). In the Dropdown, you can also select multiple stores. After this, I want to patch my Dataverse table with the correct brand and store information linked to it. Can anyone guide me on how to achieve this?
Hi @LoopinG2023 ,
It seems there are two many-to-many relationships of this table? If so, you need to use Relate function:
Share
Report
All responses (
Answers (
Set(varNew,Patch(Table,Defaults(Table),{Name:"..."}));ForAll(ComboBox1.SelectedItems As CB1,Relate(varNew.ToManyTable,CB1));ForAll(ComboBox2.SelectedItems As CB2,Relate(varNew.ToManyTable,CB2))
Best regards,
