Custom form adding in different info when saved

(0) Share

Report

Posted on by Lee5150

Hi all,

I have an issue with a custom SharePoint form adding incorrect info when the form is saved.

I have attached an image to show exactly what I mean.

I select a client, then the 'Region' dropdown filters to relevant regions for said client. This works as it should. However when saving the form the 'Region' column shows a value equal to the 'Site Name'. I can only assume that it's something to do with the formula in the dropdown.

The formula in the 'Region' dropdown is Filter(Customers, Name = 'Client Dropdown'.Selected.Name).

Does anyone have any idea why this might be happening?

Many thanks!

Categories:

Building Power Apps

I have the same question (0)

All responses (7)

Answers (0)

Sort by

Ethan_009 4,838 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Lee5150 ,

What's the optionset data for your Dropdown?
Does it contain all values as per 'Site Map'?
If yes, then you need to set the Region value as per current 'Site Name'

Hope this helps

Was this reply helpful? Yes No
Lee5150 21 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks Ethan,

I'm not sure what you mean by 'optionset data'. Apologies! I'm a Power Apps newbie I'm afraid.
The Client dropdown looks at the 'Title' column in a list called 'Customers'. The Region dropdown looks at the 'Region' column in the same customers list.

The customers list has multiple duplicated names in the 'Title' column and the 'Region' column has the region.

Title Region
Barratt Homes East
Barratt Homes West

So if i choose 'Barratt Homes' in the client dropdown I'd like to see East & West in the region dropdown. This all works perfectly, except when saving.

Apologies if you knew all of the above, and I'm just misunderstanding the terminology.

Thanks

Was this reply helpful? Yes No
Ethan_009 4,838 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Lee5150 ,

I have created a sample data and dropdown using collection to mimic your scenario:
Is this you are trying to achieve that you need to show only those Regions that is been filtered?

Then check my steps and you can use wherever required:
Note: Steps 1 & 2 is done to mimic your scenario, you can check from Step 3

Step 1: Created sample data

Step 2: I assigned values to each Area using dropdown collection and patched it as per your Table.

Step 3: I used the same filter as I did on my Gallery and then used Distinct based on the Region column

That's how I got only those Regions for which I filtered my Gallery

Hope this helps

Was this reply helpful? Yes No
Lee5150 21 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks Ethan,
Yes that is what I need, and I have it working just like that in a custom form on SharePoint. The issue is when I come to save the form, the 'Region' field doesn't populate with chosen region, it somehow populates with and 'Site Name' instead. It's very strange!

Was this reply helpful? Yes No
Lee5150 21 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Ethan,

Please see this link to a quick video of my issue.
https://share.vidyard.com/watch/Yd3WH9TYrn6Jgkp84V8Xek?

Many thanks for you help!

Was this reply helpful? Yes No
Ethan_009 4,838 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Lee5150 ,

Yes that's very strange behavior also, that's SP form.
Even I'm not sure what's the main cause but I hope you don't have multiple fields named 'Region' as you might be something else

Also, based on your Video, when you selected East Hams record, your Client holds different value compared to the Form on the right.
Ensure that the column settings has no Default property in SP column settings.
Hopefully this fixes the issue else you need to check this with MS Support.

Was this reply helpful? Yes No
Lee5150 21 on at

Like
a
(0)

Report
Copy link

Link copied!

I've fixed it!

So the update field of the Region Datacard was set to 'DataCardValue_1' which was the Site Name!!! I've no idea why it was set to that I'm so glad it's fixed! Finally!

Thanks for all your help!

Was this reply helpful? Yes No