Adding a new item in ComboBox that is then saved in SharePoint as a new choice

(1) Share

Report

Posted on by nleuck_101

429

Hello All,

I have a editable gallery similar layout similar to what Reza did in this video https://www.youtube.com/watch?v=76RJyaoW0BQ. I don't use the modern controls and had to switch back to the classic after watching a Shane Young video. I would like for my user's to be able to add a new item for other users to select from on a different screen. The data source is a SharePoint list. Users currently can add new items to the gallery but when they save the newly added item it does not appear in the list as a selectable option for the other users. I watched Shane Young's video https://www.youtube.com/watch?v=TH6oqsfxPaE, but I'm running into an issue with my formula around the 19:39 mark. I'm not sure how to solve this and any help would be greatly appreciated. Thanks!

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (0)

Suggested answer

developingteal 392 on at

Like (1)

Report

I haven't watched the video, but it seems you are just having a simple type mismatch per the error. I would look at the data source, and see if you are intending for it to accept a boolean or record. Also your if statement and isblanks are pushing out boolean values here, which is then going to the column AI topics.

I don't fully know what you are trying to accomplish, but currently you are pushing a boolean value to AI Topics, which presumably is not what you are trying to do.

Was this reply helpful? Yes No
nleuck_101 429 on at

Like (1)

Report

The AI Topics is a choice column in my SharePoint list. In my Power Apps I want my admin users to be able to added new choices to the list from the Admin screen. Previously I was able to add them to the list but the new choice wouldn't be an option to select from. On the front end of the SharePoint list you can see the new choice but on the back end of available choices, the newly added choice is not there. Shane Young's video shows how to do this with a flow but I'm getting an error with the incompatible type. Not sure what I'm doing different.

Was this reply helpful? Yes No
Suggested answer

nleuck_101 429 on at

Like (1)

Report

So I got something to work but not exactly the way I was hoping. I removed the HTTP request flow and just this instead.

This does allow for user to select a new choice in the app as expected. But it does not save it as a choice in the SharePoint list which could be a problem. As of right now it's working as expected in the power app.

Was this reply helpful? Yes No
WarrenBelz 153,073 Most Valuable Professional on at

Like (2)

Report
Shorter version
'AI Topics': { Value: Coalesce( AI_Topics_Combobox.SearchText, AI_Topics_Combobox.Selected.value ) }

Was this reply helpful? Yes No