web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / When clicked on save i...
Power Apps
Unanswered

When clicked on save it must update two values to Excel

(0) ShareShare
ReportReport
Posted on by 559

Hi All,

I have a form where there are two columns Status(choice column but in form I have used radio button to display colors) and Observation(single line of text). I have a Excel file where there are 6 columns - Phase, Area , check item, Code(these four are constant with 40 rows), and rest of the two columns are Status and observation which needs to get updated from the PowerApps form. Based on the code in the Excel file it must compare the code with the column name and update the two values. For Eg (the Code is PMC_BOB_BO and the column name would be PMC_BOB_BO_Status and PMC_BOB_BO_Observation). Comparing the code and column name it must update the Excel. Can anyone help or suggest what should be done on this. Thanks in advance.

Categories:
I have the same question (0)

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 717 Most Valuable Professional

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 329 Super User 2025 Season 2

#3
Power Platform 1919 Profile Picture

Power Platform 1919 268

Last 30 days Overall leaderboard