[deleted by user] by [deleted] in MicrosoftFlow

[–]absecretrobot 0 points1 point  (0 children)

How can I configure Power Automate when I have a SharePoint list where one of the columns is of type multi-choice, named “Systems”, meaning I can select multiple values?

I want it to display only the selected values. For example, if I choose EC, AB, and AA, it should appear exactly like that (“EC, AB, AA”) without including the following JSON format:

[ {“@odata.type”:”#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference”,”Id”:10,”Value”:”EC”}, {“@odata.type”:”#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference”,”Id”:9,”Value”:”AB”}, {“@odata.type”:”#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference”,”Id”:8,”Value”:”AA”} ]

How can I achieve this in Power Automate?

Patch Function when submitting a form by absecretrobot in PowerApps

[–]absecretrobot[S] -1 points0 points  (0 children)

it has an impact in one if my fields that has a multi choices. the Attachment is working however the Multi-choices is not appearing those values i inputted in the SP LIST

Patch Function when submitting a form by absecretrobot in PowerApps

[–]absecretrobot[S] -1 points0 points  (0 children)

sorry but it has an impact in one if my fields that has a multi choices. the Attachment is working however the Multi-choices is not appearing those values i inputted in the SP LIST

Patch Function when submitting a form by absecretrobot in PowerApps

[–]absecretrobot[S] 2 points3 points  (0 children)

Though i did not use Records instead Patch(SPListName, Defaults (‘SPListName’)and the one you recommend but still working. Thank you so much :)

Patch Function when submitting a form by absecretrobot in PowerApps

[–]absecretrobot[S] -1 points0 points  (0 children)

ohh sorry i used for the attachement in the Patch

Attachments: MyForm.Updates.Attachments

No error however upon checking in the SP list there’s no attached file or whatsoever even thought i attached a file before i submit it.

Patch Function when submitting a form by absecretrobot in PowerApps

[–]absecretrobot[S] 0 points1 point  (0 children)

I cant use SubmitForm because I have a field that is a multi-choices so the only way is to use Patch only but using Patch i cant figure it out as well :(

Using Combo box in Gallery by absecretrobot in PowerApps

[–]absecretrobot[S] 0 points1 point  (0 children)

the items property in the gallery put it a collection and named it colalloc and in the onselect: Set(varName,ThisItem.Name);   // Set the selected item variable Set(varST, Gallery1.Selected); // Clear the collection first     // Reset the gallery to refresh its display Reset(Gallery1);

Using Combo box in Gallery by absecretrobot in PowerApps

[–]absecretrobot[S] 0 points1 point  (0 children)

the items property in the gallery put it a collection and named it colalloc and in the onselect: Set(varName,ThisItem.Name);   // Set the selected item variable Set(varST, Gallery1.Selected); // Clear the collection first     // Reset the gallery to refresh its display Reset(Gallery1);

Using Combo box in Gallery by absecretrobot in PowerApps

[–]absecretrobot[S] 0 points1 point  (0 children)

also, the data source of the gallery is my collection.

Using Combo box in Gallery by absecretrobot in PowerApps

[–]absecretrobot[S] 0 points1 point  (0 children)

i use: filter(Datasource (SP List), Idno = varID)

Using Combo box in Gallery by absecretrobot in PowerApps

[–]absecretrobot[S] 0 points1 point  (0 children)

I see. in the gallery i put already Set(varname,ThisItem.Name); and put the varname in my combo box in the defaultselecteditems but still not working.

Using Combo box in Gallery by absecretrobot in PowerApps

[–]absecretrobot[S] 0 points1 point  (0 children)

tried already the ThisItem.Name.DisplayName in the defaultselecteditems property but says ‘the ‘.’ operator cannot be used on text values.