cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Frequent Visitor

update a line item in excel

I have a form that has three questions- Name, Age, Hometown. User fills out information for each using a form on powerapp. My question is this- if we want to fill out name and age and then come back several days later and fill out the hometown information for that line is that possible?

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Microsoft
Microsoft

Re: update a line item in excel

Hi@HubSteel,

Based on the needs that you mentioned, do you want to create a flag for previously incomplete fields?

Combine that with the details you provided, you have an excel sheet as the

data source, I have a test on my side on this premise, please take a try as below.

• Create an app from the excel data

• Set the Text property of the TextInput corresponding to Hometown field as:

 

If(!IsBlank(ThisItem.Hometown),ThisItem.Hometown,"Please fill in")

 

9.png

Best Regards,

Qi

View solution in original post

4 REPLIES 4
Highlighted
Super User
Super User

Re: update a line item in excel

Hi @HubSteel 

The answer is yes.  Annotation 2020-06-06 124929.jpgLet PowerApps create an app from your data and see how it works. 

Highlighted
Super User
Super User

Re: update a line item in excel

That is possible. What you need to do is to have Form with the 3 textfields on NewForm.

Save the 2 fields using the the Submit Button.

Insert Gallery1 and put the datasource on the ITEMS of the Gallery1

 

On the ITEMS of the Form put: Gallery1.Selected

 

Insert another button for Edit and OnSelect put: EditForm

Whenever you want to update the hometown or another field, click on the Edit button, which will pull the existing record

Then add the hometome for that line ans submit form again to update the field for that record------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

Highlighted
Microsoft
Microsoft

Re: update a line item in excel

Hi@HubSteel,

Based on the needs that you mentioned, do you want to create a flag for previously incomplete fields?

Combine that with the details you provided, you have an excel sheet as the

data source, I have a test on my side on this premise, please take a try as below.

• Create an app from the excel data

• Set the Text property of the TextInput corresponding to Hometown field as:

 

If(!IsBlank(ThisItem.Hometown),ThisItem.Hometown,"Please fill in")

 

9.png

Best Regards,

Qi

View solution in original post

Highlighted
Microsoft
Microsoft

Re: update a line item in excel

Hi@rssilvaba,

Have you solved your issue?

If it solves your request, Mark it as a Solution to enable other users to find it.

Best Regards,

Qi

Helpful resources

Announcements
Check this Out

Announcing

Class of 2020- Season 2

Check this Out

Helpful information

Featuring samples like Return to the Workplace and Emergency Response Applications

August 2020 Community Challenge: Can You Solve These?

August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

secondImage

Return to Workplace

Reopen responsibly, monitor intelligently, and protect continuously with solutions for a safer work environment.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors
Users online (8,150)