182 Members

Join now

Sign in with your Microsoft Power Platform Community account

If you don’t have a Community account, you can create one.

Share group

Location

Details

Group leaders

FraserCDear

Discussion

Join the group to participate in the discussion.

GreenFrog 53 on

Like (0)

Hi,

I am new to PowerApp and spent days trying to get the below to work.

I have two collections: colSelected which has just one column called Pas2 with a table which comes from dataverse multi select columns. The other collections has two columns, id which is autonumbered and Pas1 which is a column of tables which comes from a dataverse table of multi select choices. Pas1 and Pas2 could the same choices available and I am trying to fitler these two tables to get a list of numbered id where any of these options match. E.g. if Pas1 has apple, banana, and grape and Pas2 has just apple and banana there should be a match and number id is filtered and stored in a collection.

My code I used is

ClearCollect(

colSelected,

ForAll(

colRelevantPandas,

If(

Pas1 = colSelected.Pas2,

ThisRecord

)

powerapps does not like a table to be compared against another table so I am really stuck on how to proceed.

Any help would be really appreciated. Thanks for looking at this

Show previous comments

gewideas 2 on

Like (0)

I just joined the group.

Use the below logic code

ForAll(

Filter(Pas1, Item in Pas2),

Collect(MatchedItems, {NumberID: Pas1[@NumberID]})

)

Please also note the below information.

1. MatchedItems is the name of the new collection to be created. You can replace this name with a more suitable name you desire.

2. Replace `Item` with the actual column name in your collections that contains the values (e.g., /Fruit/).

I hope this would be helpful.

SteveSimpson73 on

Like (0)

I've retrieved a list of users from a Business Central API in Power Automate and need to then return it into PowerApps to use within a Gallery....I can see the JSON without PowerApps but can't work out how to get it into the gallery.... The online tutorials aren't helping!!

Any help would be appreciated.

Show previous comments

UserE on

Like (0)

Hello,

Hope someone can help.

Since switching to Dynamics 365 new layout, some of the custom fields are not showing for some users. Have deleted the cache and cookies and opened in different browsers and still the same problem.

The "Reject" button is also missing in the "Approval Manager" therefore managers are can't reject timesheets.

Has anyone come across these problems or does anyone have a solution for them, greatly appreciated.

Thank you in advance!

Show previous comments

SolopJr 30 on

Like (0)

Hello, have some problems with SubmitForm. When I took data in my form and try to Submit it by OnSelect Button and got an error: "The data source supplied to the function is invalid". Will be thankful for any help!

Show previous comments

Big_Blue_Bear 56 on

Like (0)

Hi, I have an developed an app, and there is a gallery of items to choose from that feeds a form. All fed from SharePoint Lists. I can select individual gallery items or search across the gallery....all works with no issues

On selecting a gallery item then it navigates to full details of the item selected in a new screen. All works as designed.

When I use the search functionality to locate & select a gallery item the selected item, flashes on the new screen then defaults to the previous selected item. Despite having a ResetForm statement when I submit the form.

I've tried resetform on selection of submit button, ive tried reset form onsuccess......but neither seem to be effective or they are being over ridden to the original form content.

Any assistance would be gratefully received.

Show previous comments