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

Like (1) Share

Report

Posted on 1 Aug 2024 13:35:50 by nleuck_101

353

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:

Using Apps Using Formulas

General Questions

All responses (4)

Answers (1)

WarrenBelz 146,947 Most Valuable Professional on 08 Aug 2024 at 23:11:13

Like (2)

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

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

nleuck_101 353 on 08 Aug 2024 at 20:18:38

Like (1)

Report

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

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.
nleuck_101 353 on 02 Aug 2024 at 13:23:26

Like (1)

Report

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

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.
Suggested answer

developingteal 392 on 01 Aug 2024 at 19:49:34

Like (1)

Report

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

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.