Unanswered

Excel Connection Not Populating PowerApp

(0) Share

Report

Posted on by smithbws

Here's a noob question. When I attempt to make a connection the fields do not populate in PowerApps and the data cards are missing. How do I get Excel to populate PowerApp with data?

Before I start the PowerApp connection process, I always close the Excel spreadsheet on my PC and in OneDrive. I have formatted the spreadsheet as a table and added a separate tab for drop downs.

This is all I get. I have tried refreshing the connection and closing the PowerApp and starting again. I am sure there is something simple that I am not doing, but I need help figuring out what it is. Thanks!

Categories:

Building Power Apps

All responses (4)

Answers (0)

Sort by

WarrenBelz 156,576 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @smithbws ,
What is the Items property of the gallery?
smithbws 4 on at

Like
a
(0)

Report
Copy link

Link copied!

The ITEMS property in the gallery is:

SortByColumns(Search([@MonitoringList], TextSearchBox1.Text, "Boiler1_x0020_Pressure","Boiler2_x0020_Pressure","Comments"), "Boiler1_x0020_Pressure", If(SortDescending1, Descending, Ascending))

Thank you for your assistance.
WarrenBelz 156,576 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

@smithbws ,
Do you get records when you type a valid item in the Search box>
smithbws 4 on at

Like
a
(0)

Report
Copy link

Link copied!

Yes. But now the app is not populating back to the Excel spreadsheet.