@v-bofeng-msft -
I'm wondering if its because the formulas have Distinct and/or Filter in them. The formulas are as below:
This filters out the signed in person from the dropdown as they can't assign the task to themselves -
Distinct
(Filter(Filter('SPList3', Not(Advisor in DataCardValue2_1.Text)),
Department = DataCardValue1.Selected.Value), Advisor
)
This filters the majors based on the department:
Distinct(Filter('SPList2', Department = DataCardValue1.Selected.Value), Major)
This filters the concentration based on the major:
Filter('SPList2', Major = DataCardValue4.Selected.Value)
For the Submit button we have this formula - which patches 3 different forms to the SPList1, as it is a lengthy form:
UpdateContext({locIsSubmit:false}); Patch('SPList1', Defaults('SPList1'), Form1.Updates, Form2.Updates, Form3.Updates); Navigate('Confirmation Page', ScreenTransition.None)
In the Power Automate, when the item is created, the SPList1 is populated with the data from the forms, which doesn't populate the above three fields in the list, but populates all the other fields from the forms.
Hope this helps. Please let me know if you need any further information so I can get this project DONE! Thank you!
