Responding to user query interactively using SharePoint List (delayed response)
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.
Sorry for the late reply. Just back from vacation.
Based on the issue that you mentioned, do you want to make external users query information from the SharePoint?
Actually, there is no way to achieve this directly in Power Apps currently.
To catch everybody up, webhook is a pattern/practice that has been around for a few years now.
It allows for us to develop applications that are event-driven. Rather than using the traditional polling mechanism, webhooks allow you to code a push concept where the application listens for events to occur and then does something.
Remote event receivers required wcf projects to be created and registration is not simple.
For more details, you could check the following blog for reference.