May 17 | Demo: ChatGPT - but with YOUR data in Power Apps | R. Rosengrun

[DavidWarner]

Community Call:  May 17th, 2023, Power Platform Community Call 

Demo: ChatGPT - but with YOUR data in Power Apps

Presenter: Robin Rosengrün | @R2Power  | Twitter 

On this board, you will be able to continue the conversation with the speaker if you have any questions that you would like to ask about the presentation. 

Did you miss the Community Call, or would you like to view it again?

• May 17 | Power Platform Community Call | Main Meet... - Power Platform Community (microsoft.com)

Thank you for being part of our community! 

Power Platform Engagement Team  

[R2Power]

If you have any questions, please keep them coming!

As I said on the call the OpenAI Embeddings endpoint will be available in the Open AI Independent Publisher Connector in 2-3 weeks.

When the changes are deployed I'll provide a sample in the sample-repo (of the first easy examples I showed).

If you want to build the movie-search app here are the steps you need to do:

1. download sample dataset from IMDB https://developer.imdb.com/non-commercial-datasets/
2. import to a dataverse table (I used a dataflow)
3. create vector database through https://www.pinecone.io/ (there is a UI, no code required - also free trial, no credit card required)
4. automate writing Plots for the movies in Power Apps or Automate (with the OpenAI connector) and store to dataverse
5. create a string containing movie title, genres and plot and create an embedding vector
6. store IMDB ID + vector in Pinecone (you need to create a custom connector to Pinecone first)
7. create an Interface for the movie search (I used this Template: https://github.com/pnp/powerapps-designtoolkit/)
8. create embedding of the search term
9. query vector database (again you need a second endpoint to the Pinecone API)
10. merge data with the dataverse table
11. create elaborate prompt for ChatGPT to output a text. Provide the movies metadata in the prompt so ChatGPT has access to this information

Let me know if you need any help! If there is interest I can offer a longer session where we go through all of these steps

[PowerAppsAddict]

Hi @R2Power . This is awesome. Can we please have a longer session where we can see all the steps required?

[malakmoaty]

Hey Robin. This is fantastic thanks a lot for sharing. Just wondering if you could share the code you used to work out the similarity please? thanks a lot

[SimonSays]

I’m really interested to see the sample code. Steps 5 onwards would be very helpful to get some more guidance on.