Answered

Power App collection - show in gallery question

(0) Share

Report

Posted on by Ts01

Hi all,

I have a collection called 'colChat' and a button with onSelect calling a custom connector that utilises GPT-3.5-turbo api.

The onSelect code is like this:

Set(
 varResponse,
 'GPT-35-Turbo-API-Connector'.GPT35TURBO(
 "gpt-3.5-turbo",
 Collect(
 colChat,
 {
 role: "user",
 content: TextInput1.Text
 //content: Concatenate(enfPr, TextInput1.Text)
 }
 )
 )
);

Collect(
 colChat,
 First(varResponse.choices).message
);

colChat is the data source for a gallery where the user sees his own prompt as well as api's response. I want to concatenate a string called enfPr with the users prompt (which is typed in TextInput1 textbox) but in that case the user also sees the enfPr string in the gallery. Is there anyway this can be avoided?

I could alternatively write the api call like this if it could help:

{role: "user", content: enfPr},
{role: "user", content: TextInput1.Text}

I hope what i wrote is making sense... Thanks a lot in advance.

Categories:

Building Power Apps

I have the same question (0)

All responses (10)

Answers (3)

Verified answer

leonsig93 229 on at

Like (0)

Report
Are you just trying to get rid of the enfPr part of your string once you have what you need?

If that's the case, you could try using Split if you have a natural consistent break point between the enfPr and the text from TextInput1.

So it would look something like:

Last(Split(YourConcantenatedValue, "Separator")).Value

Split would cut it in half and create a two row table and then you use Last to retrieve the second piece without the enfPr (which would be the first). So you still have the concatenated value created, but just take what you need.

EDIT - Forgot to add .Value at the end there

Was this reply helpful? Yes No
Verified answer

Ts01 42 on at

Like (0)

Report

Hey there,

Thanks for getting back. What i want is to pass the concatenated string to the api call but only store the TextInput part of it in the collection. I am not sure i understand where to use the split you proposed.

Was this reply helpful? Yes No
Verified answer

leonsig93 229 on at

Like (0)

Report
You would use the function inside your gallery where you are displaying colChat.

I also think I misunderstood, but if the "enfPr" is static then you would want to use the Mid function instead. If not use the Split like I mentioned before.

So leave your OnSelect as is:
Set( varResponse, 'GPT-35-Turbo-API-Connector'.GPT35TURBO( "gpt-3.5-turbo", Collect( colChat, { role: "user", content: Concatenate(enfPr, TextInput1.Text) } ) ) ); Collect( colChat, First(varResponse.choices).message );

Then in the gallery that you are displaying colChat, go to whatever control you are using to display the info. In my case I used a Label. I created a field called content like yours and a second one to show only the TextInput.

On the Label that I'm displaying the TextInput, I set the Text property to this:
Mid(ThisItem.Concatenated, 6)

This breaks up the concatenated string you created for the call. The 6 tells it to keep everything after the last 'r' of erfPr. If you do it this way you are still going to store the concatenated value in colChat, but you only show them the TextInput.

Was this reply helpful? Yes No
Ts01 42 on at

Like (0)

Report

No, enfPr is a variable not static. You got it right in the first place. Thank you so much.

I am so so sorry but by mistake i clicked "Accept as solution" in my own post... Is there anyway i can undo that?

Was this reply helpful? Yes No
leonsig93 229 on at

Like (1)

Report

I'm not sure if there is a way to unmark something as a solution, but don't worry about it! All that matters is that we got you the answer you were looking for 👍🏼👍🏼

Was this reply helpful? Yes No
Ts01 42 on at

Like (0)

Report

Thank you so much.

Was this reply helpful? Yes No
mark_fleet 6 on at

Like (0)

Report

Along the same lines, hoping someone can help. I am getting an error when trying to use the code below. Says the number of arguments is wrong, received 2, expecte 0-1.
Set(
varResponse,
'GPT_Test'.ChatAPI("gpt-4-32k",Collect(colChat,
{
role:"user",
content:TextInput2
}
))
);
Reset(TextInput2)

This code is for the OnSelect button that takes the inputted text from TextInput2, calls gpt-4 via api, then i collect the response to display colChat. GPT_Test is my custom connector which i have tested and works fine.

Can someone help me?

Was this reply helpful? Yes No
leonsig93 229 on at

Like (0)

Report
First just checking I have this correct:

Set( varResponse, 'GPT_Test'.ChatAPI( "gpt-4-32k", Collect( colChat, { role:"user", content:TextInput2 } ) ) ); Reset(TextInput2)

So a couple things:
Add .Text to your line content: TextInput2, otherwise it won't pull whatever was inputted.
So it should now be -> content: TextInput2.Text
The error message is making me think you don't have enough variables set up in your flow. It usually says that when you are passing too much to the Power Automate flow so double check and make sure you have your flow set up correctly.
For example, "gpt-4-32k" variable #1
Your Collect function is variable #2, hence the received 2 part of your message
So in your flow you should be asking for two variables from PowerApps
Check and see if that works, if not definitely grab some screenshots of your flow if you can so we can figure out what's going on.

Was this reply helpful? Yes No
mark_fleet 6 on at

Like (0)

Report

I am not using a power automate flow but a custom connector in power apps. Here is the request and response of the connector as an example:

