Answered

Save an old choice field and save the new one in the same SharePoint list

(0) Share

Report

Posted on by Gorilla_8

The user needs to save the old and new choice fields in different columns, for example, I have a list in SharePoint called:

"Historic"

And another: "Registration"

I want the "Status" field in the record list, when the user modifies to save the old "Status" from the "Record" list and the new one in the "Historic" list.

Categories:

Building Power Apps

All responses (4)

Answers (1)

Sort by

v-jefferni Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Gorilla_8 ,

Could you please share more details about your scenario?

I could not figure out what you exactly want from your description. How many list are there? What columns/fields do they have? Which columns are Choice type columns?

Enough information would be appreciate to resolve the problem.

Best regards,
Community Support Team _ Jeffer Ni
If this post helps, then please consider Accept it as the solution to help the other members find it.
Gorilla_8 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @v-jefferni

Could you please share more details about your scenario?
Sure, no problem

How many list are there?
Two lists, one called: List1 and another one called List2

What columns/fields do they have?
Choice columns in both

Which columns are Choice type columns?
ChoiceColumn1 and ChoiceColumn2

I will explain again...

I have two lists, List1 and List2, within these lists there are two columns of choice, I want that when the user saves a Form in PowerApps, in List2, save the old choice of the List1 choice field in a column in List2 and save the new choice in List2, my only question is how to save an old choice field in to save as a new item in List2
Verified answer

v-jefferni Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @Gorilla_8 ,

As per your description, I think you could leverage a Patch function along with LookUp when submitting List 1. In short, save current status value in list1 to list2 status column before submitting Form1 which would update list1 status column value. Formula would like below:

Patch(List2,LookUp(List2,Name=Gallery1.Selected.Name),{ChoiceColumn2:Gallery1.Selected.ChoiceColumn1}); //Gallery1.Selected is Form1's item; SubmitForm(Form1)

Hope this helps.

Best regards,
Community Support Team _ Jeffer Ni
If this post helps, then please consider Accept it as the solution to help the other members find it.
Gorilla_8 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @v-jefferni

You help me out with this ideia and I found it a simple one, I just get the selected option old and put in the column choice.

And this soluiton works very well too, thank you! 🙂