Updating a Text or Choice Column based on a Multiple Choice Column

[caltmiks]

Hello,

My PowerApp is connected to a SharePoint list. In that SharePoint list I have a multi select column that contains supplier scopes. There are 30 choices in that column and could be a combination of anywhere from 1 to possibly all selections.

I am using the formula at the bottom (I know its a mess, any advice on how to do it a better way appreciated) to update a Single Line of Text field in a SharePoint list to either "Yes" or "No" based on what is in the Multi Choice Column.

When I submit the information the Yes or No doesn't change until I go back and submit it a second time. I will try to show this in screenshots.

1) I start here with nothing in the multiselect in the Edit Form.

2) On the Detail Form it shows:

3) When I add a critical scope on the edit screen the CriticalScopeText doesn't update automatically which is fine since I haven't submitted the form yet.

4) Now I submit the form and CriticalScopeText on the Detail Screen doesn't update.

5) If I navigate back to the edit screen again CriticalScopeText has updated properly.

6) If I submit again from the EditScreen the Details Screen CriticalScopeText has updated properly.

The primary question is if there is any way to get around having to submit the Edit, navigate to details, navigate to edit, submit the edit, navigate to details to get that field to update? I really want the critical scope question to remain view only so people editing the details can't change the answer. If need be I can hide it on the edit form. I have tried both as view and edit and it doesn't seem to make a difference.

Secondary question and not a major issue, but it would be nice to reduce the number of columns.

Is there a way to change a critical scope dropdown box with Yes,No,NA as choices instead of using single line of text how I have done it?

If("Heat Treatment" in Concat(ThisItem.ScopeMatrix,Value,", "),"Yes",If("Foundry Sand" in Concat(ThisItem.ScopeMatrix,Value,", "),"Yes",If("Coating (Non-Paint)" in Concat(ThisItem.ScopeMatrix,Value,", "),"Yes",If("Forgings Closed Die" in Concat(ThisItem.ScopeMatrix,Value,", "),"Yes",If("Forgings Open Die" in Concat(ThisItem.ScopeMatrix,Value,", "),"Yes",If("Foundry Investment" in Concat(ThisItem.ScopeMatrix,Value,", "),"Yes",If("NDE Liquid Penetrant Inspection" in Concat(ThisItem.ScopeMatrix,Value,", "),"Yes",If("NDE Magnetic Particle Inspection" in Concat(ThisItem.ScopeMatrix,Value,", "),"Yes",If("NDE Radiography" in Concat(ThisItem.ScopeMatrix,Value,", "),"Yes",If("NDE Ultrasonic" in Concat(ThisItem.ScopeMatrix,Value,", "),"Yes",If("Thermal Processes" in Concat(ThisItem.ScopeMatrix,Value,", "),"Yes",If("Welding Cladding" in Concat(ThisItem.ScopeMatrix,Value,", "),"Yes",If("Welding Pressure Containing" in Concat(ThisItem.ScopeMatrix,Value,", "),"Yes",If("Welding Repair" in Concat(ThisItem.ScopeMatrix,Value,", "),"Yes",If("Welding Special" in Concat(ThisItem.ScopeMatrix,Value,", "),"Yes",If("Welding Structural" in Concat(ThisItem.ScopeMatrix,Value,", "),"Yes","No"))))))))))))))))

Thank you for the assistance.

[v-qiaqi-msft · Accepted solution]

Hi @caltmiks,

There is a duplicated thread here that you have resolved it.

I will mark here to close this case.

Thanks for your cooperation.