REQUEST
URL: https://msmanaged-na.azure-apim.net/apim/gpt-5ftest-5fe5e1fd276b03232e-5f58172779bbf487ab/7f961c9073...
Method: post
Header: {
"Authorization": "Bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJSUzI1NiIsIng1dCI6Ii1LSTNROW5OUjdiUm9meG1lWm9YcWJIWkdldyIsImtpZCI6Ii1LSTNROW5OUjdiUm9meG1lWm9YcWJIWkdldyJ9.eyJhdWQiOiJodHRwczovL2FwaWh1Yi5henVyZS5jb20iLCJpc3MiOiJodHRwczovL3N0cy53aW5kb3dzLm5ldC8wZTE2MDliMC01ZTdmLTQ3MjItODYxMS1jN2YzMDY3Y2ViZGMvIiwiaWF0IjoxNjg2MDYzMDk1LCJuYmYiOjE2ODYwNjMwOTUsImV4cCI6MTY4NjA2ODUxOSwiYWNyIjoiMSIsImFpbyI6IkFUUUF5LzhUQUFBQStzVHVSWXdGZDdUd1k5a3FNOC81MVpIWHhUV05tcHZkQmNrT2twRHZTUnkrQUxHSWlEUXp2WEw5WnRHcGUyamwiLCJhbXIiOlsicHdkIl0sImFwcGlkIjoiN2RmMGExMjUtZDNiZS00Yzk2LWFhNTQtNTkxZjgzZmY1NDFjIiwiYXBwaWRhY3IiOiIyIiwiZmFtaWx5X25hbWUiOiJGbGVldCIsImdpdmVuX25hbWUiOiJNYXJrIiwiaXBhZGRyIjoiMjA4LjEyNy4yNDUuMTYyIiwibmFtZSI6IkZsZWV0IGpyLCBNYXJrIiwib2lkIjoiYjU3NTE1NjEtM2ZkZS00OTdiLTlhZmEtMGUxYTQyOWZlYTkzIiwib25wcmVtX3NpZCI6IlMtMS01LTIxLTg2OTAxNjkxMC0xNjYwNzg5NDAtNjIxNjk2MjE0LTczMzIzOCIsInB1aWQiOiIxMDAzN0ZGRTg2NzUwQzM0IiwicmgiOiIwLkFRY0FzQWtXRG45ZUlrZUdFY2Z6Qm56cjNGODhCZjZTTmhSUHJ2THVOUHdJSEs0SEFCby4iLCJzY3AiOiJ1c2VyX2ltcGVyc29uYXRpb24iLCJzdWIiOiI1NVZTbzRqdG02OTIxd0FRTFFXaU9NUWpJVER4YkxUYUpIX0VwV01sSkJzIiwidGlkIjoiMGUxNjA5YjAtNWU3Zi00NzIyLTg2MTEtYzdmMzA2N2NlYmRjIiwidW5pcXVlX25hbWUiOiJNYXJrLkZsZWV0anJAQk5TRi5jb20iLCJ1cG4iOiJNYXJrLkZsZWV0anJAQk5TRi5jb20iLCJ1dGkiOiI1WkFCRURxaVdFZV9nZURqczdSMEFRIiwidmVyIjoiMS4wIn0.Qy6ArhuyN4E6QYD9r8RVrZsaxiQPlQ1gZg4alpPFpw1rq8oIOF1D2S4vpZFrPB7r5gA3MUGHjCz9q3UIysnep0PYSWOnOhaO1HCWcLwa_Bl-QBhxtghXmMyYHsjp-ONM7rGhsindZpaRHJfNPNq-JPAuC-8wNSwXxrEi672vS0UMndJjYcNGOwuZ45KBTZoR_TXhoZAsNff7Yoj-KVElscNov63OHW1GoJTal6EGFYPX9bbC-o4LpmPZLsOkNdF33OpViDBGzyvg_k2WPzeRUS0Uo7yLnsSCd9jyRrlkZ7uR0TbrfQE_h5sPp-IRi78DHx7SpYtsmg4lhrRpzqx7OA",
"Content-Type": "application/json",
"api-key": "(removed for security)"
}

Body:
{
"messages": [
{
"role": "user",
"content": "How are you?"
}
]
}
Schema validation:
Validation succeeded

RESPONSE
Status: (200)
Headers:
{
"apim-request-id": "2ee9abb3-cbb4-4940-afef-ef0f614c85b0",
"azureml-model-group": "online",
"azureml-model-session": "aoai-gpt4-05222023-2",
"cache-control": "no-cache, must-revalidate",
"content-length": "398",
"content-type": "application/json",
"date": "Tue, 06 Jun 2023 14:57:34 GMT",
"openai-model": "gpt-4-32k",
"openai-processing-ms": "3893.9762",
"strict-transport-security": "max-age=31536000; includeSubDomains; preload",
"vary": "Origin",
"x-accel-buffering": "no",
"x-content-type-options": "nosniff",
"x-ms-apihub-cached-response": "false",
"x-ms-apihub-obo": "false",
"x-ms-client-request-id": "2ee9abb3-cbb4-4940-afef-ef0f614c85b0",
"x-ms-region": "South Central US",
"x-request-id": "a7e5ded4-54d7-4eda-a0d6-98e0464341b4"
}
Body:
{
"id": "chatcmpl-7OSPiRKmIb8ZNz0FId2WgxBIpyBPM",
"object": "chat.completion",
"created": 1686063450,
"model": "gpt-4-32k",
"choices": [
{
"index": 0,
"finish_reason": "stop",
"message": {
"role": "assistant",
"content": "As an AI, I do not have emotions or feelings, but I am here and ready to assist you with any questions or tasks you have!"
}
}
],
"usage": {
"completion_tokens": 29,
"prompt_tokens": 11,
"total_tokens": 40
}
}
Schema validation:
Validation succeeded

Was this reply helpful? Yes No
leonsig93 229 on at

Like (0)

Report

Ah my mistake.
Based on the error message, my guess is that it has to do with your Body. You list 'message' and then inside of that have 'role' and 'content'. Any chance you may need to concatenate the fields into a single argument/string called message?

Was this reply helpful? Yes No