cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
chriss59194
Frequent Visitor

newform (newform)

Bonjour,

 

je revient vers vous car j’ai une galery1 avec une liste d’éléments, quand je clic sur un élément onselect : Navigate(FORM1)

une fois dans mon formulaire j’ai un champs ID qui reprend mon ID de ma galery1 sélectionné, Item :LookUp ('FORM1';ID = galery1. Selected.ID)

 

ce formulaire fait un enregistrement sur une source de donnée google Sheets autre que celle de ma galery1

 

par contre j’ai besoin de votre aide car quand je clic sur enregistrer : SubmitForm(FORM1), il me modifie mes champs sur ma source de donnée google Sheets lié a mon ID, mes je voudrais qu’il me créer un nouvel enregistrement tout en gardant mon ID sélectionné sur ma galery1.

 

J’ai essayer avec newform (FORM1) mais ca ne marche pas.

 

MERCI

1 ACCEPTED SOLUTION

Accepted Solutions
v-qiaqi-msft
Community Support
Community Support

Hi@chriss59194,

Based on the issue you mentioned, do you want to create a new record for the Gallery selected ID?

Could you please tell me that if the data source you populate the Gallery shares the same ID column with the ID column in your Google sheet?

If you want to create a new record for the Google sheet using the Gallery selected ID, please try as follows.

Set the OnSeletc property of the Gallery as below:

Navigate(FORM1);NewForm(FORM1)

Set the DataSource property of the Form1 as below:

YourGoogleSheet

Set the Default property of the TextInput corresponding to the ID column in your Google Sheet as below:

galery1. Selected.ID

And then you could fill in the other controls to entry something.

Hope it could help.

Regards,

Qi

Best Regards,
Qi

View solution in original post

2 REPLIES 2
justinburch
Microsoft
Microsoft

Hi @chriss59194,

Apologies, je ne parle pas francais. But, it looks like your question is regarding PowerApps, whereas this is the forum for PowerApps Portals - a completely different product. Try this forum: Building Power Apps - Power Platform Community (microsoft.com)

v-qiaqi-msft
Community Support
Community Support

Hi@chriss59194,

Based on the issue you mentioned, do you want to create a new record for the Gallery selected ID?

Could you please tell me that if the data source you populate the Gallery shares the same ID column with the ID column in your Google sheet?

If you want to create a new record for the Google sheet using the Gallery selected ID, please try as follows.

Set the OnSeletc property of the Gallery as below:

Navigate(FORM1);NewForm(FORM1)

Set the DataSource property of the Form1 as below:

YourGoogleSheet

Set the Default property of the TextInput corresponding to the ID column in your Google Sheet as below:

galery1. Selected.ID

And then you could fill in the other controls to entry something.

Hope it could help.

Regards,

Qi

Best Regards,
Qi

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

365 EduCon 768x460.png

Microsoft 365 EduCon

Join us for two optional days of workshops and a 3-day conference, you can choose from over 130 sessions in multiple tracks and 25 workshops.

Top Solution Authors
Users online (4,069)