Hello, could somebody please advise if what I am trying to do is possible with Power Apps and SharePoint? Or some other way it could be done?
I want an interface on a page in our extranet where users can provide an ID number and an RPA bot picks this up, queries a remote system with the ID number, then returns key information to the user within the same page (interactively). I know it would be a lot easier to simply email them the query result but this would be much more user friendly and faster (in theory).
I have made a SharePoint list with all the required columns and a form in Power Apps with only the ID column visible. On submission this is emailed to the bot using Power Automate. I embedded this Power App into a SharePoint page and it works fine although this is quite slow.
Originally I tried Microsoft Forms but due to the way our AD is structured it is not suitable as the users would be outside of our organization and we don't want the Form to be public.
I notice that there are webhooks and web parts in SharePoint Online, would this be how I do it? I'm trying not to get too deep into web development as this would potentially be too expensive for the purpose.
Any help would be greatly appreciated, thanks.
