Answered

My Canvas App and Data Connections

(0) Share

Report

Posted on by BenDonahue

932

On Friday, I ran into he "scrubbedSensitiveData" error. Researching this, all the help I found was, "wait, and Microsoft will figure it out."

Today, Monday, the problem has not gotten better, but seems to have grown worse.

This is what I was getting, even after refreshing my connector:

And this is what I get now, after deleting and replacing the connector:

I even deleted the two references to LandingTable, started re-typing the word, and selected "LandingTable" when it was suggested, but to no avail.

Please, how do I consistently and successfully connect to Excel tables? Are Excel tables just not a good option?

Thank you for your assistance.

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Sort by

Verified answer

WarrenBelz 156,454 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @BenDonahue ,

I will answer the second part of your question - as a database, Excel is an excellent spreadsheet . . .

If you have access to SharePoint, please seriously consider migrating.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Was this reply helpful? Yes No
BenDonahue 932 on at

Like
a
(0)

Report
Copy link

Link copied!

@WarrenBelz ,

I just migrated over yesterday. It wasn't as complicated as I had feared, just some referencing to update and some data types to align.

This forum is a great place to get help with specific issues, but not so great with over-arching philosophy nor strategy, maybe because folk don't want to tell people what they should be doing instead of what they currently are doing.

For my part, Warren, I am unafraid to take your excellent advice; thank you very much, indeed.

Was this reply helpful? Yes No
WarrenBelz 156,454 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @BenDonahue ,

If you have not already, you might read the first few articles on my site Practical Power Apps

Was this reply helpful? Yes No
BenDonahue 932 on at

Like
a
(0)

Report
Copy link

Link copied!

I have not, and absolutely will. Thank you, yet again, Warren 🙂

Was this reply helpful? Yes No