Hi @Hywel, Yes, it is possible to create a Power App that replicates the functionality of your Excel file. Power Apps allows you to build custom apps without writing code, and it can be a great tool for automating processes and managing data.
Below are few points of how you could approach building this app in Power Apps:
Data Source:
Import your Excel file into a data source that Power Apps can use. Common choices include SharePoint, OneDrive, or a direct connection to the Excel file.
App Design:
Create a canvas app in Power Apps.
Design the app interface with appropriate screens for data entry and viewing results.
Data Entry:
Add a screen for users to paste a single column of data.
Data Transformation:
Create a formula or a series of actions to modify the data based on the rules you have in the second tab of your Excel file.
Search and Mark:
Implement a mechanism to search the modified data against the third tab and mark the appropriate rows in the first tab.
Power Apps provides various controls and functions to help you achieve these steps. For data transformation, you can use functions like Replace(), Concatenate(), or custom formulas. For searching, you can use functions like Lookup() or Filter().
Depending on the complexity of your transformation rules, you might need to use Power Automate in conjunction with Power Apps to achieve certain tasks.
I would suggest you Reza's YouTube series of Power Apps for Beginners which consist around 51 videos and which can help you: https://www.youtube.com/playlist?list=PLTyFh-qDKAiFUEgsXoQ9E-LJu4lcS0iMI
-----------------------------------------------------------------------------------------------------------------------------
I hope this helps.
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.👍
Thanks,
ANB
