Answered

Submitted Data not showing up in my google sheet but showing in my app gallery

(0) Share

Report

Posted on by Data_Wizz

Good day Everyone

i have created an app in power app that is connected to a google sheet. However, when i create a new record and submit through the form on my app, i don't see the new record on my google sheet but i can see it in the gallery in my app, amd i can also edit the record but it is not showing up in my google sheet. Any help please.

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (2)

Sort by

Verified answer

Data_Wizz 18 on at

Like
a
(0)

Report
Copy link

Link copied!

Found out the issue. My sheet contains blank rows with formula to create row ID. So my new records were being stored after the end of my rows with formula.

Now, my question is: is there a way to create an ID column without copying the formula all the way down?

Was this reply helpful? Yes No
Verified answer

Data_Wizz 18 on at

Like
a
(0)

Report
Copy link

Link copied!

I was able to create an automated ID column in my google sheet using the Arrayformula() function. And everything runs smoothly now.

Was this reply helpful? Yes No
v-qiaqi@microsoft.com Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Data_Wizz,

Thanks for your sharing.

Was this reply helpful? Yes No