Unanswered

Patch For Excel

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hye,

I'm working from an excel file that has only 10 rows but in the future, it might grow to 5000+ records. I am just using excel for patching.(Not for filtering/searching )

1- Can the app patch if the file has more rows?

2- I have a PowerApp connected with Onedrive and want to Patch the dropdown for one drive excel. How can I achieve this?

Thanks,

Categories:

Building Power Apps

All responses (3)

Answers (0)

Sort by

MayankP 464 on at

Like
a
(0)

Report
Copy link

Link copied!

refer following article for this..

https://michalguzowski.pl/how-to-overcome-500-items-limit-in-powerapps/
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

@MayankP It says that we cannot go for 2K+ rows. but I can patch above 2k+ rows. Am I missing something?
MayankP 464 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Anonymous ,

I guess you can add following on "onChange " property which should update dropdown value on relevant excel row..
Patch([Data source], ThisItem, {[ColumnNameFromSharepoint]: [NameOfDropDown].Selected.Value})