cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
tuonoman
Helper IV
Helper IV

upload data from edit form to excel table

Hello

 

In an Edit form I use a table named "product" to display certain values to be modified.
In my Excel table (which is the source of my application) the "Product" table contains the supplier IDs of my products.
Thanks to the help of the contributors of this forum, I convert on my " Detail Product " page the ID_Provider to " Provide Name ".
In my Product Editing page I would also like the "Provide Name" to be displayed as a list of choices instead of the "Provider_IDs" on my Product Detail page.
However, when registering it must be "ID_prodiver" which is to be entered in the "product" table and not "Provider_Name".
I have the impression that everything is set in the "Action" parameters of the DataCardValue.


Can you advise me?

1 ACCEPTED SOLUTION

Accepted Solutions
Drrickryp
Super User II
Super User II

@tuonoman 

It would be the name of the field that you wish to save in the table.  Something like: yourdropdownnamehere.Selected.ID_Tag

It doesn't matter what is shown in the window of your dropdown, you select the field from the parent record that you want saved in the card. 

View solution in original post

6 REPLIES 6
rubin_boer
Super User
Super User

Hi @tuonoman 

 

If my understanding is correct you wish to change the display name of the control.

 

Unlock the control by right clocking on it and click unlock

rubin_boer_1-1612682014397.png

Select the text propert of the label

rubin_boer_2-1612682114470.png

 

change the Parent.DisplayName

rubin_boer_0-1612681895063.png

 

Hope this is what you are looking for.

 

If my post helps, then please consider Accept it as the solution to help others. Thanks.

 

 
tuonoman
Helper IV
Helper IV

@rubin_boer 

 

I am sorry if my message is not clear.
So ! I have an Excel table with a "Product" and "TAG" table.

Product table.pngTag table.png

 

In my application I have a gallery that lists my products, thanks to a formula I correctly reassemble the "TAG_NAME".

 

With(
    {
        _items: Search(
            AddColumns(
                PRODUCT As _product;
                "TAG_NAME";
                LookUp(
                    TAG;
                    ID_TAG = _product.ID_TAG;
                    TAG_NAME
                );
                "PROVIDER_NAME";
                LookUp(
                    PROVIDER;
                    ID_PROVIDER = _product.ID_PROVIDER1;
                    PROVIDER_NAME
                )
            );
            tdSearchinput.Text;
            "PRODUCT_NAME";
            "TAG_NAME";
            "PROVIDER_NAME";
            "MANUFACTURE"
        )
    };
    ForAll(
        Sequence(CountRows(_items));
        Patch(
            Last(
                FirstN(
                    _items;
                    Value
                )
            );
            {LineNumber: Value}
        )
    )
)

 

 

Product page powerapps.png

 

In the detail page I also correctly load the "TAG_NAME".

 

Product detail page powerapps.png

 

Where I'm not very comfortable is on the "Product Edition" page.
How can I make sure that "TAG_NAME" is displayed and not "ID_TAG".
But that when I save it is "ID_TAG" which is saved in the Excel table "PRODUCT".

 

Product edition page powerapps.png

 

Ideally the "TAG_NAME" should be displayed as a drop-down menu.
I hope my explanations are clearer.
Thank you for your help the community

 

 

Drrickryp
Super User II
Super User II

@tuonoman 

In a form, there are really only two important properties, the Update property of the card the and Default property of the control inside.  To accomplish your goal, unlock the card, hide the textbox inside and put a  dropdown control  inside the card.  A dropdown control selects a record from a table but displays only one field in the window.  However, all of the fields in the record can be referenced.  After reshaping your Products table to include the tag name you can use that as the items property of a dropdown and display the tag name in its window by selecting it in the Value dropdown on the right side of the screen.  If the dropdown is now in the 'ID produit' card, set the Default to Parent.Default and the Update to Dropdown1.Selected.'ID produit'. 

 

 

tuonoman
Helper IV
Helper IV

@Drrickryp @rubin_boer 

I managed to integrate the drop-down menu with my "TAG_NAME" as a list of choices.
But I can't manage to save the values in the "product" table.
Any ideas?

 

Product edition page powerapps tag name 2.png

 

I think I need to indicate a value in "update" But what?

 

Product edition page powerapps tag name 3.png

Drrickryp
Super User II
Super User II

@tuonoman 

It would be the name of the field that you wish to save in the table.  Something like: yourdropdownnamehere.Selected.ID_Tag

It doesn't matter what is shown in the window of your dropdown, you select the field from the parent record that you want saved in the card. 

View solution in original post

tuonoman
Helper IV
Helper IV

@Drrickryp 

 

Perfect , that works

 

Thank you

Helpful resources

Announcements
PA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

PA Community Call

Power Apps Community Call

Next call is happening on April 21st at 8a PST.

MBAS Carousel

Sign up for our May 4th event!

May the fourth be with you, join us online!

secondImage

Experience what’s next for Power Apps

See the latest Power Apps innovations, updates, and demos from the Microsoft Business Applications Launch Event.

Top Solution Authors
Top Kudoed Authors
Users online (19,380)