Unanswered

Form updating when data is from excel (online)

(0) Share

Report

Posted on by enavarro

Hello all,

I'm trying to set a worksheet as database in PowerApps. This sheet should be edit through PowerApps by users. For that purpose, I set a editable form linked to this excel data. Data is loaded without problem at first time but the problem I've found is when you edit some fields, the data in excel is modified as expected but is not updated in the PowerApps form.

I tried the same exercise with a SharePoint list and works properly. The issue is the update time in excel connection.

Could anyone help me with the form updating in PowerApps?

Thanks in advanced!

Categories:

Building Power Apps

All responses (8)

Answers (0)

Sort by

v-xiaochen-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @enavarro ,

Could you tell me:

Where is the excel file stored in?

Which connector are you using?

What's the item property formula of the form control?

Best Regards,

Wearsky
enavarro 8 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @v-xiaochen-msft ,

Thanks for your answer.

Where is the excel file stored in? It's an online file in stored in a SharePoint Group
Which connector are you using? Excel Online (Enterprise)
What's the item property formula of the form control? I use a form with FormMode.Edit. It's been submitted through a button by SubmitForm(form_name) formula (assigned to that button in OnSelect field).

The SubmitForm works properly, but if you update the item in the form, take the previous value.

Regards,
Enrique.
v-xiaochen-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @enavarro ,

Thanks for your reply.

The form has an 'item' property. Could you show the formula?

Best Regards,

Wearsky
enavarro 8 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @v-xiaochen-msft

The formula is:

where Select_Item_3 is a dropdown list with each item contained in the excel file:

I select the item in that dropdown, the form shows the row data.

Regards,
Enrique.
v-xiaochen-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @enavarro ,

Please try to modify this formula to:

LookUp(your datasource, Item=Select_Item_3.Selected.Item)

Best Regards,

Wearsky
enavarro 8 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi again @v-xiaochen-msft ,

I changed as you told me. The problem goes on. It's take so long to see the change on the form.
I've taken the following steps:

(1) Change the country text in the form:
Previous:

Changed by:

(2) Update form by button. The change is updated in excel:
Previous:

Current (after update)

(3) I keep seeing the old text after coming back to the same item I changed (item=3)
Current

It's seems the information or updating goes just in one direction.

*Additional information. The dropdown takes items from a collection that is set when the app is launched:

Thanks a lot.

Regards,
Enrique.
enavarro 8 on at

Like
a
(0)

Report
Copy link

Link copied!

Hello all,

I am here again becuase there should be some features updated and I don't have the problem I told you some weeks ago.

I accepted that there could be a delay between the update moment and the one you can see the changed data. Nowdays, it's running properly.

Thank you all for your time.

Regards.

I
Camellia 2 on at

Like
a
(0)

Report
Copy link

Link copied!

Though it seems the original post was solved two years ago, I've been having the same issue for some time now.

When I edit some fields in my Edit Form and submit it, the Excel is immediately modified and so is the gallery in my app.
However, when I select the item I have just modified in the gallery, the Form shows the old data.
Refreshing doesn't work either.

It takes exactly two minutes until I can get the data to be modified.
Is there any way I can solve this?