Unanswered

Patch For Excel

(0) Share

Report

Posted on by Community Power Pla...

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

I have the same question (0)

All responses (3)

Answers (0)

MayankP 464 on at

Like (0)

Report

refer following article for this..

https://michalguzowski.pl/how-to-overcome-500-items-limit-in-powerapps/

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

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

Was this reply helpful? Yes No
MayankP 464 on at

Like (0)

Report
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})

Was this reply helpful? Yes No