Forum Discussion

AlbertoPinon's avatar
AlbertoPinon
Frequent Visitor
1 year ago

Efficient Manual Data Input for LARGE numeric ranges?

I'm working on a Power BI report that includes inventory tracking with a barcode scanner. Here's what I need help with: Context: After scanning a product's barcode, the report filters to show that...
Need Help
Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi, AlbertoPinon 

In the case you mentioned, Power apps can be used with Power automate to implement data insertion or update. For a detailed tutorial, we recommend you read the full tutorial below:

Integrate Power Apps, Power Automate, and Power BI with SharePoint Online - Power Apps | Microsoft Learn

Power BI data write-back with Power Apps and Power Automate - Azure Architecture Center | Microsoft Learn

Although this article is about updating user input to dataverse, the same design process applies to Excel on SharePoint.
If you need to update your local excel, you need to place your excel in a local SharePoint folder and install the local data gateway so that Power Automate can read and write data smoothly.

 

 

Best Regards

Jianpeng Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.