Hi @Jim_4469786f6e ,
Could you tell me:
- What controls and functions do you want to use to submit records?
I assume:
- You use a button control to submit the record.
- To facilitate testing, I have 3 columns, they are ‘Title’ column , ‘TestA’ column and ‘TestB’ column. ‘Title’ column is the object . ‘TestA’ and ‘TestB’ are proprties of this object.
If the above assumptions are true, I've made a test for your reference:
1\ This is my list ‘LIST73’ . ‘TestA’ is a Single line of text column. ‘TestB’ is a choice column.(These columns are used to simulate your AAD data.)
2\ This is my list ‘LIST74’. 'User' , 'Before' and 'After' are Single line of text columns. 'Date and Time' is a date and time column. The list is used to store historical records.
3\ Add a gallery control ‘Gallery2’ and set its Items property to:
LIST73
4\ Add a dropdown control ‘Dropdown1’ and set its items property to:
Choices(LIST73.TestB)
Set the default property of ‘Dropdown1’ to:
Gallery2.Selected.TestB.Value
5\ Add a textinput control ‘TextInput1’ and set its default property to:
Gallery2.Selected.TestA
6\ Add a button control and set its onselect property to:
Clear(TestCollection);
If(TextInput1.Text<>Gallery2.Selected.TestA||Dropdown1.Selected.Value<>Gallery2.Selected.TestB.Value,
Patch(LIST73,Gallery2.Selected,{TestA:TextInput1.Text,TestB:Dropdown1.Selected}));
If(TextInput1.Text<>Gallery2.Selected.TestA,
Collect(TestCollection,{Item:Gallery2.Selected.Title,TestBefore:Gallery2.Selected.TestA,TestAfter:TextInput1.Text}));
If(Dropdown1.Selected.Value<>Gallery2.Selected.TestB.Value,
Collect(TestCollection,{Item:Gallery2.Selected.Title,TestBefore:Gallery2.Selected.TestB.Value,TestAfter:Dropdown1.Selected.Value}));
ForAll(TestCollection,
Patch(LIST74,Defaults(LIST74),{Title:Item,'Date and Time':Now(),User:User().Email,Before:TestBefore,After:TestAfter}))
7\ The result is as follows:
Best Regards,
Wearsky
If my post helps, then please consider Accept it as the solution to help others. Thanks.
