You’re offline. This is a read only version of the page.
Announcements
2
I want to create a many to many relationship between Failure and Area, I will accomplish using creating a manual junction table jnc_fail_area:
I have a user form (Failure_table) where users can create a new failure and a combobox(Area) outside of the form where users can select multiple areas and a button with onselect:
Set(CurrentUserID, LookUp(Users, 'Primary Email' = User().Email).systemuserid);
SubmitForm(Form3_2);
ForAll(ComboBox1_1.SelectedItems,Patch(Jnc_Failure_Areas,Defaults(Jnc_Failure_Areas),{Failure_ID: LookUp(Cleanpoint_Failures, Failure_ID = Form3_2.LastSubmit.Failure_ID),Area_ID: LookUp(Cleanpoint_Areas, Area_ID = ThisRecord.Area_ID)}));
the failure table gets updated but the junciton table is not the formula dosent give me any error
there are only 2 other required column in the junction table : Owner and status code:
I have no idea why this is not working
c
Hello, @Naddesh, do you have the ForAll formula in the OnSuccess event of the Form3_2?
| If my reply helped you, please give a 👍 , & if it solved your issue, please give a 👍 & Accept it as the Solution to help other community members find it more. I am primarily available on weekdays from 6-10 PM CT and 5-10 PM CT on weekends. Visit my Blog: www.powerplatformplace.com Visit my YouTube Channel: https://www.youtube.com/@powerplatformplace/videos |
Share
Report
All responses (
Answers (
